1,2,3,4,5
1,3,2,4,5
1,2,3,5,4
2,1,3,4,5
第1题:
The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.() 1. Shot down and start up the former primary instance without mounting the instance. 2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command. 3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command. 4. End read or update activity on the former primary and standby database.
第2题:
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?()
第3题:
You are a network administrator for your company. You currently automate backups of the System State data on the servers in your network by using NTBackup. Your manager instructs you to document the procedure for restoring a server from a backup of the System State data.You need to select the correct method for performing a restoration of a backup of the System State data.What should you do?()
A. Run the following command: ntbackup.exe backup /F {"FileName"}
B. Run the following command: ntbackup.exe backup systemstate /F {"FileName"}
C. In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.
D. Use NTBackup interactively.
第4题:
You are maintaining your Oracle10g database in the UNIX environment. An application requires one of the user sessions to exist in the operating system local time zone. You decide to set the time zone for a session using the operating system environment variable. Which command will you issue?()
第5题:
One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority. Which method would you use to overcome this problem?()
第6题:
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()
第7题:
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
第8题:
How can the command-line Coherence application in Windows and UNIX be started ?()
第9题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第10题:
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?()