当前分类： 1Z0-060
问题：多选题On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $ sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）AIt succeeds with def...
查看答案
问题：多选题On your Oracle Database, you issue the following commands to create indexes: SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);...
问题：多选题Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）AThe %ROWTY...
问题：多选题You performed an incremental level 0 backup of a database: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING ...
问题：多选题Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?（）ATracking the most recent read time for a table segment in a user tablespaceBTracking the most recent write time for ...
问题：单选题In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）A The CDB must be open.B The CDB must be in the mount stage.C The CDB must be in the nomount...
问题：单选题Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl STOPWhat happens to the sessions that are presently connected to the database Instance?（）A They are able to perfor...
问题：多选题Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）ALOG_BUFFERBSOR...
问题：多选题In which two scenarios do you use SQL* Loader to load data?（）ATransform the data while it is being loaded into the database.BUse transparent parallel processing without having to split the external data first.CLoad data into multiple tables during the ...
问题：单选题In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL REVOKE create ...
问题：多选题You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes tha...
问题：多选题You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）AUser session dataBStack spaceCPrivate SQL areaDLocation of the runtime area...
问题：单选题In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）A It ...
问题：多选题Which three statements are true about using flashback database in a multitenant container database(CDB)?（）AThe root container can be flashed back without flashing back the pluggable databases (PDBs).BTo enable flashback database, the CDB must be mounte...
问题：单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crs...
问题：多选题Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?（）AReduced logical I/OBReduced virtual memory utilizationCImproved parallel Execution performanceDImproved Serial Execution perform...
问题：多选题You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）AIt records the usernames and pass...
问题：单选题You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the r...
问题：多选题An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrat...
