单选题 Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command。
2024-08-21
共109道
相关试题
单选题 Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?
单选题 You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with the Execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?
单选题 Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as theproduction database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?
单选题 Examine the statements that use flashback technologies: 1- FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS'); 2-SELECT ∗ FROM customers AS OF SCN 123456; 3-FLASHBACK TABLE customers TO BEFORE DROP; 4-FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS'); 5-SELECT ∗ FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; 6-ALTER TABLE customers FLASHBACK ARCHIVE; Which set of statements depends on the availability of relevant undo data in the undo tablespace?
单选题 A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?
单选题 Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
单选题 choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?
单选题 Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANYTABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?
