当前分类: 1Z0-060
问题:多选题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...
查看答案
问题:多选题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...
问题:多选题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 run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using S...
问题:多选题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 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...
问题:单选题You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?()A The ORACLE_BASE ba...
问题:多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS...
问题:单选题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 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...
问题:多选题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...
问题:单选题Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL exec DBMS_MONITOR.SERV_...
问题:单选题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_...
问题:多选题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...
问题:多选题Which three statements are true about SQL plan directives?()AThey are tied to a specific statement or SQL id.BThey instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.CThey are used to ...
问题:单选题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...
问题:单选题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...
问题:多选题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...