Oracle Database 12cR2 Administration - 1Z0-072무료 덤프문제 풀어보기

A. A public database link can be used by a user in the local database to connect to any schema in the remote database.

B. A database link can be created only between Oracle databases.

C. A public database link can be created only by SYS.

D. A database link created in a database allows a connection from that database instance to another, but not vice versa.

E. Private database link creation requires the same user to exist in both the local and the remote database.

A. Change its state to read only, and then take it offline with the temporary option.

B. Change its state to read only, and then take it offline with the immediate option.

C. Take it offline with the normal option.

D. Change its state to read only, and then take it offline with the normal option.

E. Take it offline with the immediate option.

F. Take it offline with the temporary option.

A. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.

B. Only the first row in EMP.DAT is inserted into U1.EMP.

C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.

D. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.

E. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.

A. enabling online redo log archiving

B. renaming data files

C. creating a database

D. full database recovery

E. re-creating control files

A. setting the O7_DICTIONARY_ACCESSIBILITY parameter to true

B. revoking all system privileges from the SYSTEM user

C. disabling audit for users with system privileges

D. restricting access to directory objects in the database

E. setting the REMOTE_OS_AUTHENT parameter to true

A. FLASHBACK TABLE TO SCN

B. FLASHBACK TRANSACTION

C. FLASHBACK DATABASE

D. FLASHBACK DROP

E. FLASHBACK QUERY

A. the number of OCPUs, amount of memory, and persistent block storage space allocated to an instance

B. a template of a virtual hard disk of specific size with an installed operating system

C. the physical persistent block storage space allocated to an instance

D. a template of a virtual hard disk of specific size without an operating system installed

E. the number of OCPUs and amount of memory allocated to an instance

A. It makes use of client system resources.

B. It can export data into sequential media, such as tapes.

C. It can restart failed export jobs.

D. It can execute in parallel.

E. It represents database metadata information as DDL statements in the dump file.

A. The LOCAL_LISTENER parameter list does not contain LISTENER_1.

B. The service is dynamically registered.

C. The service is statically registered.

D. The SID_LIST_LISTENER section is missing in the LISTENER.ORA file.

E. The listener does not listen on the default port 1521.