You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

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.

A . 3 hours B . 6 months C . until last year D . until last commit E . until the point when the undotablespacewas refreshed F . until the database is shut down and the memory erased

A . Information about each Oracle Net connection. B . Information about each entry in theLinstener.orafile C . Information about the changed done in the database D . Information about the different listeners in your system E . Information about all thenondatabasefiles required to operate the database

A . The backup is similar to image copy. B . The backup contains all used data blocks. C . The backup contains only unused data blocks. D . The backup contains all data blocks changed since the last incremental level 1 backup.

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.

A . Set the UNDO_RETENTION parameter to AUTO. B . Create an initial undo segment in undotablespace. C . Set the UNDO_RETENTION parameter to 900 or more D . Set the initialization parameter UNDO_MANAGEMENT to AUTO E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

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

A . The user cannot use the role at all. B . The role would not be granted to the user. C . The user needs to enable the role explicitly. D . The user can start using the role immediately. E . The user would have the admin option for the role.

A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

A . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.

A . The Flashback Archive FLA1 is dropped only if it is empty. B . The tablespace having Flashback Archive is dropped. C . The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive. D . The Flashback Data Archive and historical data are dropped.

A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

A . A backup of the target database when it is mounted B . A backup of online redo log files when the database is open C . A backup of only used data blocks in the file beingbeingbackup up D . A backup of online， read/write data files when the database is open E . A backup of only those data blocks that have changed since a previous backup F . A backup of online， read/write data files when the database is in the NOMOUNT state.

A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

A . The DBMS_JOB package B . The BACKUP_JOB package C . The DBMS_BACKUP_RESTORE package D . The calendar tool in the Operating System （OS） E . The backup scheduler in Enterprise Manager （EM） F . The DBMS_BACKUP_SCHEDULER packager inline mode

A . It degrades the run time and compiler performance. B . It provides better run time and compiler performance. C . It provides better optimization of the statement during parse time. D . It forces the rule based optimizer to be used for statement optimization. E . It provides better run time performance but slightly degraded compiler performance.  F . It provides better run time performance but slightly degraded run time performance.

A . Information about each Oracle Net connection. B . Information about each entry in theLinstener.orafile C . Information about the changed done in the database D . Information about the different listeners in your system E . Information about all thenondatabasefiles required to operate the database

A . The user cannot use the role at all. B . The role would not be granted to the user. C . The user needs to enable the role explicitly. D . The user can start using the role immediately. E . The user would have the admin option for the role.

A . You can perform consistent backups only. B . You can perform a complete database backup without shutting down the database instance. C . You can back up data files only when all data files have the same SCN recorded in the control file. D . You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP command

A . You performed rollback after commit. B . If a log switch occurs in your database. C . Thearchiverfails to generate an archived log file. D . Instance recovery fails to find one of the redo log files. E . A long-running query is unable to get read-consistent image. F . If you perform manual undo management operations in auto mode.

A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

A . Assign the DEFAULT profile to the users B . Set the RESOURCE_LIMIT parameter to TRUE in the parameter file C . Create a new profile with CPU restrictions and assign it to the users D . Specify the users as members of the DEFAULT_CONSUMER_GROUP E . Revoke the DBA role and grant CONNECT and RESOURCE role to the user

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.

A . Assign the DEFAULT profile to the users B . Set the RESOURCE_LIMIT parameter to TRUE in the parameter file C . Create a new profile with CPU restrictions and assign it to the users D . Specify the users as members of the DEFAULT_CONSUMER_GROUP E . Revoke the DBA role and grant CONNECT and RESOURCE role to the user