随笔分类 -  ocp-其他

摘要:Which two statements are true regarding Oracle Data Pump? (Choose two.)A.EXPDP and IMPDP are the client components of Oracle Data Pump.B.DBMS_DATAPUMP 阅读全文
posted @ 2017-12-11 14:38 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
摘要:Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)A.You can load data into multiple tables during the same loa 阅读全文
posted @ 2017-12-11 14:30 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
摘要:Which statement is true about loading data using the conventional path of SQL*Loader?A.Redo is not generated while performing conventional path loads. 阅读全文
posted @ 2017-12-11 14:25 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
摘要:You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too lar 阅读全文
posted @ 2017-12-11 14:14 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
摘要:You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The tab 阅读全文
posted @ 2017-12-11 14:07 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
摘要:You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move t 阅读全文
posted @ 2017-12-11 14:02 巴啦啦大魔王 阅读(155) 评论(0) 推荐(0)
摘要:When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.Which two statements describe the 阅读全文
posted @ 2017-11-17 11:37 巴啦啦大魔王 阅读(172) 评论(0) 推荐(0)
摘要:Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)A. Segment AdvisorB. SQL Access Adviso 阅读全文
posted @ 2017-11-17 11:10 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
摘要:Exhibit: View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TA 阅读全文
posted @ 2017-11-17 10:23 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0)
摘要:For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. 阅读全文
posted @ 2017-11-17 09:17 巴啦啦大魔王 阅读(144) 评论(0) 推荐(0)
摘要:Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space 阅读全文
posted @ 2017-11-16 17:08 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
摘要:Observe the structure of the table employees: The table contains 8475 records. One of the employees wants to know the names of all employees of the co 阅读全文
posted @ 2017-11-16 14:56 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
摘要:View the Exhibit to observe the error.You receive this error regularly and have to shutdown the database instance to overcome the error.Automatic Shar 阅读全文
posted @ 2017-11-16 14:32 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
摘要:View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based 阅读全文
posted @ 2017-11-16 14:15 巴啦啦大魔王 阅读(69) 评论(0) 推荐(0)
摘要:Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)A. The ADR base keeps all diagnostic information in binary 阅读全文
posted @ 2017-11-16 13:42 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
摘要:Which three tasks can be performed using a duplicate database? (Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of a 阅读全文
posted @ 2017-11-16 13:16 巴啦啦大魔王 阅读(81) 评论(0) 推荐(0)
摘要:You executed the following commands in a database session: What could have caused the recycle bin to clean up?A. There is demand for space from the ne 阅读全文
posted @ 2017-11-16 11:33 巴啦啦大魔王 阅读(170) 评论(0) 推荐(0)
摘要:View the Exhibit.You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage m 阅读全文
posted @ 2017-11-16 11:25 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
摘要:Which three statements are true about windows? (Choose three.)A. Only one window can be open at any given timeB. Consumer groups are associated with w 阅读全文
posted @ 2017-11-16 11:06 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
摘要:Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which too 阅读全文
posted @ 2017-11-16 10:58 巴啦啦大魔王 阅读(81) 评论(0) 推荐(0)