当前分类： 1Z0-052
问题：多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）AThe backup performed on Sundays contains all the blo...
查看答案
问题：多选题Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysi...
问题：单选题You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option. - Use Oracle Enterprise Manager Database Control to manage the database. - Provide the same pass...
问题：You want to enable archiving on your database. Presently， th...
问题：多选题Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）AThe MTTR advisor will be disabled.BAutomatic checkpoint tuning will be enabled.CThe value for the LOG_CHECKPOINT_INTERVAL initialization...
问题：单选题Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3...
问题：多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on ...
问题：多选题Which two statements are true regarding Oracle Data Pump（）AEXPDP and IMPDP are the client components of Oracle Data Pump.BDBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.COracle Data Pump export and import operations ca...
问题：多选题You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue（）ADisable automatic checkpoint tuning.BCheck the size of the redo log file size and increase the size if it is small.CSet ...
问题：单选题The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FI...
问题：单选题Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）A Run the root.sh script.B Create the oraInst.loc file.C Create the tnsnames.ora file.D Run the oraintRoot.sh script....
问题：单选题The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN INSERT INTO...
问题：单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase. Which option of IMPDP would you use to accomplish this task（）A FULLB SCHEMASC TRANSFORMD REMAP_SCHEMAE REMAP_TABLESPACE...
问题：多选题Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）Adata filesBcontrol filesCparameter fileDonline redo log filesEserver parameter file...
问题：单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$...
问题：多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn...
问题：多选题Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the qu...
问题：多选题Which operations require undo data（）ACommitting a transactionBFlashing back a transactionCRecovering a failed transactionDRunning a read-consistent queryEChanging a tablespace status from READ ONLY to READ WRITE...
问题：单选题All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 ro...
问题：单选题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...
