2021年02月_黄继生 jisen

原创 QUESTION 70、CDB/PDB/CONTAINER=ALL、

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:SQL > REVOKE crea

2021-02-27 13:59:48 489

原创 QUESTION 69、SQL loader、APPENED

Examine the contents of SQL loader control file:LOAD DATAFILED NAMES FIRST FILEINFILE myfile1.datINFILE myfile2.datAPPENEDINTO TABLE EMPFILEDS CSV WITH EMBEDDEDDATE FORMAT "DD-Month-YYYY"(empno,ename,job,mgr,hirdate DATE,sal,comm,deptno,ent

2021-02-27 13:59:38 184

原创 QUESTION 68-Manually SGA_TARGET/LOG_BUFFER/DB_KEEP_CACHE_SIZE/DB_RECYCLE_CACHE_SIZE/DB_nK_CACHE_SIZ

Examine the following parameters for a database instance:MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=1024PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

2021-02-27 13:59:27 114

原创 QUESTION 67/DB_FLASH_CACHE_FILE/Set DB_FLASH_CACHE_SIZE

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.You have set the parameter:DB_FLASH_CACHE_FILE= '/dev/flash_device_1' ,'/dev/flash_device_2'How should the

2021-02-27 13:59:14 218

原创 QUESTION 66/ENABLE PLUGGABLE DATABASE

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?A. It will create a multitenant container database (CDB) with only the root opened.B. It will create a CDB with root opened and seed read only.C. It

2021-02-27 13:59:01 223

原创 QUESTION 65、“ENABLE PLUGGABLE

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.What are two effects of not using the "ENABLE PLUGGABLE database" clause?A. The database is created as a non-CDB and can never contain a PDB.

2021-02-27 13:58:50 134

原创 QUESTION 64、 invoker’s rights

In your multitenant container database (CDB) that contains pluggable databases (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,

2021-02-27 13:58:27 89

原创 QUESTION 63-FLASHBACK ANY TABLE

You execute a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.RECYCLE_BIN was enabled before the DROP USER was executed and the OCP user has been granted t

2021-02-27 13:58:13 228

原创 QUESTION 62- variable extent size support for large ASM files

Which two statements are true about variable extent size support for large ASM files?A. The metadata used to track extents in SGA is reduced.B. Rebalance operations are completed faster than with a fixed extent sizeC. An ASM Instance automatically allocat

2021-02-27 13:57:59 96

原创 QUESTION 61-PDB TABLESPACE

You create a new pluggable database, HR_PDB, from the seed database.Which three tablespaces are created by default in HR_PDB? (Choose three.)默认创建了哪三个表空间?(选择三个)。A. SYSTEMB. SYSAUXC. EXAMPLED. UNDOE. TEMPF. USERSCorrect Answer: ABE- A PDB would ha.

2021-02-27 13:57:37 83

原创 QUESTION 60、Adaptive plans

Which three statements are true about adaptive SQL plan management?A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.B. The optimizer always uses the fixed

2021-02-26 22:53:28 196

原创 QUESTION 59-OPTIMIZER_DYNAMIC_SAMPLING

Examine the parameter for your database instance:NAME TYPE Value------------------------------------------ --------------- ------------------optimizer_adaptive_reporting_only boolean FALSEoptimizer_capture_sql_plan_baselines boolean FALSEoptimizer_dyn

2021-02-26 22:53:20 149

原创 QUESTION 58-ADDM

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.Which t

2021-02-26 22:53:11 146

原创 QUESTION 57-12c 数据泵导入时禁止生成日志的参数disable_archive_logging

Examine the following query output:SQL> SELECT name, force_logging FROM V$DATABASENAME FORCE_LOGGING-------------------- ------------------------PROD NOYou issue the following command to import tables into the hr schema:$ > impdp hr/hr directo.

2021-02-26 22:53:01 229

原创 QUESTION 56-THREADED_EXECUTION = FALSE

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.A multitenant container database (CDB) instant has the following parameter set:THREADED_EXECUTION = FALSEWhich four statements are true about this administrator e

2021-02-26 22:52:52 148

原创 QUESTION 55-awr/workload performance

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performan

2021-02-26 22:52:36 131

原创 QUESTION 54-oracle11g plug cdb/Transportable tablespace

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).The characteristics of the non-CDB are as follows:- Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit- Character Set: AL32UTF8- National Chara

2021-02-26 22:52:10 143

原创 QUESTION 53-omf/PDB_FILE_NAME_CONVERT/SEED FILE_NAME_CONVERT

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achiev

2021-02-26 22:52:01 309

原创 QUESTION 52-SHUTDOWN TRANSACTIONAL

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.The CDB has several pluggable databases (PDBs) open in the read/write mode.There are ongoing transactions in both the CDB and PDBs.What happe

2021-02-26 22:51:38 340

原创 QUESTION 51-KEEP buffer pool

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 al

2021-02-26 22:51:08 109

原创 QUESTION 50-upgraded your database to a multitenant container database (CDB)

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).Examine the query and its output:SQL> SELECT name, force_logging FROM V$DATABASE;NAME FORCE_LOGGING------------------ -----------

2021-02-25 22:08:03 199 1

原创 QUESTION 49-AWR

Which three statements are true about Automatic Workload Repository (AWR)?A. All AWR tables belong to the SYSTEM schema.B. The AWR data is stored in memory and in the database.C. The snapshots collected by AWR are used by the self-tuning components in the

2021-02-25 22:05:05 165

原创 QUESTION 48-系统检测工作负载后给出的建议值来生成column group/执行计划/cardinatlity 基数行不准的问题

You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps:1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dua.

2021-02-25 22:03:28 179

原创 QUESTION 47-ADDM报告

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session H

2021-02-25 21:58:18 207

原创 QUESTION 46-/Bind Variable Peeking/Adaptive Cursor Sharing/ Literals in a SQL statement

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?A. Bind Variable PeekingB. SQL Plan BaselinesC. Adaptive Cursor SharingD. Bind variable used in a SQL stat

2021-02-25 21:57:21 111

原创 QUESTION 45-DB_FILE_MULTIBLOCK_READ_COUNT

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table sca

2021-02-25 21:40:16 110

原创 QUESTION 44-dropping a pluggable database/The PDB must be in mount state.

Which statement is true concerning dropping a pluggable database (PDB)?A. The PDB must be open in read-only mode.B. The PDB must be in mount state.C. The PDB must be unplugged.D. The PDB data files are always removed from disk.E. A dropped PDB can neve

2021-02-25 21:36:00 150

原创 QUESTION 43-utlrp.sql

You upgrade your Oracle database in a multiprocessor environment. As a recommended best practice, you execute the following script:SQL > @utlrp.sqlWhich two actions does the script perform? (Choose two.)A. Parallel compilation of only the stored PL/S

2021-02-25 21:34:45 217

原创 QUESTION 42- multitenant architecture-share the SGA/ Patches are always applied at the CDB level.

Identify two correct statements about multitenant architecture. (Choose two.)A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.B. Multiple pluggable databases (PDBs) share the SGA of a multitenant contain

2021-02-25 21:29:31 127

原创 QUESTION 41-benefits of installing Grid Infrastructure software

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? (Choose two.)A. Effectively implements role separationB. Enables you to take advantage of Oracle Managed Files.C.

2021-02-25 21:25:55 106

原创 QUESTION 40-STATISTICS_LEVEL

QUESTION 40Toimplement Automatic Management (AMM), you set the followingparameters:MEMORY_MAX_TARGET=600MSGA_MAX_SIZE=500MMEMORY_TARGET=600MOPEN_CURSORS=300SGA_TARGET=300MPROCESSES=150STATISTICS_LEVEL=BASICPGA_AGGREGATE_TARGET=0When you try to st

2021-02-04 23:02:14 123

原创 QUESTION 39-Online Table Redefinition

QUESTION 39You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is us

2021-02-04 22:59:34 198

原创 QUESTION 38- track all transactions tables

QUESTION 38You 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? (Choose

2021-02-04 22:57:22 198

原创 QUESTION 37-Oracle Data Redaction

QUESTION 37After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL;NUMBER_VALUE------------0SQL> EXEC DBMS_REDACT.UPDATE_FULL_R

2021-02-04 22:55:37 245

原创 QUESTION 36-SQL*Loader

QUESTION 36On 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=employeesWhich two statements are true regarding the command? (Choose two

2021-02-04 22:53:42 242

原创 QUESTION 35 统一审计策略

QUESTION 35You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT. You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL

2021-02-04 22:52:45 328

原创 QUESTION 34 不可见列INVISIBLE

QUESTION 34Examine the following command:CREATE TABLE products (prod_id number(4),prod_name varchar2(20),category_id number(30),quantity_on_hand number(3) INVISIBLE);Which three statements are true about using an invisible column in the PRODUCTS tabl

2021-02-04 22:51:07 256

原创 QUESTION 33-可插拔数据库(PDB)

QUESTION 33Which three statements are true concerning unplugging a pluggable database (PDB)?A. The PDB must be open in read only mode.B. The PDB must be closed.C. The unplugged PDB becomes a non-CDB.D. The unplugged PDB can be plugged into the same mu

2021-02-04 22:46:09 250

原创 2021-02-04 DB_8K_CACHE_SIZE

QUESTION 32Examine the current values for the following parameters in your database instance:SGA_MAX_SIZE = 1024MSGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issue the following command to increase the value of DB_8K_CACHE_SIZE:SQL&g

2021-02-04 22:43:29 326

原创 QUESTION 31-CDB共PDB优势

Which two are true concerning a multitenant container database with three pluggable database?A. All administration tasks must be done to a specific pluggable database.B. The pluggable databases increase patching time.C. The pluggable databases reduce a.

2021-02-04 22:39:01 245 2

空空如也

空空如也