2021年05月_黄继生 jisen

原创 QUESTION 110-Temporal Validity

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.Examine the table definition:create table employees(empno number, salary number,deptid number, name varchar2(100),period for employe

2021-05-11 23:07:51 222

原创 QUESTION 109- Data Recovery Advisor

Which three activities are supported by the Data Recovery Advisor? (Choose three.)A. Advising on block checksum failuresB. Advising on inaccessible control filesC. Advising on inaccessible block change tracking filesD. Advising on empty password filesE.

2021-05-11 22:59:56 93

原创 QUESTION 108-TRUNCATE TABLE Flashback Archiving enabled

What is the result of executing a TRUNCATE TABLE command on a table, in a non-CDB database,that has Flashback Archiving enabled?A. It fails with the ORA-665610 Invalid DDL statement on history-tracked messageB. The rows in the table and the archive are t

2021-05-11 22:58:22 99

原创 QUESTION 107- SYS and SYSTEM users can always bypass any existing Oracle Data Redaction policies

A redaction policy was added to the SAL column of the SCOTT.EMP table:BEGINDBMS_REDACT.ADD_POLICY(OBJECT_SCHEMA => 'SCOTT',OBJECT_NAME => 'EMP',POLICY_NAME => 'SCOTT_EMP',COLUMN_NAME => 'SAL',EXPRESSION => 'SYS_CONTEXT (''SYS_SESSION_

2021-05-11 22:56:53 221

原创 QUESTION 106-AUDIT POLICY

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 act

2021-05-11 22:52:54 189

原创 QUESTION 105- latch-related

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?A. The size of the shared pool is too small.B. Cursors are not being shared.C. A la

2021-05-11 22:50:53 92

原创 QUESTION 104-local users unable SET CONTAINER

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:SQL> CREATE PUGGABLE DATABASE NEW_PDB ADMIN USER PDB_ADMIN IDENTIFIED NBYSECRET;Pluggable database created

2021-05-11 22:48:13 94

原创 QUESTION 103-multipartition operations

Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.)在Oracle数据库12c中，哪三种操作可以作为multipartition操作执行(选择三个。）A. Merge partitions of a list partitioned table.B. Drop partitions of a list partitioned table.C

2021-05-11 22:45:56 130

原创 QUESTION 102-multithreaded architecture enabled In UNIX

Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)A. Thread creation must be routed through a dispatcher processA.线程创建必须通过调度程序进

2021-05-11 22:43:04 86

原创 QUESTION 101-optimizer_dynamic_sampling

Examine the parameters for your database instance:NAME TYPE VALUES----------------------------------------- ---------------------- -------------------optimizer_adaptive_reporting_only boolean FALSEoptimizer_capture_sql_plan_baselines boolean FALSEoptim

2021-05-11 22:41:09 156 1

原创 QUESTION 100-Oracle Direct Network File system (DNFS)?

Which two statements are true about the Oracle Direct Network File system (DNFS)?A. It utilizes the OS file system cache.B. A traditional NFS mount is not required when using Direct NFS.C. Oracle Disk Manager can manage NFS on its own, without using th.

2021-05-10 21:54:13 170

原创 QUESTION 99-create a new PDB by using SQL Developer.

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 nomoun.

2021-05-10 21:52:06 62

原创 QUESTION 98-migrate 11.2.0.3 to CDB

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).The following are the possible steps to accomplish this task:1. Place all the user-defined tablespace in read-only mode on the sour

2021-05-10 21:50:47 136

原创 QUESTION 97-INSTALL DB

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 p

2021-05-10 21:48:44 67

原创 QUESTION 96 VALIDATE DATABASE

Which two statements are true about the RMAN VALIDATE DATABASE command? (Choose two.)A. It checks the database for intrablock corruptions.B. It can detect corrupt pfiles.C. It can detect corrupt spfiles.D. It checks the database for interblock corruption

2021-05-10 21:47:01 112

原创 QUESTION 95-SQL Performance Analyze to analyze impact

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware co

2021-05-10 21:44:47 75

原创 QUESTION 94-rman archivelog mode

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command:RMAN > BAC.

2021-05-10 21:43:25 98

原创 QUESTION 93-Online Data file Move

Which four actions are possible during an Online Data file Move operation?A. Creating and dropping tables in the data file being movedB. Performing file shrink of the data file being movedC. Querying tables in the data file being movedD. Performing Blo

2021-05-10 21:41:39 245

原创 QUESTION 92- Oracle Managed Files (OMF)

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)A. OMF cannot be used in a database that already has data files created with user-specified directions.B. The file system directions that are specified by OMF parameters are cr.

2021-05-10 21:40:10 336

原创 QUESTION 91 shared server connections

You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?A. User session dataB. Stack spaceC. Private SQL areaD. Location of the runt.

2021-05-10 21:37:48 121

jisen_huang的专栏