当前分类: 1Z0-060
问题:多选题You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?()AIncreasing the priority of the job class to whi...
查看答案
问题:单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true abou...
问题:多选题A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in s...
问题:多选题Which three statements are true concerning unplugging a pluggable database (PDB)?()AThe PDB must be open in read only mode.BThe PDB must be dosed.CThe unplugged PDB becomes a non-cdb.DThe unplugged PDB can be plugged into the same multitenant container...
问题:单选题You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL AUDIT POLICY ORA_...
问题:多选题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...
问题:多选题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...
问题:多选题Identify two correct statements about multitenant architectures.()AMultitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.BMultiple pluggable databases (PDBs) share certain multitenant container database (CDB) ...
问题:多选题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);...
问题:单选题Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()A By default, EM express is available for a database after database creation.B You can use EM express to manage multiple databases running on the same server.C You c...
问题:多选题You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the p...
问题:多选题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 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...
问题:多选题In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?()AThe movem...
问题:多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for sto...
问题:多选题Which three functions are performed by the SQL Tuning Advisor?()ABuilding and implementing SQL profilesBRecommending the optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and...
问题:单选题In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffe...
问题:多选题Which two statements are true about the RMAN validate database command?()AIt checks the database for intrablock corruptions.BIt can detect corrupt pfiles.CIt can detect corrupt spfiles.DIt checks the database for interblock corruptions.EIt can detect c...