1Z0-053章節(jié)練習(xí)(2019.05.03)

A. WHERE clause
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function

A. The DGROUP1 disk group was unmounted by another DBA.
B. A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
C. One of the redundant disks （DGROUP1） has been lost in a disk group.
D. This query has no meaning in an ASM instance.
E. A disk associated with a disk group was discovered after the ASM instance initially opened.

A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area （SGA）
C. The tape buffer is allocated from the Program Global Area （PGA）
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

A. owner
B. touser
C. attach
D. remap_schema

A. The Flashback Archive FLA1 is dropped only if it is empty.
B. The tablespace having Flashback Archive is dropped.
C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D. The Flashback Data Archive and historical data are dropped.

A. With alter database enable block change tracking
B. With alter system enable block change tracking
C. With an init.ora parameter change
D. With an spfile parameter change

A.1，3，6，7
B.2，3，6，8
C.1，2，3，6，7
D.1，2，3，6，，7，8
E.2，3，6，5，7

A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME

A. There is demand for space from the new table
B. The undo tablespace does not have sufficient free space
C. The new table name is the same as the table name in the recycle bin
D. The temporary tablespace that is assigned to you does not have sufficient free space

A. The priority of the lne_job1 job would be set to 1.
B. The lne_job1 job would be executed synchronously.
C. The lne_job1 job would run immediately in the users current session.
D. The lne_job1 job would retain its current priority.
E. The job will immediately take priority over all running jobs.