单选题
You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
多选题
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?（）
Reduced logical I/O
Reduced virtual memory utilization
Improved parallel Execution performance
Improved Serial Execution performance
Reduced physical I/O
Reduced CPU utilization
多选题
Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?（）
Tracking the most recent read time for a table segment in a user tablespace
Tracking the most recent write time for a table segment in a user tablespace
Tracking insert time by row for table rows
Tracking the most recent write time for a table block
Tracking the most recent read time for a table segment in the SYSAUX tablespace
Tracking the most recent write time for a table segment in the SYSAUX tablespace
多选题
Which three statements are true about Automatic Workload Repository (AWR)?（）
All AWR tables belong to the SYSTEM schema.
The AWR data is stored in memory and in the database.
The snapshots collected by AWR are used by the self-tuning components in the database
AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
AWR contains system wide tracing and logging information.
多选题
What are three purposes of the RMAN “FROM” clause?（）
to support PUSH-based active database duplication
to support synchronization of a standby database with the primary database in a Data environment
To support PULL-based active database duplication
To support file restores over the network in a Data Guard environment
To support file recovery over the network in a Data Guard environment
单选题
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）
The PGA_AGGREGATE_TARGET parameter is set to zero.
The STATISTICS_LEVEL parameter is setto basic.
Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
单选题
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）
Create the CREATE_TEST procedure with definer’s rights.
Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
Create the CREATE_TEST procedure with invoker’s rights.
Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
多选题
Which three statements are true about using flashback database in a multitenant container database(CDB)?（）
The root container can be flashed back without flashing back the pluggable databases (PDBs).
To enable flashback database, the CDB must be mounted.
Individual PDBs can be flashed back without flashing back the entire cdb.
The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
多选题
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: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）
The valid time columns employee_time_start and employee_time_end are automatically created.
The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
The valid time columns are not populated by the Oracle Server automatically.
The valid time columns are visible by default when the table is described.
Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio
多选题
On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）
Both the indexes are created; however, only the ORD_COSTOMER index is visible.
The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
Only the ORD_CUSTOMER_IX1 index is created.
Only the ORD_CUSTOMER_IX2 index is created.
Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）