-
You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）
A . Event Viewer gives more details on the failure.
B . The alert log file gives detailed information about the failure.
C . PMON rolls back the transaction and releases the locks.
D . SMON rolls back the transaction and releases the locks.
E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
-
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）
A . Use the Database Resource Manager.
B . Set the limits in the profiles used by users.
C . Modify the SESSIONS initialization parameter.
D . Set the warning threshold for the Current Logons Count metric.
-
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
-
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command： LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）
A . The sessions are able to perform only queries.
B . The sessions are not affected and continue to function normally.
C . The sessions are terminated and the active transactions are rolled back.
D . The sessions are not allowed to perform any operations till the listener is started.
-
You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention 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 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 UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）
A . This operation resets the SCN for the database.
B . This operation creates a new incarnation of the database.
C . This operation moves all the redo log files to a different location.
D . This operation deletes the old redo log files and creates new redo log files.
E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）
A . This operation resets the SCN for the database.
B . This operation creates a new incarnation of the database.
C . This operation moves all the redo log files to a different location.
D . This operation deletes the old redo log files and creates new redo log files.
E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
-
our database is in the MOUNT state and you execute the following command to open it： ALTER DATABASE OPEN What two actions are performed as a result of this command？（）
A . All control files are opened.
B . All redo log files are opened
C . The password file is opened.
D . The parameter file is opened.
E . All online data files are opened.
-
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
A . All control files are opened
B . All redo files are opened
C . The password file is opened
D . The parameter file is opened
E . All online data files are opened
-
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）
A . The sessions are able to perform only queries.
B . The sessions are not affected and continue to function normally.
C . The sessions are terminated and the active transactions are rolled back.
D . The sessions are not allowed to perform any operations till the listener is started
-
In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？ （）
A . Undo data is retained until the next full database backup.
B . No committed undo data will be overwritten for 10 minutes.
C . Committed undo data will be kept forever if not overwritten within 600 seconds.
D . Guarantees that requested undo information are available until the instance is shut down.
-
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database？（）
A . drop and recreate the readonly tablespaces
B . rename the readonly data files to their correct file names
C . change the tablespace status from read/write to readonly
D . recreate the readonly tablespace because it is automatically removed
-
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
-
You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）
A . The backups would be consistent.
B . The backups would be inconsistent.
C . The backups would be possible only if the database is running in ARCHIVELOG mode.
D . The backups would be possible only if the database is running in NOARCHIVELOG mode.
E . The backups need to be restored and the database has to be recovered in case of a media failure.
-
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）
A . The backups would be consistent.
B . The backups would be inconsistent.
C . The backups would be possible only if the database is running in ARCHIVELOG mode.
D . The backups would be possible only if the database is running in NOARCHIVELOG mode.
E . The backups need to be restored and the database has to be recovered in case of a media failure
-
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 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
-
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）
A . The command restores only the missing control file.
B . The command restores all the control files.
C . The command fails because the database is running.
D . This is the correct way to address this problem.
E . This is not the correct way to address this problem.
-
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）
A . Use the Database Resource Manager.
B . Set the limits in the profiles used by users.
C . Modify the SESSIONS initialization parameter.
D . Set the warning threshold for the Current Logons Count metric.
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）
A . This operation resets the SCN for the database.
B . This operation creates a new incarnation of the database.
C . This operation moves all the redo log files to a different location.
D . This operation deletes the old redo log files and creates new redo log files.
E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
-
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.
-
Upon hearing the abandon ship signal，you put on your life jacket and report to your station. After the cover is removed you board your open lifeboat boat. The FIRST thing to do is to（）.
A . release the gripes
B . release tricing pendants
C . put the cap on the drain
D . lift the brake handle
-
Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use？（）
A.ALTERDATABASESalesMODIFYFILE(NAME=Sales dat3,SIZE=10GB)
B.ALTERINDEXALLONSales.Sales HistoryREBUILDWITH(FILLFACTOR=60)
C.EXECsys.sp_configure‘fillfactor(%)‘,‘60‘
D.UPDATESTATISTICSSales.Sales History(Products)WITHFULLSCAN,NORECOMPUTE
-
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17133996/81fcc055aa2594a8ac7bbd62b7b620ac.jpg' />
A. 4, 1, 3, 2, 5
B. 4, 3, 1, 2, 5
C. 2, 4, 3, 5, 1
D. 4, 2, 5, 3, 1
