2018年3月16日
052-201(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
052-200(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
052-199(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(169) 评论(0) 推荐(0)
052-198(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
052-197(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(109) 评论(0) 推荐(0)
052-196(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(114) 评论(0) 推荐(0)
052-195(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(223) 评论(0) 推荐(0)
052-194(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(187) 评论(0) 推荐(0)
052-193(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(173) 评论(0) 推荐(0)
052-192(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(246) 评论(0) 推荐(0)
052-191(新增70题2018)
摘要： 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 巴啦啦大魔王 阅读(172) 评论(0) 推荐(0)