ITPub博客

（560）What is the proper command to shut down the database in a consistent manner?A. Shutdown abortB. Shutdown killC. Shutdown nowaitD. shutdown immediateE. shutdown halt答案：（D）

（559）Another DBA issues a shutdown abort command on a database on which you were running an online backup.What will happen when you try to restart the database?A. Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.B. ...

（558）Which view provides information on the backup status of the datafiles in the database?A. V$BACKUPB. V$BACKUP_STATUSC. V$BACKUP_DATAFILED. V$DATAFILE_BACKUPE. V$TABLESPCE_BACKUP答案：（A）解析：V$BACKUP displays the backup status of all online datafiles....

（557）What will be the result of the following configuration?Log_archive_dest_1 = 'location=c:\oracle\arch\mydb'Log_archive_dest_2 = 'location=z:\oracle\arch\mydb'A. An error will occur during database startup because the second parameter is not valid.B. An error will occur during da...

（556）Archived redo logs can be copied to more than one destination by Oracle.A. TrueB. False答案：（A）

（555）Which of the following parameters defines the location where Oracle should create archived redo logs?A. LOG_ARCHIVE_1B. LOG_DESTINATION_1C. LOG_ARCHIVED_DESTINATION_1D. LOG_ARCHIVE_DEST_1E. LOG_ARCHIVE_SOURCE_1答案：（D）

（554）Which is not a valid way of backing up a control file?A. Backing up the control file to traceB. Copying the existing control file of the database to the backup location during a hot backupC. Copying the existing control file of the database to the backup location during a cold back...

（553）Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on.Is this backup usable for backup and recovery of your database?A. Yes,if the database is in ARCHIVELOG mode.B. Yes,if the database is in NOARCHIVELOG mode....

（552）Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?A. alter tablespace DAVE_TBS backup mode;B. alter tablespace DAVE_TBS start backup;C. alter tablespace DAVE_TBS begin backup;D. alter tablespace DAVE_TBS backup begin;E. alter ...

（551）Which command will result in a trace file being created with the create controlfile command contained in it?A. alter database backup controlfile;B. alter database backup controlfile to trace;C. alter database controlfile backup;D. alter database controlfile backup to'/ora01/ora...

（550）What is the correct order of steps to perform an online database backup?a. alter database begin backup;b. alter database end backup;           c. Back up the database datafiles.d. Back up the archive log files.e. alter syste...

（549）Which is the correct command to put the database in ARCHIVELOG mode?A. alter database archivelogB. alter system enable archivelog modeC. alter database enable archiveD. alter database archivelog enableE. None of the above答案：（A）

（548）What are the different logging modes available in Oracle Database 11g?(Choose two.)A. NOLOG modeB. NOARCHIVELOG modeC. LOGGING modeD. HOTDATABASE modeE. ARCHIVELOG mode答案：（B、E）解析：log_mode分两种，归档和非归档sys@TEST0910>select log_mode from v$d...

（547）You backed up the database at 8 a.m. today using an online backup.Accounting made a large change to the underlying data between 10 a.m. and noon.Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?A. Create a manual incremental on...

（546）You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up.What command would you use?A. alter tablespace MY_DATA begin backup;B. alter tablespace MY_DATA start backup;C. alter tablespace MY_DATA backup begin;D. alter MY_DATA begin backup;...

（545）When performing an online backup,what is the proper order of the following steps?a. Issue the alter database end backup command.b. Back up the archived redo logs.c. Issue the alter database begin backup command.d. Back up the database files.e. Determine the beginning log se...

（544）Your database is in NOARCHIVELOG mode.You start to do a backup,but your users complain that they dont want you to shut down the database to perform the backup.What options are available to you?A. Put the database in hot backup mode and perform an online backup,including backing up ...

（543）As the DBA, you run the following query on your ASM instance.What is the implication of the results of the query?(Choose two.)SQL>select group_number,name,state from v$ASM_DISKGROUP;GROUP_NUMBER    NAME        STATE  &...

（542）You are an Oracle DBA responsible for an ASM instance.The disk controller on your system fails.You suspect that the disk itself is okay.You know it will take 24 hours to replace the controller and you don't want to have to rebuild the disks from scratch.What do you do?A. Take the w...

（541）If you use ALTER DISKGROUP...ADD DISK and specify a wildcard for the discovery string,what happens to disks that are already a part of the same or another disk group?A. The command fails unless you specify the FORCE option.B. The command fails unless you specify the REUSE option....