随笔分类 -  OCP

1 2 3 4 5 ··· 38 下一页
OCP考试学习
oracle建立不同块大小的表空间
摘要：Oracle 删除数据文件 阅读全文
posted @ 2018-03-22 18:18 巴啦啦大魔王 阅读(981) 评论(0) 推荐(0)
052-251(新增70题2018)
摘要：Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)A. It is possible to have tablespaces of differ 阅读全文
posted @ 2018-03-22 16:49 巴啦啦大魔王 阅读(217) 评论(0) 推荐(0)
052-250(新增70题2018)
摘要：Which three statements are true about the stages of database startup? (Choose three.) A. Data files and redo log files can be renamed at the MOUNT sta 阅读全文
posted @ 2018-03-22 16:29 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
052-249(新增70题2018)
摘要：Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)A. renaming of control filesB. multiplexing of con 阅读全文
posted @ 2018-03-22 16:13 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
052-248(新增70题2018)
摘要：You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct reg 阅读全文
posted @ 2018-03-22 15:53 巴啦啦大魔王 阅读(172) 评论(0) 推荐(0)
052-247(新增70题2018)
摘要：You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on 阅读全文
posted @ 2018-03-22 15:32 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
052-246(新增70题2018)
摘要：You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this 阅读全文
posted @ 2018-03-22 15:19 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
052-245(新增70题2018)
摘要：You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synch 阅读全文
posted @ 2018-03-22 15:13 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0)
052-244(新增70题2018)
摘要：One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it? A. uses undo data for r 阅读全文
posted @ 2018-03-22 15:05 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
052-243(新增70题2018)
摘要：Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes 阅读全文
posted @ 2018-03-22 14:56 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
052-242(新增70题2018)
摘要：You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USE 阅读全文
posted @ 2018-03-22 14:43 巴啦啦大魔王 阅读(180) 评论(0) 推荐(0)
052-241(新增70题2018)
摘要：Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled 阅读全文
posted @ 2018-03-22 14:41 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
052-240(新增70题2018)
摘要：You are using the following command to clear the log file group:ALTER DATABASE CLEAR LOGFILE GROUP 2;In which case would the command be successful?A. 阅读全文
posted @ 2018-03-22 14:37 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
052-239(新增70题2018)
摘要：You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, a 阅读全文
posted @ 2018-03-22 14:29 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
052-238(新增70题2018)
摘要：QUESTION 238 In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDE 阅读全文
posted @ 2018-03-22 14:00 巴啦啦大魔王 阅读(152) 评论(0) 推荐(0)
052-237(新增70题2018)
摘要：Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are w 阅读全文
posted @ 2018-03-22 13:48 巴啦啦大魔王 阅读(166) 评论(0) 推荐(0)
052-236(新增70题2018)
摘要：The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. The 阅读全文
posted @ 2018-03-22 11:31 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
052-235(新增70题2018)
摘要：You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listener process, you get the follo 阅读全文
posted @ 2018-03-22 10:58 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
052-234(新增70题2018)
摘要：In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. Y 阅读全文
posted @ 2018-03-22 10:53 巴啦啦大魔王 阅读(176) 评论(0) 推荐(0)
052-233(新增70题2018)
摘要：Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this 阅读全文
posted @ 2018-03-22 10:29 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)

1 2 3 4 5 ··· 38 下一页