A. Provide a password for the encryption
B. Set up an Oracle wallet for the encryption
C. No setup is required as it is a default encryption method
D. Both Oracle wallet and password must be set up for the encryption
您可能感兴趣的试卷
你可能感兴趣的试题
A. views
B. fixed tables
C. heap tables
D. external tables
E. temporary tables
F. index-organized tables (IOT)
A. Opening the database in RESTRICTED mode
B. Opening the database with the RESETLOGS option
C. Setting a new DBID for the newly restored database
D. Restoring the server parameter file (SPFILE) to the new host
A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;
C. GRANT EXECUTE ON dbms_flashback TO scott;
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
A. The ASM-preferred mirror read feature is enabled.
B. The ASM supports variable sizes for extents of 1,8,and 64 allocation units.
C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
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 backups in a 24x7 environment is true?()
A. You must have change tracking enabled in your database
B. Your database must be running in NOARCHIVELOG mode
C. To back up a tablespace,it must be in backup mode
D. To back up a tablespace,it must first be taken offline
Examine the following RMAN script:
RMAN> run {
debug on;
allocate channel c1 type disk;
backup datafile 5;
}
Which statement describes the purpose of the script?()
A. The data file is checked for physical corruption and backed up if found clean.
B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
A. An upper limit on how far you can flash back the database, depending on the information in the redo logs
B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
A. generating the SQL profile
B. testing and accepting the SQL profile
C. generating a list of candidate SQLs for tuning
D. adding tuned SQL plans into the SQL plan baseline
E. tuning each SQL statement in the order of importance
F. generating baselines that include candidate SQLs for tuning
You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT DELETE ROWS TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command?()
A. It stores only the temporary table but not its indexes.
B. It stores both the temporary table as well as its indexes.
C. It must be a nondefault temporary tablespace for the database.
D. It can be a default or nondefault temporary tablespace for the database.
E. It must be the default temporary tablespace of the user who issues the command.
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table.
Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.
Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()
A. Restore the backup control file and open the database with RESETLOGS option.
B. Perform point-in-time recovery because flashback cannot be performed again on this table
C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
最新试题
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()
Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file.2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?()
The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()
Which two statements are true about a job chain?()
Which two client requests are captured during database replay Capture?()
Which two commands never trigger an implicit rebalancing within the disk group?()
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
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 solution to make tape streaming happen during the backup?()