Your database is running in noarchiv

单选题 Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the datafile?

A、 Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.

B、 Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart theinstance.

C、 Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.

D、 Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.

查看答案

下载APP答题

由4l***3u提供分享举报纠错

相关试题

单选题 You are administering a multitenant container database (CDB) cdb1.
Examine the command andits 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 using the command:
SQL>CREATE PLUGGABLE DATABASE SALESPDB
ADMIN USER 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?

A、 SALESPDB is created and is in mount state.

B、 PDB creation fails because the DB_file_name_convert parameter is not set in the CDB.

C、 SALESPDB is created and is in read/write mode.

D、 PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

查看答案

单选题 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 data file.
Examine the steps involved in the recovery process:
1 Shut down the database instance.
2 Start up the database instance in nomount state.
3 Mount the database.
4 Take the data file offline.
5 Put the data file online.
6 Restore the controlfile.
7 Restore the database.
8 Restore the data file.
9 Open the database with the resetlogs option.
10 Recover the database with the no redo option.
11 Recover the data file with the no redo option.
Identify the required steps in the correct order.

A、 4, 8, 11, 5

B、 1, 3, 8, 11, 9

C、 1, 2, 6, 3, 7, 10, 9

D、 1, 3, 7, 10, 9

E、 1, 2, 6, 3, 8, 11, 9

查看答案

单选题 Youare administering a multitenant container database (CDB)that contains multiplepluggable databases (PDBs). You are connected to cdb$root as the sysuser.
You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
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?

A、 It is created only in cdb$root and cannot be granted to the c##admin user with the
Container=all clause.

B、 It is granted to the c##admin user only in theCDB.

C、 It is granted to the c##admin user in all PDBs and can be granted only to a local user in a
PDB.

D、 It is granted to the c##admin user in all PDBs and can be granted object and system
Privileges for a PDB.

查看答案

单选题 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?

A、 The common user is created in the CDB and all the PDBs, and uses the users and temp
Tablespaces of the CDB to store schema objects.

B、 The command succeeds only if all the PDBs have the users and temp tablespaces.

C、 The command gives an error because the container=all clause is missing.

D、 The command succeeds and sets the default permanent tablespace of a PDB as the default
Tablespace for the c##a_admin user if the users tablespace does not exist in thatPDB.

查看答案

单选题 You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them
To pluggable databases (PDBs). You have already created a test system to support the
Consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

A、 capturing the most resource-intensive SQL statements in a SQL TuningSet on the
Production system and using the SQL PerformanceAnalyzer on the test system

B、 capturing the workload on the production system and replaying the workload for one
PDB at a time on the test system

C、 capturing the workload on the production system and using Consolidated Database
Replay to replay the workload of all production systems simultaneously for all PDBs

D、 capturing the most resource-intensive SQL statements in a SQL TuningSet on the
Production system and using the SQL Tuning Advisor on the testsystem

查看答案

单选题 You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine
7 / 60the list of steps that might be used to accomplish this task:
1 Place all user-defined tablespaces in read-only mode on the source database.
2 Use the RMAN convert command to convert data files to the target platform's endian format,
If required.
3 Perform a full transportable export on the source database with the parameters
VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4 Transport the data files for all the user-defined tablespaces.
5 Transport the export dump file to the target database.
6 Perform an import on the target database by using the full, network_link, and
Transportable_datafiles parameters.
7 Perform an import on the target database by using the full and transportable_datafiles
Parameters.
Identify the required steps in the correct order.

A、 1, 3, 5, 4, 2, and 6

B、 1, 2, 4, 6, 5, 3, and 7

C、 1, 2,4, and 7

D、 2, 4, 5, 6, and 7

查看答案

单选题 Examine the command:
$expdp SYSTEM FULL=Y DUMPFILE=dpump_dir1:full1%U.dmp, dpump_dir2:full2% U.dmp,
Dpump_dir3:full3%U.dmp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Which statement is true about the execution of the command?

A、 It fails because the log file parameter is not specified.

B、 It fails because no absolute path is specified for the log file and dump file.

C、 It succeeds and exports the full database, simultaneously creating three copies of dump
Files at three different locations.

D、 It succeeds and exports the full database, simultaneously creating three dump files at three
Different locations, but the total number of dump files can exceed three.

查看答案

单选题 You execute the RMAN commands:
4 / 60RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

A、 Corrupted blocks, if any, are repaired in the backup created.

B、 Only those data files that have corrupted blocks are backed up.

C、 Corrupted blocks in the data files are checked and repaired before performing the database backup.

D、 The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

查看答案