1Z0-032单项选择题每日一练(2019.01.17)

单项选择题
You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
A.MERGE
B.SELECT …CROSS JOIN
C.INSERT ALL …SELECT
D.CREATE VIEW …CONSTRAINT
单项选择题
Under the Oracle Shared Server architecture， client-user processes ultimately connect to a（）
A.service
B.listener
C.dispatcher
D.shared server process
单项选择题
You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts； Which command should you issue next？（）
A.RESYNC CATALOG；
B.REGISTER DATABASE；
C.CREATE CATALOG TABLESPACE rman_ts；
D.GRANT recovery_catalog_owner TO rman_db01；
单项选择题
Examine this syntax which allocates channels during a parallel image copy： RMAN> CONFIGURE DEVICE TYPE disk parallelism 4： 2> COPY 3> datafile 1 TO ‘/BACKUP/datafile1.dbf’， 4> datafile 2 TO ‘/BACKUP/datafile2.dbf’， 5> datafile 3 TO ‘/BACKUP/datafile3.dbf； RMAN>COPY 2> datafile 4 TO ‘/BACKUP/datafile4.dbf’； How many channels are used？（）
A.0
B.1
C.3
D.4
单项选择题
In this scenario， assume that you archive logs 101 to 104 to two archiving destinations， /log1 and /log2. The control file contains archived log records as follows： Sequence Filename 101 /log1/log_1_101.arc 101 /log2/log_1_101.arc 102 /log1/log_1_102.arc 102 /log2/log_1_102.arc 103 /log1/log_1_103.arc 103 /log2/log_1_103.arc 104 /log1/log_1_104.arc 104 /log2/log_1_104.arc You accidentally delete logs 102 and 104 from log 1. You run this command： BACKUP ARCHIVELOG FROM SEQUENCE 101 UNTIL SEQUENCE 105； What happens？（）
A.A
B.B
C.C
D.D