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
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
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.
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 .
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
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
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...
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
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
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
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 ...
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
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
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
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..
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
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
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..
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..
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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