Oracle 1z1-063題庫介紹

距離 1z1-063 考試只剩幾週，卻還抓不住複習重點嗎？NewDumps 為 Oracle Database 12c: Advanced Administration 整理了 278 道精選練習題，讓你把有限的備考時間花在刀口上。2026 年最新版本現已上架，現在開始準備還來得及。

Oracle 1z1-063 考試概覽:

Oracle 1z1-063 考試大綱主題:

關於 Oracle 1z1-063 認證，你可能想問的事

最新的 12c 1z1-063 免費考試真題：

問題 #1

Examine the command and its output:
SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type
FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP; Which two statements are true? (Choose two.)

A. It automatically flashes back all the indexes on the employees table.
B. It flashes back only the structure of the table and not the data.
C. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.
D. It automatically flashes back any triggers defined on the table.
E. It flashes back the employee table and all the constraints associated with the table.

問題 #2

You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 2;
RMAN> BACKUP DATABASE;
Which two statements are true? (Choose two.)

A. One channel is allocated.
B. The backup set is created in parallel only in one location.
C. Two channels are allocated.
D. The backup set is created serially in only one location.
E. The backup set is created in parallel in two locations.

問題 #3

You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)

A. backing up all archived logs and marking them as obsolete
B. backing up all data files as image copies and archive logs, and deleting those archive logs
C. switching the online redo log
D. backing up all used and unused blocks in the data files
E. backing up only the used blocks in the data files

問題 #4

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation? (Choose two.)

A. You must have full or level-0 backups to restore blocks.
B. You must take the tools01.dbf data file offline.
C. You must use an incremental level-1 backup to restore blocks.
D. You must configure a block change tracking file.
E. You must ensure that the database is mounted or open.

問題 #5

In which three scenarios is media recovery required? (Choose three.)

A. when one of the online redo log members is corrupted
B. when all control files are lost
C. when a tablespace is accidentally dropped from a database
D. when archived redo log files are lost
E. when data files are lost

問題與答案：