1Z0-032章节练习(2019.04.25)

单项选择题
While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）
A.ARCn
B.CKPT
C.DBWn
D.LGWR
E.PMON
F.SMON
多项选择题
For which two tasks would it be best NOT to use the utility SQL*Loader？（）
A.When loading selected rows into each table.
B.When loading data from an export dump file.
C.When loading data from disk， tape， or named pipes.
D.When your data is NOT being inserted from a flat file.
E.When using a record management system to access data files.
单项选择题
Examine the statement：DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES； What is the result of the statement？（）
A.A
B.B
C.C
D.D
单项选择题
Examine the following parameter settings from an initialization （init.ora） file： DB_CREATE_FILE_DEST =’/u01/oradata/’ DB_CREATE_ONLINE_LOG_DEST_1 =’/u02/oradata/’ DB_CREATE_ONLINE_LOG_DEST_2 =’/u03/oradata/’ If you create an Oracle Managed Files （OMF） database using these settings， what is the result？（）
A.A
B.B
C.C
D.D
单项选择题
With dynamic service registration， which process registers instance information with the listener？（）
A.SMON
B.PMON
C.shared server
D.dedicated server
单项选择题
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）
A.SYSDBA
B.SYSOPER
C.No system privileges are required for the RMAN user.
D.Only SYS user can connect and execute RMAN commands on a target database.
多项选择题
Which two roles or privileges must you have to export tables owned by another user？（）
A.CREATE USER
B.CREATE SESSION
C.CREATE ANY TABLE
D.IMP_FULL_DATABASE
E.EXP_FULL_DATABASE
单项选择题
Click the Exhibit button and examine the diagram. You are running a database that takes advantage of features provided by Connection Manager， heterogeneous services， and external procedures. The diagram depicts the components used for the naming method you just configured. Which naming method are you using？（）
A.Host naming method.
B.Local naming method.
C.Directory naming method.
D.External naming method.
单项选择题
The listener uses dynamic information about the database and instance it has received through service registration before using information statically configured. Some services such as heterogeneous services and external procedures require the use of information statically configured within listener.ora. In order to support this， which tool could be used to configure the listener statically？（）
A.Oracle Net Manager
B.Listener Control Utility
C.Oracle Net Control Utility
D.Oracle Net Configuration Assistant
多项选择题
Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）
A.It readily responds to dynamic changes for concurrent access.
B.It improves performance and space utilization in a multiple-instance environment.
C.It requires fewer space related options then freelist managed structures.
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.