摘要：
Upon starting your database, you receive the following error:SQL> startup ORACLE instance started.Total System Global Area 171581440 bytes Fixed Size 阅读全文
posted @ 2017-11-08 18:29
巴啦啦大魔王
阅读(213)
评论(0)
推荐(0)
摘要：
What is the proper procedure to recover a lost tempfile?A. Restore the backup copy of the tempfile from the backup media.B. Re-create the tempfile wit 阅读全文
posted @ 2017-11-08 18:19
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived re 阅读全文
posted @ 2017-11-08 18:15
巴啦啦大魔王
阅读(118)
评论(0)
推荐(0)
摘要：
What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Tr 阅读全文
posted @ 2017-11-08 18:13
巴啦啦大魔王
阅读(160)
评论(0)
推荐(0)
摘要：
Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?A. Issue a checkpoint.B. Shut d 阅读全文
posted @ 2017-11-08 18:07
巴啦啦大魔王
阅读(130)
评论(0)
推荐(0)
摘要：
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOGmode? (Choose all that apply.)A. Database datafilesB. Cont 阅读全文
posted @ 2017-11-08 17:58
巴啦啦大魔王
阅读(130)
评论(0)
推荐(0)
摘要：
You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?A. Shut down the database. 阅读全文
posted @ 2017-11-08 17:55
巴啦啦大魔王
阅读(157)
评论(0)
推荐(0)
摘要：
You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) and the database has crashed.What would be the appropriate order 阅读全文
posted @ 2017-11-08 17:50
巴啦啦大魔王
阅读(137)
评论(0)
推荐(0)
摘要：
As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?A. Shut down the 阅读全文
posted @ 2017-11-08 17:42
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which 阅读全文
posted @ 2017-11-08 17:30
巴啦啦大魔王
阅读(148)
评论(0)
推荐(0)
摘要：
How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21 Oracle provides support for up to 阅读全文
posted @ 2017-11-08 16:19
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
Your archive-log destination directory runs out of space. What is the impact of this on the database?A. None. The database will switch over to the sta 阅读全文
posted @ 2017-11-08 16:16
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,what will be the result when you issue the command alte 阅读全文
posted @ 2017-11-08 16:08
巴啦啦大魔王
阅读(107)
评论(0)
推荐(0)
摘要：
What is the proper command to shut down the database in a consistent manner?A. Shutdown abortB. Shutdown killC. Shutdown nowaitD. shutdown immediateE. 阅读全文
posted @ 2017-11-08 16:01
巴啦啦大魔王
阅读(119)
评论(0)
推荐(0)
摘要：
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 dat 阅读全文
posted @ 2017-11-08 15:32
巴啦啦大魔王
阅读(98)
评论(0)
推荐(0)
摘要：
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_B 阅读全文
posted @ 2017-11-08 15:23
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
What will be the result of the following configuration?Log_archive_dest_1=location=c:\oracle\arch\mydbLog_archive_dest_2=location=z:\oracle\arch\mydbA 阅读全文
posted @ 2017-11-08 15:21
巴啦啦大魔王
阅读(143)
评论(0)
推荐(0)
摘要：
Archived redo logs can be copied to more than one destination by Oracle.A. TrueB. False Oracle can be configured to copy archived redo logs to up to 1 阅读全文
posted @ 2017-11-08 15:14
巴啦啦大魔王
阅读(135)
评论(0)
推荐(0)
摘要：
Which of the following parameters defines the location where Oracle should create archived redologs?A. LOG_ARCHIVE_1B. LOG_DESTINATION_1C. LOG_ARCHIVE 阅读全文
posted @ 2017-11-08 14:58
巴啦啦大魔王
阅读(128)
评论(0)
推荐(0)
摘要：
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 t 阅读全文
posted @ 2017-11-08 14:48
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unixsystem your database is on. Is this backup usable f 阅读全文
posted @ 2017-11-08 14:44
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hotbackup mode?A. alter tablespace DAVE_TBS backup mode;B. alter tab 阅读全文
posted @ 2017-11-08 14:42
巴啦啦大魔王
阅读(110)
评论(0)
推荐(0)
摘要：
Which command will result in a trace file being created with the create controlfile command containedin it?A. alter database backup controlfile;B. alt 阅读全文
posted @ 2017-11-08 14:40
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
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 dat 阅读全文
posted @ 2017-11-08 14:35
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
摘要：
Which is the correct command to put the database in ARCHIVELOG mode?A. alter database archivelogB. alter system enable archivelog modeC. alter databas 阅读全文
posted @ 2017-11-08 14:28
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
What are the different logging modes available in Oracle Database 11g? (Choose two.)A. NOLOG modeB. NOARCHIVELOG modeC. LOGGING modeD. HOTDATABASE mod 阅读全文
posted @ 2017-11-08 14:26
巴啦啦大魔王
阅读(99)
评论(0)
推荐(0)
摘要：
You backed up the database at 8 a.m. today using an online backup. Accounting made a largechange to the underlying data between 10 a.m. and noon. Whic 阅读全文
posted @ 2017-11-08 14:22
巴啦啦大魔王
阅读(110)
评论(0)
推荐(0)
摘要：
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 b 阅读全文
posted @ 2017-11-08 14:18
巴啦啦大魔王
阅读(117)
评论(0)
推荐(0)
摘要：
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 archiv 阅读全文
posted @ 2017-11-08 14:07
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain thatthey dont want you to shut down the database to perform t 阅读全文
posted @ 2017-11-08 13:58
巴啦啦大魔王
阅读(131)
评论(0)
推荐(0)
摘要：
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_numbe 阅读全文
posted @ 2017-11-08 13:49
巴啦啦大魔王
阅读(157)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2017-11-08 13:41
巴啦啦大魔王
阅读(95)
评论(0)
推荐(0)
摘要：
If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, whathappens to disks that are already a part of the same or a 阅读全文
posted @ 2017-11-08 13:35
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?A. ADD DIRECTORYB. DROP DISKC. RESI 阅读全文
posted @ 2017-11-08 13:31
巴啦啦大魔王
阅读(206)
评论(0)
推荐(0)
摘要：
How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it hasalready completed?A. Issue the ALTER DISKGROUP ... ADD DISK comma 阅读全文
posted @ 2017-11-08 13:24
巴啦啦大魔王
阅读(157)
评论(0)
推荐(0)
摘要：
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. Datafile 阅读全文
posted @ 2017-11-08 13:15
巴啦啦大魔王
阅读(102)
评论(0)
推荐(0)
浙公网安备 33010602011771号