You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

相似题目

• 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 work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）

  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

  查看最佳答案

• You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

  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

  查看最佳答案

• You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

  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.

  查看最佳答案

• 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 work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

  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

  查看最佳答案

• 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

  查看最佳答案

• You work as a database administrator for Certkiller .com. While granting a role，SELECT_CATALOG_ROLE， to a user， Certkiller， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）

  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.

  查看最佳答案

• You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting？（）

  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）.

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. 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 . 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.

  查看最佳答案

• You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）

  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.

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

  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）.

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）

  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.

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

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

  查看最佳答案

• You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

  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

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）

  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

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. While granting a role， SELECT_CATALOG_ROLE， to a user， SupportCenter， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）

  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.

  查看最佳答案

• You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）

  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

  查看最佳答案

• 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 . 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.&e

  查看最佳答案

• You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）

  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.

  查看最佳答案

• You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

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

  查看最佳答案

• You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？ （）

  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

  查看最佳答案

• 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.

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）

  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

  查看最佳答案