问题:多选题Which three statements are true about Flashback Database?()AFlashback logs are written sequentially, and are archived.BFlashback Database uses a restored control file to recover a database.CThe Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.DFlashback Database can recover a database to the state that it was in before a reset logs operation.EFlashback Database can recover a data file that was dropped during the span of time of the flashback.FFlashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
查看答案
问题:多选题Which two statements are true about the RMAN validate database command?()AIt checks the database for intrablock corruptions.BIt can detect corrupt pfiles.CIt can detect corrupt spfiles.DIt checks the database for interblock corruptions.EIt can detect corrupt block change tracking files.
问题:多选题Identify two correct statements about multitenant architectures.()AMultitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.BMultiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.CMultiple CDBs share certain PDB resources.DMultiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.EPatches are always applied at the CDB level.FA PDB can have a private undo tablespace.
问题:多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables
问题:单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?()A The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.B The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.C The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.D Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
问题:多选题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 notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?()AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs
问题:单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?()A All database operations performed by the impdp command are logged.B Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
问题:多选题Examine these two statements:Which three are true about the MRKT tablespace?()AThe MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.BThe MRKT tablespace may be dropped if it has no contents.CUsers who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.DNo more data files can be added to the tablespace.EThe relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
问题:多选题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 your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?()AThe movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USEDBSetting the target tablespace to read-onlyCThe movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USEDDSetting the target tablespace offlineEThe movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
问题:多选题Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?()AMaximum Undo per consumer groupBMaximum Idle timeCParallel server limitDCPUEExadata I/OFLocal file system I/O
问题:多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware configuration of the database serverDMigration of database storage from non-ASM to ASM storageEDatabase and operating system upgrade
问题:多选题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.
问题:多选题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 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?()A Transportable databaseB Transportable tablespaceC Data Pump full export / importD The DBMS_PDB packageE RMAN
问题:单选题Which statement is true about Oracle Net Listener?()A It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.B A single listener can service only one database instance and multiple remote client connections.C Service registration with the listener is performed by the process monitor (PMON) process of each database instance.D The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
问题:多选题Which three statements are true concerning unplugging a pluggable database (PDB)?()AThe PDB must be open in read only mode.BThe PDB must be dosed.CThe unplugged PDB becomes a non-cdb.DThe unplugged PDB can be plugged into the same multitenant container database (CDB)EThe unplugged PDB can be plugged into another cdb.FThe PDB data files are automatically removed from disk.
问题:多选题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.