问题:多选题What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?()AEffectively implements role separationBEnables you to take advantage of Oracle Managed Files.CAutomatically registers the database with Oracle Restart.DHelps you to easily upgrade the database from a prior release.EEnables the Installation of Grid Infrastructure files on block or raw devices.
Monday, April 15, 2024
问题:多选题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.
Friday, March 22, 2024
问题:单选题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.
Thursday, May 9, 2024
问题:单选题You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?()A by granting a secure application role to the usersB by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to falseC By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4D By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.E By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
Sunday, May 5, 2024
问题:多选题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.
Wednesday, October 18, 2023
问题:多选题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.
Monday, August 21, 2023
问题:单选题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
问题:单选题You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?()A The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.B The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.C The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.D The statement results in an error because there are open PDBs.
问题:多选题You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?()AUse the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.BUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.CUse the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.DUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.EUse the MD_RESTORE command to restore both the metadata and data for the failed disk group.FUse the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
Saturday, September 17, 2022
问题:单选题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.
Wednesday, September 27, 2023
问题:单选题You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -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 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?()A Transportable databaseB Transportable tablespaceC Data Pump full export/importD The DBMS_PDB packageE RMAN
问题:多选题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.
Saturday, April 20, 2024
问题:多选题You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?()AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.
Wednesday, November 8, 2023
问题:多选题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.
问题:多选题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.
Monday, August 7, 2023
问题:多选题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 gather only missing statistics.DThey are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.EThey instruct the optimizer to create only column group statistics.FImprove plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
问题:单选题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
问题:多选题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