问题:多选题You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?()AYou are backing up to tape and your tape device performs its own compression.BYou are making image copies, and you have not ena...
查看答案
问题:单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in...
问题:多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming ...
问题:Which statement is true regarding subqueries?()...
问题:单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()A Allow the database to continue ru...
问题:多选题You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed onl...
问题:单选题What is the implication of this command?()A The command produces an error because the retention time cannot be reduced. B All historical data is retained but the subsequent flashback data archives are maintained for only three years. C All historical d...
问题:单选题To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows: SQL ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION...
问题:多选题When does a transaction complete?()Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed afte...
问题:多选题Which of the following objects can be directly referenced by a window object? ()ASchedule objectBProgram objectCJob objectDResource planEResource consumer group...
问题:单选题Which view provides information on the backup status of the datafiles in the database?()A V$BACKUPB V$BACKUP_STATUS C V$BACKUP_DATAFILE D V$DATAFILE_BACKUP E V$TABLESPCE_BACKUP...
问题:单选题Which NLS parameter directly governs linguistic searches?()A NLS_SEARCH_LB NLS_SORTC NLS_SEARCHD NLS_SORT_LE None of the above...
问题:单选题Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()A PLSQL_BLOCKB JAVA_STORED_PROCEDUREC STORED_PROCEDURED EXECUTABLEE None of the above are invalid settings....
问题:多选题Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. ...
问题:Following is the list of locations in random order where ora...
问题:单选题While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?(...
问题:单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backu...
问题:单选题When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()A SET_JOB_ARGUMENT_VALUEB SET_JOB_VALUE_ANYDATAC SET_JOB_ANYDATA_VALUED SET_SPECIAL_JOB_VALUEE SET_JOB_ANYTYPE_...
问题:单选题Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?()A Differential incremental backupB Different incremental backup C Cumulative backup D Cumulative incremental backup...
问题:单选题You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application p...