060
文章平均质量分 59
黄继生 jisen
weixin:jisen2580
展开
-
QUESTION 1ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB andACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.A user issues a query on a table on one of the PDBs and receives the following error原创 2021-02-01 20:25:20 · 530 阅读 · 0 评论 -
QUESTION 2 Virtual Private Database (VPD) policies
QUESTION 2Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:BEGINDBMS_RLS.ADD_POLICY (object_schema => 'hr',object_name => 'employees',policy_name => 'employees_policy',function_schema =>原创 2021-02-01 20:37:26 · 179 阅读 · 0 评论 -
QUESTION 3 v$sysaux_occupants.move_procedure
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)A. The procedures may be used for some components to relocate component data to the SYSAUXtablespace from its current tabl.原创 2021-02-01 20:47:04 · 240 阅读 · 0 评论 -
QUESTION 4-LREG
Which statement is true about Oracle Net Listener?A. It acts as the listening endpoint for the Oracle database instance for all local and non-local userconnections.B. A single listener can service only one database instance and multiple remote client co.原创 2021-02-01 20:51:54 · 154 阅读 · 0 评论 -
QUESTION 5-MD_BACKUP/MD_RESTORE
QUESTION 5You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.In which原创 2021-02-01 21:00:50 · 230 阅读 · 0 评论 -
QUESTION 6-PDB恢复表空间
QUESTION 6Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF d原创 2021-02-01 21:04:44 · 152 阅读 · 0 评论 -
QUESTION 7 Oracle Database 12c 统一审计功能
QUESTION 7Which Oracle Database component is audited by default if the unified Auditing option is enabled?A. Oracle Data PumpB. Oracle Recovery Manager (RMAN)C. Oracle Label SecurityD. Oracle Database VaultE. Oracle Real Application SecurityCorrect原创 2021-02-01 21:07:07 · 170 阅读 · 0 评论 -
QUESTION 8-restore sysaux tablespace
QUESTION 8Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows:包含三个可插拔数据库(P原创 2021-02-01 21:08:50 · 125 阅读 · 0 评论 -
QUESTION 9 Oracle Database12c新特性:多线程模式- Multi-threaded Model
QUESTION 9Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?A. Reduced logical I/OB. Reduced virtual memory utilizationC. Improved parallel Execution performanceD. Improved Serial E原创 2021-02-01 21:20:13 · 332 阅读 · 0 评论 -
QUESTION 10
QUESTION 10In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?Both local and global partitioned B-tree Inde原创 2021-02-01 21:26:17 · 148 阅读 · 0 评论 -
QUESTION 11 Which three are true about the large pool for an Oracle database instance that supports
QUESTION 11Which three are true about the large pool for an Oracle database instance that supports shared server connections?A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor原创 2021-02-02 19:59:48 · 153 阅读 · 0 评论 -
QUESTION 12-What are three purposes of the RMAN “FROM” clause?
What are three purposes of the RMAN “FROM” clause?A. to support PUSH-based active database duplicationB. to support synchronization of a standby database with the primary database in a Data environmentC. to support PULL-based active database duplicationD原创 2021-02-02 20:00:46 · 158 阅读 · 0 评论 -
QUESTION 13 Emergency Monitoring特性
You notice that the performance of your production 24/7 Oracle 12c database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.How can you detect the cause of t.原创 2021-02-02 20:01:15 · 249 阅读 · 0 评论 -
QUESTION 14-Hybrid Columnar Compressed (HCC)
QUESTION 14You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage options support the use of HCC? (Choose three.)A.原创 2021-02-02 20:01:26 · 157 阅读 · 1 评论 -
QUESTION 15-SGA Monitoring
QUESTION 15In 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原创 2021-02-02 20:01:37 · 302 阅读 · 0 评论 -
QUESTION 16-TNSPING问题
The tnsnames.ora file has an entry for the service alias ORCL as follows:ORCL =( DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.156.24.216)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl.oracle.com)))The TNSPING command.原创 2021-02-02 20:01:49 · 105 阅读 · 0 评论 -
QUESTION 17-DBMS_PRIVILEGE_CAPTURE
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:1. Create a policy to capture the privilege used by a user for privilege analysis.2. Generate a report with the data captured for a.原创 2021-02-02 20:01:58 · 621 阅读 · 0 评论 -
QUESTION 18 LOG_ARCHIVE_DEST_1与DB_RECOVERY_FILE
QUESTION 18Your database is running an ARCHIVELOG mode. The following parameters are set in your database instance:LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'DB_RECOVERY_FILE_DEST_SIZE = 50GDB_RECOVERY_FILE =原创 2021-02-02 20:02:26 · 209 阅读 · 1 评论 -
QUESTION 19-rman backup CDB/PDB
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:RMAN> SELECT con_id,name, open_mode from V$PDBS;CON_ID NAME OPEN_MODE---------- ----------------------.原创 2021-02-02 20:02:36 · 288 阅读 · 0 评论 -
QUESTION 20-ASM ADD ALIAS
QUESTION 20You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group.You execute the following command:SQL> ALTER DISKGROUP data ADD ALIAS '+data/prod/myfile.dbf' FOR '+data.231.45678'原创 2021-02-02 20:02:45 · 148 阅读 · 0 评论 -
QUESTION 21-SQL Tuning Advisor
Which three functions are performed by the SQL Tuning Advisor?A. Building and implementing SQL profilesB. Recommending the optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based.原创 2021-02-03 17:35:22 · 101 阅读 · 0 评论 -
QUESTION 22-enable_ddl_logging
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.原创 2021-02-03 17:35:35 · 280 阅读 · 1 评论 -
QUESTION 23-12C RESTORE CONTROLFILE
QUESTION 23Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three原创 2021-02-03 17:35:48 · 94 阅读 · 0 评论 -
QUESTION 24- DBMS_SQL_MONITOR.REPORT_SQL_MONITOR
QUESTION 24A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the datab原创 2021-02-03 17:36:02 · 168 阅读 · 0 评论 -
QUESTION 25 pluggable database TO container database
Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB). (Choose two.)A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.B. Use the CREATE DATABASE ...原创 2021-02-03 17:36:12 · 111 阅读 · 0 评论 -
QUESTION 26 SQL Performance Analyzer
QUESTION 26Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the libra原创 2021-02-03 17:36:26 · 145 阅读 · 0 评论 -
QUESTION 27-SQL plan evolution task manually
QUESTION 27The following parameters are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1. Se原创 2021-02-03 17:36:37 · 162 阅读 · 0 评论 -
QUESTION 28-ASSM buffer busy waits is caused by contention on data blocks
QUESTION 28In 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 free list managed segments. On further investigation, you find th原创 2021-02-03 17:36:49 · 2405 阅读 · 0 评论 -
QUESTION 29 DBMS_STATS.SET_TABLE_PREFS
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? (Choose three.)A. Statistics collection is not done for the CUSTOMERS table when sch.原创 2021-02-03 17:37:04 · 363 阅读 · 0 评论 -
QUESTION 30-impdp network_link ,transportable
QUESTION 30Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):$> impdp <user_name> full=Y network_link=hrdb_test transportable=alwaystransport_datafiles='/u01/app/oracle/oradata/hr原创 2021-02-03 17:37:14 · 158 阅读 · 0 评论 -
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 · 239 阅读 · 2 评论 -
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 · 315 阅读 · 0 评论 -
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 · 248 阅读 · 0 评论 -
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 · 253 阅读 · 0 评论 -
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 · 325 阅读 · 0 评论 -
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 · 239 阅读 · 0 评论 -
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 · 240 阅读 · 0 评论 -
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 · 197 阅读 · 0 评论 -
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 · 197 阅读 · 0 评论 -
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 · 122 阅读 · 0 评论