OCP - 随笔分类(第35页) - 巴啦啦大魔王

053-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 dat 阅读全文

posted @ 2017-11-08 15:32 巴啦啦大魔王阅读(83) 评论(0) 推荐(0)

053-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_B 阅读全文

posted @ 2017-11-08 15:23 巴啦啦大魔王阅读(85) 评论(0) 推荐(0)

053-557

摘要：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 巴啦啦大魔王阅读(113) 评论(0) 推荐(0)

053-556

摘要：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 巴啦啦大魔王阅读(120) 评论(0) 推荐(0)

053-555

摘要：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 巴啦啦大魔王阅读(102) 评论(0) 推荐(0)

053-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 t 阅读全文

posted @ 2017-11-08 14:48 巴啦啦大魔王阅读(94) 评论(0) 推荐(0)

053-553

摘要：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 巴啦啦大魔王阅读(138) 评论(0) 推荐(0)

053-552

摘要：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 巴啦啦大魔王阅读(93) 评论(0) 推荐(0)

053-551

摘要：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 巴啦啦大魔王阅读(117) 评论(0) 推荐(0)

053-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 dat 阅读全文

posted @ 2017-11-08 14:35 巴啦啦大魔王阅读(87) 评论(0) 推荐(0)

053-549

摘要：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 巴啦啦大魔王阅读(86) 评论(0) 推荐(0)

053-548

摘要：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 巴啦啦大魔王阅读(84) 评论(0) 推荐(0)

053-547

摘要：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 巴啦啦大魔王阅读(93) 评论(0) 推荐(0)

053-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 b 阅读全文

posted @ 2017-11-08 14:18 巴啦啦大魔王阅读(93) 评论(0) 推荐(0)

053-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 archiv 阅读全文

posted @ 2017-11-08 14:07 巴啦啦大魔王阅读(82) 评论(0) 推荐(0)

053-544

摘要：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 巴啦啦大魔王阅读(104) 评论(0) 推荐(0)

053-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_numbe 阅读全文

posted @ 2017-11-08 13:49 巴啦啦大魔王阅读(138) 评论(0) 推荐(0)

053-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 阅读全文

posted @ 2017-11-08 13:41 巴啦啦大魔王阅读(85) 评论(0) 推荐(0)

053-541

摘要：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 巴啦啦大魔王阅读(131) 评论(0) 推荐(0)

053-540

摘要：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 巴啦啦大魔王阅读(193) 评论(0) 推荐(0)

随笔分类 - OCP

公告