多选题On your Oracle 12c database, you Issue the following commands to create indexes SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）ABoth the indexes are created; however, only the ORD_COSTOMER index is visible.BThe optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.COnly the ORD_CUSTOMER_IX1 index is created.DOnly the ORD_CUSTOMER_IX2 index is created.EBoth the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
多选题
On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）
A
Both the indexes are created; however, only the ORD_COSTOMER index is visible.
B
The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
C
Only the ORD_CUSTOMER_IX1 index is created.
D
Only the ORD_CUSTOMER_IX2 index is created.
E
Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
参考解析
解析：
暂无解析
相关考题：
多选题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 plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）AASM disk groups with ASM disks consisting of Exadata Grid Disks.BASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayCASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesDDatabase files stored in ZFS and accessed using conventional NFS mounts.EDatabase files stored in ZFS and accessed using the Oracle Direct NFS featureFDatabase files stored in any file system and accessed using the Oracle Direct NFS featureGASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
多选题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 the SYSOPER role.BIt contains username and passwords of database users who are members of the OSOPER operating system group.CIt contains usernames and passwords of database users who are members of the OSDBA operating system group.DIt will permit the use of lowercase passwords for database users who have granted the SYSDBA role.EIt will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
多选题Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）ABind Variable PeekingBSQL Plan BaselinesCAdaptive Cursor SharingDBind variable used in a SQL statementELiterals in a SQL statement
单选题Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）AOracle Data PumpBOracle Recovery Manager (RMAN)COracle Label SecurityDOracle Database VaultEOracle Real Application Security
多选题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 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.
单选题You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?（）ASet DB_FLASH_CACHE_SIZE=64GBSet D3_FLASH_CACHE_SIZE=64G, 64GCSet D3_FLASK_CACKE_SI2E=128GDdb_flash_cache_SI2E is automatically configured by the instance at startup
单选题In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）ASetting a metric thresholdBImplementing Database Resource ManagerCEnabling resumable timeout for user sessionsDDecreasing the value of the IDLE_TIME resource limit in the default profile
多选题Identify two situations in which the alert log file is updated.（）ARunning a query on a table returns ORA-600: Internal Error.BInserting a value into a table returns ORA-01722: invalid number.CCreating a table returns ORA-00955: name us already in used by an existing objects.DInserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.ERebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
单选题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: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）ATransportable databaseBTransportable tablespaceCData Pump full export / importDThe DBMS_PDB packageERMAN