In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?()
时间:2022-10-17
Evaluate the following command: SQL> CREATE TABLE design_data (id NUMBER, doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE); Which statement is true regarding the above command?()
What is the proper procedure to recover a lost tempfile?()
What view might you use to try to determine how long a particular backup will take?()
时间:2022-10-16
What RMAN command must you use before you can back up a database using the recovery catalog?()
What command is used to reset a database to a previous incarnation?()
Which two statements are true regarding the SQL Repair Advisor?()
What privileges must be granted to allow an account to create the recovery catalog?()
You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()
What is the net effect of the following command?() alter diskgroup dgroup1 drop disk abc;
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?()
When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?()
时间:2022-10-15
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.() (Choose all that apply.)
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation?()
When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()