问题:单选题You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?()A Compare Period ADDM reportB AWR Compare Period reportC Active Session History (ASH) reportD Taking a new snapshot and comparing it with a preserved snapshot
查看答案
问题:多选题Which two are prerequisites for performing a flashback transaction?()AFlashback Database must be enabled.BUndo retention guarantee for the database must be configured.CEXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.DSupplemental logging must be enabled.ERecycle bin must be enabled for the database.FBlock change tracking must be enabled tor the database.
问题:多选题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 FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?()ABackup change tracking will sometimes reduce I/O performed during cumulative incremental backups.BThe change tracking file must always be backed up when you perform a full database backup.CBlock change tracking will always reduce I/O performed during cumulative incremental backups.DMore than one database block may be read by an incremental backup for a change made to a single block.EThe incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
问题:多选题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 supplemental logging for the database.BSpecify undo retention guarantee for the database.CCreate a Flashback Data Archive in the tablespace where the tables are stored.DCreate a Flashback Data Archive in any suitable tablespace.EEnable Flashback Data Archiving for the tables that require tracking
问题:多选题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 two statements are true?()AOnly the ORD_CUSTOMER_IX1 index created.BBoth the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.CBoth the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.DThe ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.EBoth the indexes are created and used by the optimizer for queries on the ORDERS table.FBoth the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
问题:多选题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_BUFFERBSORT_AREA_SIZECJAVA_POOL_SIZEDSTREAMS_POOL_SIZEEDB_16K_CACHE_SZIEFDB_KEEP_CACHE_SIZE
问题:多选题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 %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.BThe DESCRIBE commands in SQL *Plus will not display the invisible column in the output.CReferential integrity constraint cannot be set on the invisible column.DThe invisible column cannot be made visible and can only be marked as unused.EA primary key constraint can be added on the invisible column.
问题:多选题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 same load statement.DGenerate unique sequential key values in specified columns.
问题:多选题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 passwords of users when granted the DBA role.BIt contains the usernames and passwords of users for whom auditing is enabled.CIs used by Oracle to authenticate users for remote database administration.DIt records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.EIt supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
问题:多选题You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.()AMissing or stale histogram statisticsBUndersized shared poolCHigh clustering factor for the indexesDHigh value for the DB_FILE_MULTIBLOCK_READ_COUNT parameterEOversized buffer cache
问题:多选题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 password file?()AAssign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.BGrant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.CRe-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.DRe-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.ERe-create the password file in the Oracle Database 12c format.
问题:单选题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 perform only queries.B They are not affected and continue to function normally.C They are terminated and the active transactions are rolled back.D They are not allowed to perform any operations until the listener LISTENER is started
问题:多选题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 B-tree indexesERecommending the restructuring of SQL queries that are using bad plans
问题:单选题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 table FROM C # # A_ADMIN;What is the result?()A It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B It fails and reports an error because the CONTAINER=ALL clause is not used.C It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D It fails and reports an error because the CONTAINER=CURRENT clause is not used.E It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
问题:单选题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 stage.D Alt existing PDBs must be closed.
问题:单选题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 collects data from SGA and compares it with a preserved snapshot.B It collects data from SGA, analyzes it, and provides a report.C It collects data from SGA and compares it with the latest snapshot.D It collects data from both SGA and PGA, analyzes it, and provides a report
问题:多选题You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?()AIt detects any configuration change that caused a performance difference in both time periods.BIt identifies any workload change that caused a performance difference in both time periods.CIt detects the top wait events causing performance degradation.DIt shows the resource usage for CPU, memory, and I/O in both time periods.EIt shows the difference in the size of memory pools in both time periods.FIt gives information about statistics collection in both time periods.
问题:多选题You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?()AParallel compilation of only the stored PL/SQL codeBSequential recompilation of only the stored PL/SQL codeCParallel recompilation of any stored PL/SQL codeDSequential recompilation of any stored PL/SQL codeEParallel recompilation of Java codeFSequential recompilation of Java code