최신Oracle Database 12c: Advanced Administration - 1z1-063무료샘플문제
문제1
Which two result in an inconsistent backup? (Choose two.)
Which two result in an inconsistent backup? (Choose two.)
정답: C,E
문제2
Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid :=
DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true? (Choose two.)
Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid :=
DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true? (Choose two.)
정답: B,C
설명: (ExamPassdump 회원만 볼 수 있음)
문제3
Which two statements are true about RMAN duplexed backups? (Choose two.)
Which two statements are true about RMAN duplexed backups? (Choose two.)
정답: A,C
문제4
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION ('ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION ('ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?
정답: D
문제5
user_data is a non-encrypted tablespace containing tables with data.
You must encrypt all data in this tablespace.
Which three methods can do this? (Choose three.)
user_data is a non-encrypted tablespace containing tables with data.
You must encrypt all data in this tablespace.
Which three methods can do this? (Choose three.)
정답: A,B,D
문제6
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제7
Which three statements are true about the database instance startup after an instance failure? (Choose three.)
Which three statements are true about the database instance startup after an instance failure? (Choose three.)
정답: A,C,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제8
In which three scenarios is media recovery required? (Choose three.)
In which three scenarios is media recovery required? (Choose three.)
정답: B,C,E
문제9
You execute the commands to configure settings in RMAN:
Then, you issue the following command to take a backup:
Which statement is true about the execution of these commands?
You execute the commands to configure settings in RMAN:
Then, you issue the following command to take a backup:
Which statement is true about the execution of these commands?
정답: C
문제10
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)
정답: D,E
문제11
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제12
Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?
Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제13
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 SYSKM privilege.
3. Ensure that the CD 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?
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 SYSKM privilege.
3. Ensure that the CD 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?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제14
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1. Restore an autobackup of the server parameter file.
2. Restore the control file.
3. Start up the database instance in NOMOUNT state.
4. Mount the database.
5. Restore the data files.
6. Open the database with the RESETLOGS option.
7. Recover the data files.
8. Set DBID for the database.
Identify the required steps in the correct order.
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1. Restore an autobackup of the server parameter file.
2. Restore the control file.
3. Start up the database instance in NOMOUNT state.
4. Mount the database.
5. Restore the data files.
6. Open the database with the RESETLOGS option.
7. Recover the data files.
8. Set DBID for the database.
Identify the required steps in the correct order.
정답: D
문제15
Which two statements are true about a multitenant architecture? (Choose two.)
Which two statements are true about a multitenant architecture? (Choose two.)
정답: A,C