问题:多选题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
查看答案
问题:单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()A When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
问题:多选题You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()ACorrupted blocks, if any, are repaired.BChecks are performed for physical corruptions.CChecks are performed for logical corruptions.DChecks are performed to confirm whether all database files exist in correct locationsEBackup sets containing both data files and archive logs are created.
问题:单选题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.
问题:多选题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 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.
问题:多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?()AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.
问题:多选题On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?()AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.
问题:单选题You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?()A The ORACLE_BASE base parameter is not set.B The installation is being performed by the root user.C The operating system group that is specified should have the root user as its member.D The operating system group that is specified must have permission to write to the inventory directory
问题:单选题Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()A By default, EM express is available for a database after database creation.B You can use EM express to manage multiple databases running on the same server.C You can perform basic administrative tasks for pluggable databases by using the EM express interface.D You cannot start up or shut down a database Instance by using EM express.E You can create and configure pluggable databases by using EM express.
问题:多选题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 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.
问题:多选题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 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.
问题:单选题An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?()A Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B Increase the database buffer cache size.C Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D Configure Automata Shared Memory Management.E Configure Automatic Memory Management
问题:多选题Which three operations can be performed as multipartition operations in Oracle?()AMerge partitions of a list partitioned tableBDrop partitions of a list partitioned tableCCoalesce partitions of a hash-partitioned global index.DMove partitions of a range-partitioned tableERename partitions of a range partitioned tableFMerge partitions of a reference partitioned index
问题:多选题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.
问题:多选题Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?()AThe size of the shared pool is too small.BCursors are not being shared.CA large number COMMITS are being performed.DThere are frequent logons and logoffs.EThe buffers are being read into the buffer cache, but some other session is changing the buffers.
问题:多选题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