摘要: Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed 阅读全文
posted @ 2018-03-20 18:00 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0) 编辑
摘要: You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file 阅读全文
posted @ 2018-03-20 17:17 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0) 编辑
摘要: Because of a power outage, instance failure has occurred.From what point in the redo log does recovery begin and where does it end?A. current redo log 阅读全文
posted @ 2018-03-20 17:03 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0) 编辑
摘要: It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager 阅读全文
posted @ 2018-03-20 16:06 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0) 编辑
摘要: One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member's status? A. LOST B. INVALID 阅读全文
posted @ 2018-03-20 15:17 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0) 编辑
摘要: While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals with 阅读全文
posted @ 2018-03-20 14:04 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0) 编辑
摘要: User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of lock 阅读全文
posted @ 2018-03-20 13:43 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0) 编辑
摘要: When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed:TZ set to America/New_yorkOC4J 阅读全文
posted @ 2018-03-20 10:49 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0) 编辑
摘要: You need to rename a data file of a tablespace. How would you perform this? A. bring the database to the NOMOUNT state, rename the data file using the 阅读全文
posted @ 2018-03-20 10:36 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0) 编辑
摘要: You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE 阅读全文
posted @ 2018-03-20 10:24 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0) 编辑
摘要: You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1 What is the effect of this command if L1 is the only 阅读全文
posted @ 2018-03-20 10:16 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0) 编辑
摘要: You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change t 阅读全文
posted @ 2018-03-20 10:05 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0) 编辑
摘要: In which two cases would you perform only consistent backup? (Choose two.) A. You are working on a database where downtime is not tolerated. B. You ar 阅读全文
posted @ 2018-03-20 10:00 巴啦啦大魔王 阅读(146) 评论(0) 推荐(0) 编辑