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

052-212(新增70题2018)

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

052-211(新增70题2018)

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

052-210(新增70题2018)

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

052-209(新增70题2018)

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

052-208(新增70题2018)

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

052-207(新增70题2018)

摘要：Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement reg 阅读全文

posted @ 2018-03-19 16:13 巴啦啦大魔王阅读(112) 评论(0) 推荐(0)

052-206(新增70题2018)

摘要：On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.) A. data files B. control files C. tablespaces D. pas 阅读全文

posted @ 2018-03-19 14:55 巴啦啦大魔王阅读(142) 评论(0) 推荐(0)

052-205(新增70题2018)

摘要：As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gai 阅读全文

posted @ 2018-03-19 14:49 巴啦啦大魔王阅读(100) 评论(0) 推荐(0)

052-204(新增70题2018)

摘要：iew the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables.Your organization plans to dissolve the department with department ID 30. 阅读全文

posted @ 2018-03-19 14:39 巴啦啦大魔王阅读(130) 评论(0) 推荐(0)

052-203(新增70题2018)

摘要：Your database performance has degraded due to frequent checkpointing. What would you do in this scenario? A. make redo log files smaller B. increase t 阅读全文

posted @ 2018-03-19 14:23 巴啦啦大魔王阅读(118) 评论(0) 推荐(0)

052-202(新增70题2018)

摘要：You want the size of the tablespace to increase when it is full.Which option would you use?A. use automatic extent allocationB. disable threshold for 阅读全文

posted @ 2018-03-19 09:05 巴啦啦大魔王阅读(129) 评论(0) 推荐(0)

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 巴啦啦大魔王阅读(144) 评论(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 巴啦啦大魔王阅读(106) 评论(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 巴啦啦大魔王阅读(171) 评论(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 巴啦啦大魔王阅读(134) 评论(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 巴啦啦大魔王阅读(116) 评论(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 巴啦啦大魔王阅读(227) 评论(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 巴啦啦大魔王阅读(190) 评论(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 巴啦啦大魔王阅读(176) 评论(0) 推荐(0)

随笔分类 - OCP

公告