063新_在线真题试卷与模拟练习_063新

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

You take regular backups of one of your production databases by using RMAN with a
Recovery catalog.
You have added two new tablespaces to this database which must be included in future backups.
Which process occurs which allows the new backups to contain the newdatafiles?

One of your database suffered an instance failure.
At the next startup, from which point in the redo logs does instance recovery begin?

What should you do for a Scheduler to start a job when a file arrives on a remote system?

What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQLprograms?

Your database is open and the listener LISTENER is up. You issue the comand;
LSNRCTL> RELOAD
What is the effect of RELOAD on sessions that were originally established byLISTENER?

You are administering a multitemant container database(CDB. CDB1 with two pluggable
Databases(PDBS),PDB1 AND PDB2 .
YOU execute the following commands on CBD$ROOT as the SYS user;
SQL>CREATE USER C##scott identified by scottorcl1;
SQL>GRANT CREATE SESSION TO C##SCOTT;
WHICH statement is true about the C##SCOTT user?

One of your databases is in,ARCHIVELOG mode.

You badk up the dabas by using RMAN with a ecorer atlg

One data fle and al the contol fls ale coruot due to cmuptono lntle stoe anrExamine thi

S list of possible actions to recover the database:

1) Restore the control files by using the RESTORE CONTROLFILE command.

2) Mount the database.

3)Restore the data files by using the RESTORE DATABASE command.

4)Open the d atabase with the RESETLOGS option.

5)Recover the data files by using the RECOVER USING BACKU2 CONTROLFILE command.

6)Start the target database instance in NOMOUNT state.

7)Connect to the target database instance and the recovery catalog database instance.

8)Restore the SPFILE by using the RESTORE SPFILE command

9)Restore the corru pt data file,

10)Recover the restored data file,

Identify the minimum required steps in the coretorder.

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

You want to move your existing recovey catalog to another dtbaseExamine the s teps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the CREATE CATALOGcommand.
4) Import the catalog data into the new recovery catalog by using the Data Pump Imp ort utlt in thetarget database.
5) Import the source recovery catalog schema by using the RAN INFORT CATALOG cmada.6)
Connect to the destinationdatabase.
6) Connect as CATALOG to the detintion recover catlog schema.
For moving the recovery catalog.Identify the option with the corect sequence

Your database is in NOARCHIVELOG mode and an incremental backup exists.
A media failure results in the loss of a data file and an online redo log
Examine these commands:
1)STARTUP NOMOUNT
2)STARTUP MOUNT
3)RESTORE DATABASE
4)RECOVER DATABASE
5)RECOVER DATABASE UNTIL CANCEL
6)ALTER DATABASE OPEN
7)ALTER DATABASE OPEN RESETLOGS
Which commands are required to recover your database?

One of your database runs in ARCHIVELOG mode
Examine these initialization parameter settings:
LOG_ARCHIVE_DEST_1 =’LOCATION=/disk1/arch’
LOG_ARCHIVE_DEST_2 =’LOCATION=/disk2/arch’
LOG_ARCHIVE_DEST_3 =’LOCATION=/disk3/arch’
LOG_ARCHIVE_DEST_4 =’LOCATION=/disk4/arch MANDATORY’
LOG_ARCHIVE_MIN_SUCCEED_DEST = 2

Flashback data archive has been configured to retain data on all transactions that modify a table for a period of fouryears
Three years later it is decided to change the retention period
You execute this command:
SQL>ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTION 2YEAR;
Which is true?

Examine these actions:
1)Log in to CDB$ROOT as a user with the SYSDBA privilege
2)Log in to the PDB as a user with the SYSKMprivilege
3)Ensure that the CDB keystore is open
4)Ensure that the CDB keystore is closed
5)Export the PDB key information
6)Export the CDB key information
7)Shut down the CDB
8)Shut down the PDB
9)Unplug the PDB
Which of these are required to unplug an encrypted PDB?

DUPLICATE One of your production databases is in ARCHIVELOG mode
You use RMAN with a recovery catalog to back up this database to media and the database is
Defined in the recovery catalog。
You want to create a test database by duplicating the production database while it remains open.You restore production database backups to a new host with the same directory structure as on the original host。
The same recovery catalog must be used for any new backups created after the test database is successfully restored to the newhost
How would you achieve this

CREATE SCRIPT & recovery catalog
One of your non RAC database instances has been started up with the MOUNT option using an SPFILE and is running in NOARCHIVELOGmode.
The database has never been backed up.
Examine these command:
Rman target/
RMAN> CREATE SCRIPT db_ full_backup
{
BACKUP INCREMENTAL IEVEL 1 TAG backup full
DATABASE;
}
What will occur upon execution

LIST、 ADVISE、 REPAIR FAILURE
A container database (CDB. CDB1 runs in ARCHIVELOG mode.
It contains pluggable databases (PDBs), PDB_1 andPDB_2.
Examine this command andoutput:
SQL> alter pluggable databane pdb_1 open;
ORA-01157: cannot identify/ lock data file 11 - see DBWR trace file
ORA-01110: data file 11: ‘ /u01/app/oracle/oradata/ cdb1/pdb 1/example01 .dbf "
You connect RMAN to CDB$ROOT in CDB1.
Now examine these commands:
RMAN> LIST FAILURE ,
RMAN> REPAIR FATLURE ;
Which is true

Cumulative incremental
RMAN> BACKUP
INCREMENTAL. LEVEL 0
DATABASE;
…
Backup set complete, elapsed time: 00:00: 03
RMAN> BACKUP
INCREMENTAL. LEVEL 1
DATABASE ;
…
Backup set complete, elapsed time: 00:00:02
Now, examine this command:
RMAN> BACKUP
INCREMENTAL LEVEL 1 CUMULATIVE
DATABASE ;
…
Backup set complete, elapsed time:00:00:03
Which is true about the effects of the third BACKUP command

Fast Recovery Area
One of your non-RAc databases is OPEN and running in ARCHIVELOG mode.A Fast Recovery Area (FRA. is used by the database.
Examine this command, which you plan to execute:
RMAN> BACKUP COPIES 2
INCREMENTAL LEVEL. 0
DATABASE ;
Which is true

ALTER SYSTEM SET control_files
SQL> SHOW PARAMETER spfile;

ALTER SESSTON SET CONTATNER
Choose the best answer. Examine these commands and output:
SQL> ALTER SESSTON SET CONTATNER = ORCLPDB;
Session altered.
SQL> ALTER SESSTON SET CONTATNER =PRODPDB;.
Session altered.
SQL> SHUTDOWN IMMEDIATE
Which is true

1 5 6 7 8 9 18

更多题库