问题:多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?()ABoth source and target database must be the same character setBBoth source and target database must have the same ...
Thursday, August 17, 2023
问题:多选题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. ...
Thursday, April 20, 2023
问题:单选题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 three statements are true about persistent configuration?()AA user cannot set privileges on the persistent lightweight jobsBPersistent lightweight jobs generate a large amount of metadataCIt is possible to create fully self-contained persistent l...
Wednesday, May 24, 2023
问题:单选题Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? ()A restore datafiles until time '09/28/2008:21:03:11'B restore database files until time '09/28/2008:18:00:00'C restore database until time '09/28/2008:18:00:00'D recover d...
问题:单选题Which command do you use to create a recovery-catalog schema? ()A create recovery catalog B create catalogC build catalog D catalog create E mount catalog...
Tuesday, July 25, 2023
问题:单选题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....
Saturday, August 26, 2023
问题:单选题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...
问题:单选题Which NLS parameter directly governs linguistic searches?()A NLS_SEARCH_LB NLS_SORTC NLS_SEARCHD NLS_SORT_LE None of the above...
Friday, October 21, 2022
问题:单选题You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMANCHANGE BACKUPSET 231 NOKEEP; What is ...
Tuesday, October 24, 2023
问题:单选题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...
Wednesday, April 17, 2024
问题:单选题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...
Thursday, May 18, 2023
问题:多选题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...
Tuesday, January 23, 2024
问题:多选题Which of the following objects can be directly referenced by a window object? ()ASchedule objectBProgram objectCJob objectDResource planEResource consumer group...
Tuesday, August 22, 2023
问题:单选题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...
问题:多选题Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used...
问题:Following is the list of locations in random order where ora...
Thursday, September 22, 2022
问题:The database Is configured in ARCHIVELOG mode. The database...
问题:单选题The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?()A CREATE SYNONYM ord FOR orders; This c...
问题:单选题You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How ...