Examine the command to create a plug

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

A、 The pluggable database pdb2 is created by cloning pdb1 and is in mount state.

B、 Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.

C、 The tablespace specifications of pdb2 are the same as pdb1.

D、 All database objects belonging to common users in PDB1 are cloned in PDB2.

E、 pdb2 is created with its own private undo and temp tablespaces.

查看答案

下载APP答题

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

相关试题

多选题 Which four are true about creating and running a remote database scheduler jobs?

A、 A database destination must exist or be created for the remote database.

B、 A database destination group must exist or be created for a job to run on multiple remote databases.

C、 A credential is optional for a remote database job.

D、 It must run as a user that is defined on the remote database.

E、 A destination is optional for a remote database job because DB links can be used instead.

F、 A credential must be created to define the remote user.

G、 Remote database jobs always run as the same user who submits the job on the local database.

查看答案

单选题 Examine the parameters for a database
Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transaction?

A、 Transactions write their undo in a temporary tablespace.

B、 Transactions fail.

C、 Transactions write their undo in the SYSTEM undo segment.

D、 Transactions wait until space becomes available in UNDOTBS1.

查看答案

多选题 Which three statements are true PFILEs, SPFILEs or both?

A、 SPFILEs and PFILES may both be edited with an O/S editing utility.

B、 All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause.

C、 Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause.

D、 A PFILE can be created by an idle instance.

E、 A SPFILE can be created by an idle instance.

F、 All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause.

查看答案

单选题 Your production database uses file system storage. You want to move storage to Oracle
Automatic Storage
Management (ASM). How would you achieve this?

A、 by using RMAN

B、 by using Data Pump

C、 by using the Database Upgrade Assistant (DBUA)

D、 by using a transportable database

查看答案

多选题 Which two statement are true about using SQL*Loader?

A、 It can load data into only one table at a time.

B、 It can load data from external files by using direct path only.

C、 It can generate unique sequential key values in specified columns.

D、 It can load data from external files by using conventional path only.

E、 It can load data into multiple tables using the same level statement.

查看答案

多选题 You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can
You use?

A、 Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.

B、 Perform a rolling upgrade.

C、 Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Rump to import data from the source Oracle 9i database to the target Oracle 12c database.

D、 Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.

E、 Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

查看答案

多选题 Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?

A、 It loads data faster than conventional SQL*Loader.

B、 It requires Enterprise Manager Express to be configured.

C、 It loads data more efficiently than conventional SQL*Loader.

D、 It can load data in parallel.

E、 No data file needs to be specified.

查看答案

单选题 What is a requirement for creating a remote database scheduler job?

A、 The remote database job must run as a user that is valid on target remote database

B、 A private database link must be created from the originating database to the target remote database

C、 The target remote database on which the job is scheduled must be Oracle Database 11g Release 2 or later

D、 The target remote database must be on a different host from the originating scheduler database host

查看答案