网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You have lost datafiles 1 and 3 from your database，and the database has crashed. In what order should you perform the following steps to recover your database？（） 1. Take the datafiles that were lost offline. 2. startup mount the database 3. Issue the alter database open command. 4. Restore the datafiles that were lost 5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online. 7. Recover the database with the recover database command.
A
2，1，3，4，5，6
B
2，4，5，3
C
4，7，3
D
2，4，7，3
E
2，7，3
参考答案
参考解析
解析：
暂无解析
更多 “单选题You have lost datafiles 1 and 3 from your database，and the database has crashed. In what order should you perform the following steps to recover your database？（） 1. Take the datafiles that were lost offline. 2. startup mount the database 3. Issue the alter database open command. 4. Restore the datafiles that were lost 5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online. 7. Recover the database with the recover database command.A 2，1，3，4，5，6B 2，4，5，3C 4，7，3D 2，4，7，3E 2，7，3” 相关考题
考题
单选题Which of the following describes how a distributed resumable transaction behaves？（）A
The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.B
The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.C
The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance； remote resumable settings determine the behavior of the distributed parts of the transaction.D
None of the above.
考题
多选题Which of these represent the main components of Database Resource Manager？（）AResource consumer groupsBResource plansCResource-plan groupsDResource-plan directivesEAll of the above
考题
单选题In which cases is reference partitioning effective in enhancing performance？（）A
It is effective only in partition pruning.B
It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C
It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.D
It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
考题
单选题Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）A
Create new indexes.B
Modify existing indexes.C
Implement partitioning on a nonpartitioned table.D
Create materialized views.E
All of the above
考题
单选题Which type of database file is spread across all disks in a disk group？（）A
All types of files are spread across all disks in the disk group.B
DatafilesC
Redo log filesD
Archived redo log filesE
Control files
考题
单选题Examine the following RMAN command： RMAN CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN BACKUP DATABASE PLUS ARCHIVELOG； Which prerequisite must be met before accomplishing the backup？（）A
Provide a password for the encryptionB
Set up an Oracle wallet for the encryptionC
No setup is required as it is a default encryption methodD
Both Oracle wallet and password must be set up for the encryption
考题
单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）A
User processB
Server processC
System Monitor (SMON)D
Process Monitor (PMON)E
Checkpoint process (CKPT)
考题
单选题You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions？（）A
0B
10C
100D
NULL
考题
多选题Evaluate the following command and its output： SQLSELECT * FROM dba_temp_free_space； TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
热门标签
最新试卷