-
In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）
A . The optimizer statistics are collected automatically.
B . Only the timed operating system （OS） statistics and plan execution statistics are collected.
C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
-
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file, current SPFILE file, data files, and archived redo log
-
You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）
A . Mount the database
B . Open the database in NORMAL mode
C . Open the database in RESTRICTED mode
D . Open the database with the RESETLOGS optio
-
You issued the following statement in your SQL*Plus session： SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）
A . creating a table in your schema and you exceed your allocated space quota on the tablespace
B . executing a long query that involves a sort operation and the statement runs out of temporary space
C . loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
D . creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
-
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
A . backup of offline tablespaces
B . backup of readonly tablespaces
C . backup of systemcritical tablespaces
D . backup of online， locally managed tablespaces
E . backup of read/write dictionarymanaged tablespace
-
Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this（）
A . To limit the User Global Area （UGA） memory allocated to a session from the SGA
B . To limit the amount of memory to be used for the dispatcher queue of a session in SGA
C . To limit the amount of memory to be used for the request pool in System Global Area （SGA）
D . To control the amount of memory allocated in SGA for the local variables for each shared server proce
-
Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this（）
A . to limit the User Global Area （UGA） memory allocated to a session from the SGA
B . to limit the amount of memory to be used for the dispatcher queue of a session in SGA
C . to limit the amount of memory to be used for the request pool in System Global Area （SGA）
D . to control the amount of memory allocated in SGA for the local variables for each shared server proce
-
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
A . One tablespace has only one datafile
B . Many tablespaces can share one datafile
C . One tablespace can have many datafiles
D . One datafile can contain many tablespace
-
Your Oracle Database 10g is online when you execute the following statement： SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF； What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
A . The database does not record flashback logs for MY_TABLESPACE
B . The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
C . All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
D . None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
-
Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）
A . You can perform open database backups.
B . You can perform closed database backups.
C . You cannot perform schema-level logical backups.
D . You can perform the backup of only the SYSTEM tablespace when the database is open.
-
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）
A . adding a new user to the database
B . dropping a user from the database
C . dropping a table from the database
D . dropping a data file from a tablespace
E . adding a new tablespace to the database
-
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
A . Backup of offline tablespaces.
B . Backup of read-only tablespaces.
C . Backup of system-critical tablespaces.
D . Backup of online， locally managed tablespaces.
E . Backup of read/write dictionary-managed tablespaces.
-
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）
A . Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
B . Just back up the database datafiles without shutting down the database.
C . You will have to wait until you can shut down the database to perform the backup.
D . Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
E . Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backu
-
Examine the parameter setting in your database:
https://assets.asklib.com/images/image2/2018080215045780340.jpg
Which statement is correct about the database?（）
A . Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
B . The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
C . The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
D . Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startu
-
In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）
A . The optimizer statistics are collected automatically.
B . Only the timed operating system （OS） statistics and plan execution statistics are collected.
C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
-
The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）
A . Undo data becomes obsolete after 1，000 seconds.
B . Undo data gets refreshed after every 1，000 seconds.
C . Undo data will be stored permanently after 1，000 seconds.
D . Committed undo data would be retained for 1，000 seconds if free undo space is available.
E . Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.
-
Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）
A . Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.
B . Tell them that their request cannot be met with the current backup strategy.
C . Restore the 19ths backup， apply the online redo logs，and open the database.
D . Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo logs，and recover the database to the 20th.
E . Use the recover database command to roll back the database from today to the 19th of the month.
-
Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
A . The destination must be global only.
B . A maximum of five destinations can be assigned.
C . A maximum of ten different destinations can be assigned.
D . All the destinations are determined by the server automatically.
E . The destination may be local or remote for a Standby Database.
F . The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
-
Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified？（）
A . only the control file， the current SPFILE， and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file，current SPFILE file，data files，and archived redo log
-
In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）
A . Optimizer statistics are collected automatically.
B . Only timed operating system （OS） statistics and plan execution statistics are collected.
C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
-
In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
A . The database instance aborts.
B . The database operation temporarily halts till the member becomes available.
C . Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D . The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E . The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
-
in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）
A . Optimizer statistics are collected automatically.
B . Only timed operating system （OS） statistics and plan execution statistics are collected.
C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
-
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
A . Execute the ALTER DATABASE ARCHIVELOG statement
B . Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C . Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D . Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.
-
In your database, the flash recovery area （FRA) is configured as the default for RMAN back
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/4f3f38f4fa50f6813beecdb37f5e123f.jpg' />
A. Only one channel is allocated and the backup is created in the flash recovery area
B. Only one channel is allocated and the backup is created in the destination specified for channel
C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
-
In your L/C No245, the word “ABOUT” before the quantity and amount is（）.
A．miss
B．missing
C．missed
D．omit
