随笔分类 - 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
阅读全文
摘要: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
阅读全文
摘要:Which statement is true about loading data using the conventional path of SQL*Loader?A.Redo is not generated while performing conventional path loads.
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.Which two statements describe the
阅读全文
摘要:Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)A. Segment AdvisorB. SQL Access Adviso
阅读全文
摘要: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
阅读全文
摘要:For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB.
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)A. The ADR base keeps all diagnostic information in binary
阅读全文
摘要:Which three tasks can be performed using a duplicate database? (Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of a
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which too
阅读全文
浙公网安备 33010602011771号