当前分类： OCP 11G认证考试
问题：多选题Which statements are true regarding system-partitioned tables?（）AOnly a single partitioning key column can be specified.BAll DML statements must use partition-extended syntax.CThe same physical attributes must be specified for each partition.DUnique lo...
查看答案
问题：单选题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...
问题：单选题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...
问题：单选题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...
问题：单选题Which NLS parameter directly governs linguistic searches?（）A NLS_SEARCH_LB NLS_SORTC NLS_SEARCHD NLS_SORT_LE None of the above...
问题：多选题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 plan to execute the following command to perform a Flashback Database operation in your database: SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）AThe database must have multiplexed redo log filesBThe...
问题：单选题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_...
问题：单选题While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to...
问题：多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations...
问题：单选题Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a s...
问题：单选题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 statement about the enabling of table compression in Oracle Database 11g is true?（）A Compression can be enabled at the table, tablespace, or partition level for direct loads only.B Compression can be enabled only at the table level for both direc...
问题：多选题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...
问题：单选题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...
问题：What is the advantage of setting the ASM-preferred mirror re...
问题：单选题Which statement is true regarding virtual private catalogs? （）A A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. B The virtual private catalog owner cannot create and modify the sto...
问题：单选题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...
问题：多选题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. ...
