问题:单选题Which statement is true regarding the INTERSECT operator?()A It ignores NULL values B Reversing the order of the intersected tables alters the result C The names of columns in all SELECT statements must be identical D The number of columns and data types must be identical for all SELECT statements in the query
查看答案
问题:单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?()A None. The database will switch over to the stand-by archive-log destination directory. B A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced. C The database will shut down, and will not restart until you correct the out-of-space situation. D The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally. E Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
问题:单选题Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()A The shrink operation touches every block in the BOOKING tableB The high-water mark (HWM) for the BOOKING table is shifted from its original positionC The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
问题:单选题You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?()A all disks in the disk groupB all disks that are currently in OFFLINE modeC all disks that are not currently in OFFLINE modeD all disks in the disk group only if all of them are ONLINE
问题:单选题How many individual archive-log destination directories are supported by Oracle Database11g?()A 7 B 1 C 10 D 11 E 21
问题:单选题The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()A to prevent the creation of an excessive number of scheduler job classesB to allow the Automated Maintenance Tasks to use system resources without any restrictionC to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
问题:多选题Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? ()Afailures because a data file is renamed by errorBfailures when no standby database is configuredCfailures that require no archive logs to be applied for recoveryDfailures due to loss of connectivity-for example, an unplugged disk cable
问题:多选题Which two statements regarding a SQL profile are true?()AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CREATE PROFILE command.
问题:多选题User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()AALTER DATABASE FLASHBACK ON;BGRANT SELECT any transaction TO scott;CGRANT EXECUTE ON dbms_flashback TO scott;DALTER DATABASE ADD SUPPLEMENTAL LOG DATA;EALTER TABLESPACE undots1 RETENTION GUARANTEE;FALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
问题:单选题You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?()A Set a threshold for the default system-defined moving window baseline.B Add directives to the Automatic Database Diagnostic Monitor (ADDM).C Modify the profile for the targeted users for which control needs to be imposed.D Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
问题:多选题Which two statements regarding the Flashback Table feature are correct?()AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.DFlashback Table operation acquires exclusive data manipulation language (DML) locks.
问题:多选题Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()ABackup retention policyBDefault backup device typeCDefault destinations for backupsDMultiple backup device types for single backupEDefault section size for backups
问题:单选题View the Exhibit that sets the threshold for the Current Open Cursors Count metric.Why is the Significance Level threshold type not available in the threshold setting?()Abecause AWR baseline is not enabledBbecause Current Open Cursors Count is not a basic metricCbecause the STATISTICS_LEVEL parameter is set to BASICDbecause the AWR baseline is a system-defined moving window baseline
问题:多选题When does a transaction complete?()Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed after the pending transact ion
问题:单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()A Restore and recover the datafile. B Restore and recover the tablespace. C Restore and recover the database. D Restore and recover the control file. E Restore and recover the parameter file.
问题:单选题Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?()A only encryption and compression settings for all SecureFile LOBsB only encryption and deduplication settings for only SecureFile CLOBsC deduplication, encryption, and compression settings for all SecureFile LOBsD deduplication, encryption, and compression settings only for SecureFile CLOBs
问题:单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()A statistics recommendationsB SQL Profile recommendationsC Index-related recommendationsD restructuring of SQL recommendations
问题:单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()A Segment AdvisorB SQL Access AdvisorC Undo AdvisorD SQL Tuning Advisor
问题:多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?()ABoth source and target database must be the same character setBBoth source and target database must have the same endian formatCThe COMPATIBLE parameter must be the same in the source and target databases.DThe minimum compatibility level for both the source and target database must be 10.0.0.EAll read-only and offline data files that belong to the tablespace to be transported must be platform aware.
问题:单选题How is block-change tracking enabled?()A With alter database enable block change trackingB With alter system enable block change tracking C With an init.ora parameter change D With an spfile parameter change