Sie möchten sich vor dem Kauf einen eigenen Eindruck verschaffen? Laden Sie im Jahr 2026 die kostenlose PDF-Demo zur 1z0-063 Prüfung herunter und prüfen Sie in Ruhe, ob die 278 Übungsfragen von Fast2test zu Ihrem Lernstil passen.

Oracle 1z0-063 Prüfungsübersicht:

Oracle 1z0-063 Prüfungsthemen:

Ihre Fragen zur 1z0-063 Prüfung – kompakt beantwortet

Oracle Database 12c: Advanced Administration 1z0-063 Prüfungsfragen mit Lösungen

Frage #1

You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this? (Choose two.)

A. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
B. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TABLESPACE adtbs ADD DATAFILE;
E. ALTER TABLESPACE adtbs RESI2E 20G;

Frage #2

You want to create a guaranteed restore point for one of your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Which two are required for the successful execution? (Choose two.)

A. Undo retention guarantee must be enabled.
B. Flashback Database must be enabled.
C. The Fast Recovery Area must be configured.
D. The database must be in ARCHIVELOG mode.
E. The database must be opened.
F. The database must be mounted.

Frage #3

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

A. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
B. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
C. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
D. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.

Frage #4

You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS ('SH', 'CUSTOMERS') from dual statement.
2. Execute the dbms_stats.seed_col_usage (null, 'SH', 500) procedure.
3. Execute the required queries on the customers table.
4. Issue the select dbms_stats.reportwcol_usage ('SH', 'customers') from dual statement.
Identify the correct sequence of steps.

A. 2, 3, 4, 1
B. 3, 2, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 1, 4

Frage #5

In which situation can you use Flashback Database?

A. when returning to a point in time before the most recent OPEN RESETLOGS operation
B. when undoing a shrink data file operation
C. when returning to a point in time before the restoration or re-creation of a control file
D. when retrieving a dropped tablespace

Fragen und Antworten: