当前分类： OCP 11G认证考试
问题：单选题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....
查看答案
问题：单选题Which NLS parameter directly governs linguistic searches?（）A NLS_SEARCH_LB NLS_SORTC NLS_SEARCHD NLS_SORT_LE None of the above...
问题：多选题Which two statements are true regarding hot patching? （）AIt requires relinking of the Oracle binary.BIt does not require database instance shutdown.CIt can detect conflicts between two online patches.DIt is available for installing all patches on all p...
问题：单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）A It will display a list of files that need incremental backupB It will display a list of files that need backup after...
问题：单选题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...
问题：单选题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...
问题：单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）A...
问题：单选题Following is the list of locations in random order where oranfstab can be placed. 1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab What is the sequence in which Direct NFS will search the locations?（）A 1, 2, 3B 3, 2, 1C 2, 3, 1D 1, 3, 2...
问题：多选题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. ...
问题：多选题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...
问题：单选题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...
问题：单选题Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the out...
问题：单选题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...
问题：单选题hich of the following RMAN structures can data from a datafile span?（）A RMAN backup-set pieces spanning backup sets B RMAN backup-set pieces within a given backup sets C RMAN backups D RMAN channels E None of the above...
问题：单选题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...
问题：单选题You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?（）A backup database plus archivelogB backup database plus archivlog until time ‘10:00‘C backup database plus...
问题：单选题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_...
问题：单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding th...
问题：单选题Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL @utlrp.sql What is the significance of ...
