当前分类： 1Z0-042
问题：单选题Initially， for the Automatic Workload Repository （AWR） statistics， the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memo...
查看答案
问题：多选题You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）AA backup of the target database when it is mountedBA back...
问题：单选题You execute the following command to audit the database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）A One audit record is created for the whole session if user SCOTT successfully ...
问题：单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A The user must be granted the database administrator （DBA） privilege.B The user must be listed in the password file for the authentication....
问题：Which two statements about Automatic Storage Management （ASM...
问题：单选题In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A flash back the databaseB perform point-in-time recoveryC perform a full ...
问题：多选题Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）Athe port used by the listenerBthe protocol used by the listenerCthe server name where the listener runsDthe log ...
问题：单选题The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance ...
问题：单选题Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener， database， and the configuration of the application. How would you avo...
问题：The data file belonging to the SYSTEM tablespace is corrupte...
问题：多选题You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snaps...
问题：单选题Your database is not configured for session failover. Your tnsnames.ora file contains the following details： test.us.oracle.com= （DESCRIPTION= （ADDRESS_LIST= （LOAD_BALANCE=off） （FAILOVER=ON） （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521））...
问题：单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables...
问题：单选题In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. Wh...
问题：单选题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？ （...
问题：多选题You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait t...
问题：单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）A until the last commitB canno...
问题：多选题You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapsh...
问题：多选题What are the consequences of executing the SHUTDOWN ABORT command？ （）AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed， but the instance is still started.DDatabase buffers and redo buffers are not wri...
问题：单选题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...
