当前分类： 1Z0-052
问题：多选题Which two activities are NOT supported by the Data Recovery Advisor DRA（）ARecover from failures in the RAC environment.BDiagnose and repair a data file corruption online.CDiagnose and repair a data file corruption offline.DDiagnose and repair failures ...
查看答案
问题：多选题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...
问题：多选题You executed the following command to create a tablespace called SALES_DATA： CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）AThe database automatically d...
问题：单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）A Host naming methodB Local naming methodC External naming methodD Directory naming metho...
问题：多选题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...
问题：多选题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...
问题：多选题User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） * ERROR at line 1： OR...
问题：单选题View the Exhibit and identify the component marked with a question mark. （）A Checkpoint （CKPT）B Process Monitor （PMON）C Archiver Processes （ARCn）D Recoverer Process （RECO）E Memory Manager process （MMAN）...
问题：多选题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...
问题：单选题For which database operation would you need the database to be in the MOUNT state（）A renaming the control filesB re-creating the control filesC dropping a user in your databaseD dropping a tablespace in your databaseE configuring the database instance ...
问题：单选题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...
问题：单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step t...
问题：多选题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 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....
问题：单选题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...
问题：多选题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...
问题：单选题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...
问题：单选题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...
