随笔分类 - OCP
OCP考试学习
摘要:You plan to configure the new Oracle Database 11g installation by performing these tasks:- Use Automatic Storage Management (ASM) as the storage optio
阅读全文
摘要:Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support? (Choose all that apply.)A.You can add S
阅读全文
摘要:View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident? Which statement is true regardi
阅读全文
摘要:Which two statements are true regarding the Oracle Data Pump export and import operations?(Choose two.)A.You cannot export data from a remote database
阅读全文
摘要:You want to import schema objects of the HR user using Oracle Data Pump from the development database, DEVDB, to the production database, PRODDB. A da
阅读全文
摘要:You want to move all objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you u
阅读全文
摘要:In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)A.if a
阅读全文
摘要: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
阅读全文
摘要:You executed the following commands in an RMAN session for your database instance that hasfailures:RMAN> LIST FAILURE;After some time, you executed th
阅读全文
摘要:View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure, y
阅读全文
摘要:Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)A.Recover from failures in the RAC environment.B.Diagnose and
阅读全文
摘要:Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?(Choose two.)A.failure when no standby database is config
阅读全文
摘要:Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A.The database files are corrupted when the database is
阅读全文
摘要:You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived
阅读全文
摘要:View the Exhibit to examine the output for the CROSSCHECK BACKUP command.Which statement is true about the output of the command? A. The backup piece
阅读全文
浙公网安备 33010602011771号