摘要: Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data fi 阅读全文
posted @ 2018-03-16 18:35 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0) 编辑
摘要: You created a new user in your database but missed assigning a default tablespace to that user. The user created a table without specifying the tables 阅读全文
posted @ 2018-03-16 18:19 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0) 编辑
摘要: Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destination 阅读全文
posted @ 2018-03-16 17:53 巴啦啦大魔王 阅读(165) 评论(0) 推荐(0) 编辑
摘要: You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following erro 阅读全文
posted @ 2018-03-16 17:38 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0) 编辑
摘要: You specified extent management as local for a tablespace. How will it affect space management in the tablespace? A. All the extents will be of the sa 阅读全文
posted @ 2018-03-16 17:27 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0) 编辑
摘要: You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state? A. r 阅读全文
posted @ 2018-03-16 17:17 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0) 编辑
摘要: When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details requ 阅读全文
posted @ 2018-03-16 16:43 巴啦啦大魔王 阅读(221) 评论(0) 推荐(0) 编辑
摘要: User SCOTT wants to export his objects using Oracle Data Pump and executes the following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile 阅读全文
posted @ 2018-03-16 16:21 巴啦啦大魔王 阅读(183) 评论(0) 推荐(0) 编辑
摘要: Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all 阅读全文
posted @ 2018-03-16 11:21 巴啦啦大魔王 阅读(167) 评论(0) 推荐(0) 编辑
摘要: A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off 阅读全文
posted @ 2018-03-16 11:11 巴啦啦大魔王 阅读(241) 评论(0) 推荐(0) 编辑
摘要: Your Oracle 11g database has 6 tablespaces (view Exhibit) in which:- TEMP is the default temporary tablespace- UNDOTBS1 is the default undo tablespace 阅读全文
posted @ 2018-03-16 10:12 巴啦啦大魔王 阅读(167) 评论(0) 推荐(0) 编辑