1Z0-032章節(jié)練習(xí)(2019.04.25)

單項(xiàng)選擇題
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
多項(xiàng)選擇題
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.
單項(xiàng)選擇題
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
單項(xiàng)選擇題
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
單項(xiàng)選擇題
With dynamic service registration， which process registers instance information with the listener？（）
A.SMON
B.PMON
C.shared server
D.dedicated server
單項(xiàng)選擇題
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.
多項(xiàng)選擇題
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
單項(xiàng)選擇題
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.
單項(xiàng)選擇題
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
多項(xiàng)選擇題
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.

首頁(yè)

題庫(kù)

網(wǎng)課

在線?？?/h3>

桌面端

1Z0-032章節(jié)練習(xí)(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？（）

For which two tasks would it be best NOT to use the utility SQL*Loader？（）

Examine the statement：DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES； What is the result of the statement？（）

With dynamic service registration， which process registers instance information with the listener？（）

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？（）

Which two roles or privileges must you have to export tables owned by another user？（）

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？（）

1Z0-032章節(jié)練習(xí)(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？（）

For which two tasks would it be best NOT to use the utility SQL*Loader？（）

Examine the statement：DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES； What is the result of the statement？（）

With dynamic service registration， which process registers instance information with the listener？（）

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？（）

Which two roles or privileges must you have to export tables owned by another user？（）

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？（）

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？（）

For which two tasks would it be best NOT to use the utility SQL*Loader？（）

Examine the statement：DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES； What is the result of the statement？（）

With dynamic service registration， which process registers instance information with the listener？（）

Which two roles or privileges must you have to export tables owned by another user？（）