自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(305)
  • 收藏
  • 关注

原创 QUESTION 195-ALTER DATABASE CONTROLFILE TO TRACE NORESETLOGS

Your database is running in ARCHIVELOG mode. You backup the controlile by executing: ALTER DATABASE CONTROLFILE TO TRACE NORESETLOGS whenever you make structural changes to the database. A media failure has damaged at the ocntrol files, but the online

2021-06-21 23:11:22 1

原创 QUESTION 194-It retrieves the most recently dropped version of the table.

You plan to use the Flashback Drop feature to recover the SALES_EMP table that was dropped in error. No other table with the sname name exists in the SH schema, which owns the table. You query the RECYCLEBIN and file multiple entries for the SALES_EMP

2021-06-21 23:11:18 16

原创 QUESTION 190- query result cache

Which three statements are true about the use of the query result cache? (Choose three.) A. Results obtained from a query rewrite to a materialized view may be stored in the query result cache. B. Stale results may still be obtained from the query r.

2021-06-21 23:11:13

原创 QUESTION 189-MKDG/MD_RESTORE

You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use the MD_BACKUP command to back up the ASM metadata regularly. You lose an ASM disk group DG1 due to a hardware failure.In which two ways can you re-create the .

2021-06-21 23:11:06

原创 QUESTION 188- Data Pump type external table

Which three can be performed on a Data Pump type external table? (Choose three.)A. creating a public synonym for the tableB. creating a view on the tableC. partitioning the tableD. performing a CREATE TABLE AS SELECT (CTAS) to populate the tableE. cre

2021-06-21 23:11:03

原创 QUESTION 187-Oracle Grid Infrastructure for a stand-alone

What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.) A. It is the only way to have "automatic restart in place" after instance f

2021-06-21 23:10:57

原创 QUESTION 186-memory_target

Examine the memory-related parameters of an Oracle database instance: *.memory_max_target=6G *.memory_target=5G *.pga_aggregate_target=500M *.sga_max_size=0 *.sga_target=0 Which statement is true? A. The value of the memory_targetparame...

2021-06-21 23:10:53

原创 QUESTION 185-DB_CREATE_FILE_DEST

You issue the following commands: SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata/orcl'; SQL> CREATE TABLESPACE august_sales DATAFILE '/u01/app/oracle/mydata/mysales.dbf' size 10M; SQL> CREATE TEMPORARY TABLESPACE tem.

2021-06-21 23:10:48 1

原创 QUESTION 184 - SHARED_SERVERS/ SHARED_SERVER_SESSIONS

Your database uses Automatic Memory Management, and has the large pool configured. You issue the following command: SQL> ALTER SYSTEM SET SHARED_SERVERS = 5; Which statement is true about the shared server configuration? A. It is enabled only.

2021-06-21 23:10:43 1

原创 QUESTION 183- 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 connections?A. User session dataB. Stack spaceC. Persistent area containing bind variable v

2021-06-21 23:10:30 1

原创 QUESTION 182-Datapump

Which two statements are true about Oracle Data Pump export and import operations? A. You can detach from a Data Pump export job and reattach later. B. Data Pump uses parallel execution server processes to implement parallel import. C. Data ...

2021-06-20 16:40:27

原创 QUESTION 193- deferred index maintenance

DBA_IND_PARTITIONS.ORPHANDED_ENTRIES contains YES for several index partition. This is due to the use of deferred index maintenance.Which three method will remove the orphanded keys?A. using DBMS_PART.CLEANUP_GIDX once to clean up orphanded keys in all

2021-06-20 16:39:44

原创 QUESTION 192- ValidTime Temporal

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 employees:create table employees(empno number, salary number,deptid number, name varchar2(100),period for employe

2021-06-20 16:39:39

原创 QUESTION 191-SGA TARGET shared pool

An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The follow..

2021-06-20 16:39:32 1

原创 QUESTION 181-job relative priority/job resource manager

You notice that the elapsed time for an important database scheduler job is unacceptably long. The job belongs to a scheduler job class and runs in a scheduler window. Which two actions could reduce the job's elapsed time? A. Increasing the job's r..

2021-06-20 16:39:25

原创 QUESTION 180-RMAN compressed backups

Which three statements are true about RMAN compressed backups? A. Media manager compression should not be enabled if compressed backups are being written to tape. B. Compressed backups can be written to media only if using proxy copies. C. File syste

2021-06-20 16:39:20

原创 QUESTION 179- Oracle Direct Network File System

Which two statements are true about Oracle Direct Network File System (NFS)?A. Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.B. It utilizes the operating system file system cache.C. Oracle Database requires mount p

2021-06-20 16:39:16

原创 QUESTION 178-transportable tablespace

You are the DBA for an Oracle Database 11g Release 1 data warehouse database running on Oracle Linux with little endianness. You want to plug in a transportable tablespace with a 16K blocksize from an Oracle Database 10gdatabase that is running on a SP..

2021-06-20 16:39:12

原创 QUESTION 177- adaptive SQL plan management

Which three statements are true about adaptive SQL plan management? A. It adds new; bettor plans automatically as fixed plans to the baseline. B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform b..

2021-06-20 16:39:06

原创 QUESTION 176-COMMON USERS PDB privilege

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges: SQL> CREATE USER c##a_admin IDENTIFIED BY pasword DEFAULT TABLESPACE data.

2021-06-20 16:38:59

原创 QUESTION 175- drop the column of a table

You plan to drop the column of a table that has Flashback Archiving enabled. You want to ensure minimal service disruption. How would you do this in your Oracle 12c Database? A. Disable Flashback Archiving, set the column unused, and re-enable Flash.

2021-06-19 00:10:10 13

原创 QUESTION 174-alphanumeric columns/. date columns/numeric columns (invalid binary )

Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?A. alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode ..

2021-06-19 00:09:58 1

原创 QUESTION 173-row same table /return a Boolean value

Which two statements are true concerning Information Lifecycle Management (ILM) policies? A. Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy. B. Segment-level policies override row-lev...

2021-06-19 00:09:48 10

原创 QUESTION 172-CDB SHUTDOWN TRANSACTIONA

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

2021-06-19 00:09:32 1

原创 QUESTION 171- RMAN “FROM SERVICE”

What are three purposes of the clause?A. to support file restoration over the network in a Data Guard environmentB. to support PUSH-based active database duplicationC. to support file recovery over the network in a Data Guard environmentD. to support s

2021-06-19 00:09:25 1

原创 QUESTION 170-BITMAP INDEX

On your Oracle 12c database, you issue the following commands to create indexes:SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id);SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id,sa...

2021-06-19 00:09:04 1

原创 QUESTION 169-CDB/PDB-tablespaces.

Which three statements are true about tablespaces in a multitenant container database (CDB)? A. All PDBs and CDBs have their own UNDO tablespaces. B. All PDBs and CDBs have their own SYSTEM and SYSAUX tablespaces. C. Each pluggable database (PDB) .

2021-06-19 00:08:50 1

原创 QUESTION 168-Data Redaction

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; ENAME SAL COMM MGR HIREDATE ----------------------- --------------------- ----------------

2021-06-19 00:08:40 1

原创 QUESTION 167-consolidation easier/patched together

Which two are true concerning a multitenant container database with three pluggable databases?A. Pluggable databases in the same container database (CDB) each have their own buffer cacheB. Pluggable databases can make database consolidation easierC. All

2021-06-19 00:08:24 1

原创 Binary of new process does not match binary which started instance

WARNING: Oracle executable binary mismatch detected. Binary of new process does not match binary which started instanceissue alter system set "_disable_image_check" = true to disable these messagesThu Jun 17 14:36:22 2021WARNING: Oracle executable bin.

2021-06-19 00:07:50 1

原创 QUESTION 166- ILM TBS PERCENT USED on a  different storage tier、on a  different storage tier,

In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? A. The ..

2021-06-18 01:16:37 1

原创 QUESTION 165-RESTORE PLUGGABLE/RECOVER PLUGGABLE

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOG mode. An RMAN backup exists for the databases. You issue the following commands and get an error: $ sqlplus / as ssdba SQL>.

2021-06-18 01:16:23 1

原创 QUESTION 164-configuring and accessing Enterprise Manager (EM)

Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database. A. Create a SYSMAN user with the SYSDBA role as an administrator for EM express. B. Configure the DISPATCHERS initialization parameter .

2021-06-18 01:16:09 1

原创 QUESTION 163 -rman RECOVER TABLE

You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN: RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION ‘+RECO’; Which five steps are performed by RMAN? A. truncating the SCOTT.EMP table in ..

2021-06-18 01:15:50 29

原创 QUESTION 162- extended data types

Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?A. Restart the database Instance in RESTRICTED mode.B. Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin.C. Shut down

2021-06-18 01:15:16 1

原创 QUESTION 161- difference in both time periods ADDM

You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automatic DatabaseDiagnostic Monitor (ADDM) report to further investigation. Whi

2021-06-18 01:14:59 1

原创 QUESTION 160-DBMS_REDEFINITION

To complete the online redefinition procedure, you execute the following command; EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE (‘SH’, ‘SALES’, ‘INT_SALES’, 600); What is the significance of the dml_lock_timeout period of 600 seconds in the preceding co

2021-06-18 01:14:28 1

原创 QUESTION 159- row-archival management

Which two statements are true when row-archival management is enabled? (Choose two.) A. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered activ.

2021-06-18 01:13:54 1

原创 逻辑ADG故障排查方向

1、异常监控命令--查找同步异常原因 --select * from dba_logstdby_events order by event_time desc;说明:如果status报错,event列有详细的触发操作语句,常见的多数是主库有新的DDL语句--确认同步是否正常SELECT * FROM v$logstdby_process;查看日志是否都已经同步完成select * from v$logstdby_stats;select * from v$Logstdby_pro

2021-06-18 01:12:26 2

原创 物理ADG转换逻辑ADG

1、构建物理DG参考:https://blog.csdn.net/jisen_huang/article/details/1152359082、转换逻辑DG2.1、停用备库MRP进程alter database recover managed standby database cancel;2.2、主库构建LogMiner字典create tablespace logmnrtbs datafile '+DATA/orcl/datafile/logmnrtbs1.dbf' si..

2021-06-18 01:03:28 5

空空如也

空空如也

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人 TA的粉丝

提示
确定要删除当前文章?
取消 删除