问题：单选题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.
查看答案
问题：多选题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.
问题：多选题A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）ASYS sessions, regardless of the roles that are set in the sessionBSYSTEM sessions, regardless of the roles that are set in the sessionCSCOTT sessions, only if the MGR role is set in the sessionDSCOTT sessions, only if the MGR role is granted to SCOTTESCOTT sessions, because he is the owner of the tableFSYSTEM session, only if the MGR role is set in the session
问题：多选题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.
问题：多选题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.
问题：多选题You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）AData is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.BData is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.CData is never redacted for the EMP_V.SAL column.DData is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.EData is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
问题：多选题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 ARCHIVELOG ALL SECTION SIZE 25M;DBACKUP TABLESPACE TEMP SECTION SIZE 10M;EBACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;FBACKUP SPFILE SECTION SIZE 1M;GBACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
问题：多选题Which three statements are true about adaptive SQL plan management?（）AIt automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.BThe optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.CIt adds new, bettor plans automatically as fixed plans to the baseline.DThe non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.EThe non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
问题：多选题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.
问题：多选题Which two statements are true when row archival management is enabled?（）AThe ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.BThe ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.CThe ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.DThe ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.EThe ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
问题：多选题Which three statements are true about Automatic Workload Repository (AWR)?（）AAll AWR tables belong to the SYSTEM schema.BThe AWR data is stored in memory and in the database.CThe snapshots collected by AWR are used by the self-tuning components in the databaseDAWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.EAWR contains system wide tracing and logging information.
问题：多选题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.
问题：单选题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
问题：单选题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
问题：单选题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.
问题：多选题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.
问题：多选题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
问题：多选题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 mounted.CIndividual PDBs can be flashed back without flashing back the entire cdb.DThe DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.EA CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
问题：多选题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.
