当前分类: 1Z0-060
问题:多选题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 pass...
查看答案
问题:多选题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 movem...
问题:单选题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 ...
问题:多选题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 p...
问题:单选题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 a...
问题:多选题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...
问题:单选题Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?()A None of the data definition language (DDL) statements are logged in the trace file.B Only DDL commands that resulted in errors are logged in the alert l...
问题:多选题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_BUFFERBSOR...
问题:多选题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) ...
问题:单选题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 abou...
问题:多选题You enabled an audit policy by issuing the following statements: SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active?...
问题:多选题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 whi...
问题:多选题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 c...
问题:多选题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 mounte...
问题:多选题What are three purposes of the RMAN “FROM” clause?()Ato support PUSH-based active database duplicationBto support synchronization of a standby database with the primary database in a Data environmentCTo support PULL-based active database duplicationDTo...
问题:单选题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 perfor...
问题:多选题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 sto...
问题:多选题You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?()AEnable supple...