1,2,3,4,5
1,3,2,4,5
1,2,3,5,4
2,1,3,4,5
第1题:
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?()
第2题:
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?()
第3题:
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?()
第4题:
See the build instructions for managing Coherence via JMX and put the steps in order. () 1. Update set-env.cmd (or set-env.sh if you are building on UNIX) to reflect your system environment. 2. Open a command shell and execute set-env.cmd (or source set-env.sh if you are building on UNIX) 3. Run ant build. 4. Deploy the jmx-console.war file found under the build directory to your application server. Be sure to start your application server JVM with the necessary Coherence Management Framework overrides. For example: -Dtangosol.coherence.management=all 5. To remove build artifacts from your file system, run ’ant clean’
第5题:
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?()
第6题:
Use the at command to schedule a weekly job to back up the boot partition.
Use the at command to schedule a weekly job to run the system file checker.
Use Windows backup to schedule a backup of the System State Data.
Use Windows backup to schedule a backup of the system partition and the boot partition.
第7题:
setenv ORA_SDTZ ’DB_TZ’
setenv ORA_SDTZ ’+10:00’
setenv ORA_SDTZ ’OS-TZ’
setenv ORA_SDTZ ’Europe/London’
第8题:
4, 1, 3, 2, 5
1, 3, 4, 5, 2
1, 3, 2, 5; 4 not required
4, 1, 5, 2; 3 not required
1, 3, 4, 5; 2 not required
第9题:
1,2,3,4
3,2,4,1
4,2,1,3
4,3,2,1
第10题:
1,2,3,4,5
1,3,2,4,5
1,2,3,5,4
2,1,3,4,5
第11题:
2,1,3,4,5,6
2,4,5,3
4,7,3
2,4,7,3
2,7,3
第12题:
You will need to open the database with the resetlogs command.
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
You will use the resetlogs version of the create controlfile command.
You will use the noresetlogs version of the create controlfile command.
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
第13题:
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?()
第14题:
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?()
第15题:
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?()
第16题:
Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database: a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case?()
第17题:
Run the following command: ntbackup.exe backup /F {FileName}
Run the following command: ntbackup.exe backup systemstate /F {FileName}
In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.
Use NTBackup interactively.
第18题:
Use the Is -al to see if/unix is linked to /usr/lib/boot/unix_64
Check the /etc/inittab to see if there is a load64bit entry
Use ’prtconf -c1 to see if the system is 64-bit enabled
Use the Islpp command to see if the bos.mp64 fileset is installed
第19题:
Run the following command: ntbackup.exe backup /F {FileName}
Run the following command: ntbackup.exe backup systemstate /F {FileName}
In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.
Use NTBackup interactively.
第20题:
navigate to the $COHERENCE_HOME directory and type bin/coherence.cmd (Windows) or ./bin/coherence.sh (UNIX)
navigate to the $COHERENCE_HOME directory and type coherence.cmd (Windows) or bin/coherence.sh (UNIX)
navigate to the $COHERENCE_HOME directory and type bin/coherence.cmd (Windows) or coherence.sh (UNIX)
All of the above
第21题:
Only 1
Only 2
Only 3
3 and 1
1 and 2
第22题:
’SQL ALTER DATABASE OPEN’;
SQL ALTER DATABASE ’OPEN’;
OPEN DATABASE;
DATABASE OPEN
第23题:
ALTER DATABASE OPEN;
ALTER DATABASE CLEAR LOGFILE;
ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN NORESETLOGS;
第24题:
a, b, e, c
b, e, d
a, b, d, c
b, g, c, f
a, b, d, f