123_在线真题试卷与模拟练习_123

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

. You want to move your existing recovery catalog to another database. Examine the steps:

Export the catalog data by using the Data Pump Export utility in the source database.

Create a recovery catalog user and grant the necessary privileges in the target database.

Create a recovery catalog by using the CREATE CATALOG command.

Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.

Import the source recovery catalog schema by using the IMPORT CATALOG command.

Connect to the destination database.

Connect as CATALOG to the destination recovery catalog schema.

. You execute the RMAN commands: RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

. Examine the backup requirement for your company:

Every Sunday, a backup of all used data file blocks isperformed.

Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.

On all the other days, a backup of only the changed blocks since the last day's backup is performed.

. Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user: SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users
QUOTA 100M ON users TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

. Which two are prerequisites for creating a backup-based duplicate database?

. You are administering a multitenant container database (CDB) cdb1. Examine the command and its output:
SQL>show parameter file
NAME TYPE VALUE
Db_create_file_dest string
Db_file_name_convert string db_files integer 200
You verify that sufficient disk space is available and that no file currently exists in the '/u0l/app/oracle/oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by usingthe command: SQL> CREATE PLUGGABLE DATABASE SALESPDB
ADMINUSER salesadm IDENTIFIED BY password ROLES=(dba) DEFAULT TABLESPACE sales
DATAFILE '/u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf' SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdbseed/', '/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE 2G)
PATH_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB'; Which statement is true?

. You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs).
You are connected to cdb$root as the sys user. You execute the commands: SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement is true about the c##connect role?

. Which three statements are true about a job chain?

. You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode.

You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week. One of the

Data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the datafile.

Examine the steps involved in the recovery process:

Shut down the database instance.

Start up the database instance in NOMOUNTstate.

Mount the database.

Take the data file offline.

Put the data file online.

Restore the control file.

Restore the database.

Restore the data file.

Open the database with the RESETLOGoption.

10.

Recover the database with the NOREDOoption.

11.

Recover the data file with the NOREDO option. Identify the required steps in the correct order.

. Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX '/disk2/oracle/pdb2';
Which two statements are true?

.In which three scenarios is media recovery required?

. A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

. Evaluate these statements: CREATE TABLE purchase_orders (po_id
Po_date supplier_id po_total CONSTRAINT NUMBER(4), TIMESTAMP, NUMBER(6), NUMBER(8,2), order_pk PRIMARY KEY(po_id)
)PARTITION BY RANGE(po_date)
(PARTITIONQ1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mm-yyyy')), PARTITIONQ2 VALUES LESS THAN (TO_DATE('01-jul-2007','dd-mm-yyyy')), PARTITIONQ3 VALUES LESS THAN (TO~DATE('01-oct-2007','dd-mm-yyyy')),
PARTITIONQ4 VALUES LESS THAN (TO_DATE('Ol-jan-2008','dd-mm-yyyy')));
CREATE TABLE purchase_order_items (po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT NULL, unit_price NUMBER(8,2), quantity NUMBER(8),
CONSTRAINT po_items_fk FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk); Which two statements are true?

. Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.

Examine the steps to recover this table from an RMAN backup:

Determine which backup contains the table that needs to be recovered.

Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.

Import the Data Pump export dump file into the auxiliary instance.

Create a Data Pump export dump file that contains the recovered table on a target database. Identify the required steps in the correct order.

. In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

. Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve queryperformance?

. You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12cdatabase:
CONNECT / AS SYSDBA
ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE; SHUTDOWN IMMEDIATE
You then restart the instance and get anerror:
STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?

. Which three statements are true about Oracle Restart?

. Which three statements are true about persistent lightweight jobs?

. Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

1 3 4 5 6 7 18