- 【12c-OCP】1z0-062考试题库最新考试真题-第29题QUESTION 29 Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (`SH', `CUSTOMERS', `PUBLISH', `false'); Which three statements are true about the effect of this command? A. Statistic...[详细]
- 【12c-OCP】1z0-062考试题库最新考试真题-第28题QUESTION 28 In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with fre...[详细]
- 【12c-OCP】1z0-062考试题库最新考试真题-第27题QUESTION 27 The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL ...[详细]
- 【12c-OCP】1z0-062考试题库最新考试真题-第26题QUESTION 26 Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains t he ideal workload for analysis. You want to analyze som...[详细]
- 【12c-OCP】1z0-062考试题库最新考试真题-第25题QUESTION 25 Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB). A. Use the CREATE PLUGGABLE DATABASE statement to create a PD...[详细]
- 【12c-062】OCP 062考试题库最新考试真题-第24题QUESTION 24 Which two statements are true? A. A role cannot be assigned external authentication. B. A role can be granted to other roles. C. A role can contain both system and object privileg...[详细]
- 【12c-062】OCP 062考试题库最新考试真题-第23题QUESTION 23 Examine the query and its output: SQL SELECT REASON, metric_value FROM DBA_outstanding_alerts; REASON METRIC_VALUE ----------------------------------- ------------------- Tablesp...[详细]
- 【12c-062】OCP 062考试题库最新考试真题-第22题QUESTION 22 You execute the commands: SQLCREATE USER sidney IDENTIFIED BY out_standing1 DEFAULT TABLESPACE users QUOTA 10M ON users TEMPORARY TABLESPACE temp ACCOUNT UNLOCK; SQL GRANT CREA...[详细]
- 【12c-062】OCP 062考试题库最新考试真题-第21题QUESTION 21 Which two statements are true about extents? A. Blocks belonging to an extent can be spread across multiple data files. B. Data blocks in an extent are logically contiguous but can...[详细]
- 【12c-062】OCP 062考试题库最新考试真题-第20题QUESTION 20 Examine the memory-related parameters set in t he SPFILE of an Oracle database: memory_max_target=6G memory_target=5G pga_aggregate_target=500M sga_max_size=0 sga_target=0 Whic...[详细]
- 【12c-062】OCP 062考试题库最新考试真题-第19题QUESTION 19 Which statement is true regarding the startup of a database instance? A. The instance does not start up normally and requires manual media recovery after a shutdown using the abort ...[详细]
