当前分类： 1Z0-060
问题：多选题The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;CBACKUP ARC...
查看答案
问题：多选题You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?（）AEnable supple...
问题：单选题You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8IS...
问题：多选题Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）AThe procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.BThe pr...
问题：多选题You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?（）AIt will permit the use of uppercase passwords for database users who have been granted t...
问题：多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS...
问题：多选题Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）AMaximum Undo per consumer groupBMaximum Idle timeCParallel server l...
问题：多选题Which two statements are true about variable extent size support for large ASM files?（）AThe metadata used to track extents in SGA is reduced.BRebalance operations are completed faster than with a fixed extent sizeCAn ASM Instance automatically allocate...
问题：多选题Which four actions are possible during an Online Data file Move operation?（）ACreating and dropping tables in the data file being movedBPerforming file shrink of the data file being movedCQuerying tables in the data file being movedDPerforming Block Med...
问题：多选题Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）ABACKUP PLUGGABLE DATABASE PDB1 while connected to the root containerBBACK...
问题：单选题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...
问题：多选题Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）AAn EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the...
问题：多选题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 database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradat...
问题：单选题An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）A Configure the KEEP buffer pool a...
问题：单选题What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?（）A It will create a multitenant container database (CDB) with only the root opened.B It will create a CDB with root opened and seed read only.C It ...
问题：多选题Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）AThe size of the shared pool is too small.BCursors are not being shared.CA larg...
问题：单选题You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What h...
问题：多选题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 execute the following PL/SQL:Which two statements are true?（）AFine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.BFGA is enabled for the PRODUCTS.PRI...
