Latest Oracle 1z0-063 Dumps PDF Questions Answers 2024

Oracle Database 12c: Advanced Administration Questions and Answers

Question 1

Which two statements are true about a common user? (Choose two.)

Options:

A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

A common user with the CREATE USER privilege can create other common users, as well as local users.

A common user can be granted only a common role.

A common user can have a local schema in a PDB.

A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Buy Now

Question 2

You plan to upgrade a production database running in NOARCHIVELOG mode that has no Fast Recovery Area configured.

The upgrade must be reversable within as quickly as possible with the smallest overhead.

Which three steps must you perform before you start the upgrade? (Choose three.)

Options:

Configure a flashback retention target and the Fast Recovery Area.

Configure the Fast Recovery Area.

Configure the database in ARCHIVELOG mode.

Create a normal restore point.

Take a database backup.

Create a guaranteed restore point.

Question 3

You want to move your existing recovery catalog to another database.

Examine the steps:

1) Export the catalog data by using the Data Pump Export utility in the source database.

2) Create a recovery catalog user and grant the necessary privileges in the target database.

3) Create a recovery catalog by using the CREATE CATALOG command.

4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.

5) Import the source recovery catalog schema by using the RMAN IMPORT CATALOG command.

6) Connect to the destination database.

7) Connect as CATALOG to the destination recovery catalog schema.

Identify the option with the correct sequence for moving the recovery catalog.

Options:

1, 6, 4

2, 3, 7, 5

1, 2, 6, 4

1, 2, 3, 6, 5

Question 4

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.

Which two statements are true? (Choose two.)

Options:

Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.

All database listeners running from the database home are automatically added to the Oracle Restart configuration.

The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.

The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.

All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Question 5

Examine this query:

SELECT cust_name, amt_due

FROM customers

AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)

WHERE cust_no = 'AYR2011';

Which two requirements guarantee that the query will execute successfully? (Choose two.)

Options:

Row movement must be enabled for CUSTOMERS.

Automatic Undo Management must be configured.

FLASHBACK must be ON for the database.

Undo retention guarantee must be enabled.

The database must be in ARCHIVELOG mode.

Supplemental logging must be enabled.

Question 6

You execute the commands to configure settings in RMAN:

Then, you issue the following command to take a backup:

Which statement is true about the execution of these commands?

Options:

The backup terminates because the backup destination for disk is not specified in the BACKUP command.

It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.

It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.

It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

Question 7

Which three RMAN persistent settings can be set for a database? (Choose three.)

Options:

backup retention policy

default backup device type

default section size for backups

default destinations for backups

multiple backup device types for a single backup

Question 8

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

Options:

The PDB is closed and the temp file is re-created automatically when the PDB is opened.

The PDB is closed and requires media recovery at the PDB level.

The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

Question 9

Examine the following set of RMAN commands:

Which statement is true about the RMAN RUN block execution?

Options:

The script is executed and both DC1 and CH1 channels are used for script execution.

The execution of the script fails because multiple channels cannot exist simultaneously.

The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

The new channel, CH1, is ignored because a channel has been configured already.

Question 10

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.)

Options:

One channel is allocated.

Two channels are allocated.

The backup set is created in parallel in two locations.

The backup set is created in parallel only in one location.

The backup set is created serially in only one location.

Question 11

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

Options:

statistics recommendations

SQL profile recommendations

SQL statement restructure recommendations

creation of materialized views to improve query performance

Question 12

You issue the command:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Which statement is true about the command?

Options:

It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

It creates a file that contains the SQL statement, which is required to re-create the control file.

It updates the alert log file with the location and contents of the control file.

It creates a binary backup of the control file.

Question 13

Which two are true about RMAN image copies? (Choose two.)

Options:

The can only be written to disk.

They are the only backup option available for database in NOARCHIVELOG mode.

They can be encrypted using Transparent Data Encryption (TDE).

They can be used as a level 0 incremental backup.

Question 14

You take your database backups by using the RMAN media management interface (MMI).

Which two are true about the use of the RMAN MMI? (Choose two.)

Options:

You can use it to create image copies for entire file systems.

You can use it to create image copies for database files.

You can use it to create backup sets for database files.

You can use it to create proxy copies for database files.

You can use it to create proxy copies for entire file systems.

Question 15

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

Options:

to report on the database schema at an earlier point in time

to store backups that would cause the controlfile to become too large

to allow database duplication without a connection to the target instance

to allow database duplication without a connection to the auxiliary instance

to store backup metadata that would cause the controlfile to become too large

Question 16

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.

Which two best methods for recovering the truncated table data? (Choose two.)

Options:

Table Point-in-Time Recovery

Database Point-in-Time Recovery

Tablespace Point-in-Time Recovery

Flashback Database

Flashback Transaction Backout

Question 17

Examine the output:

SQL> ARCHIVE LOG LIST

Database log modeArchive Mode

Automatic archival Enabled

Archive DestinationUSE_DB_RECOVERY_FILE_DEST

Oldest online log sequence376

Next log sequence to archive378

Current log sequence378

Which three types of files are automatically placed in the fast recovery area? (Choose three.)

Options:

Flashback data archives (FDA)

Archived redo log files

Control file autobackups

Server parameter file (SPFILE)

Recovery Manager (RMAN) backup pieces

Question 18

Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.

Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

Options:

Supplemental logging is not enabled for the database.

The undo data that existed for versions of rows before the change to the table structure is invalidated.

The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.

Undo retention guarantee is not enabled.

Flashback Data Archive is full after the first update statement.

Question 19

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)

Options:

DATE

TIMESTAMP

INTERVAL YEAR TO MONTH

INTERVAL DAY TO SECOND

TIMESTAMP WITH LOCAL TIME ZONE

Question 20

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

You execute this command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

Options:

The minimum size for the standard buffer cache is 100 MB.

The maximum size for the standard buffer cache is 100 MB.

The minimum space guaranteed in the buffer cache for any server process is 100 MB.

The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

The minimum size for all buffer caches is 100 MB.

Question 21

Which three statements are true about the SQL*Loader utility? (Choose three.)

Options:

It can be used to load data from multiple external files into multiple tables.

It can be used to extract and reorganize data from external files, and then load it into a table.

It can be used to load data from external files using direct path only.

It can be used to create tables using data that is stored in external files.

It can be used to generate unique sequential values in specified columns while loading data.

Question 22

Which two components are contained only in CDB$ROOT? (Choose two.)

Options:

the unified audit trail

database links between PDBs in the CDB

PDB service names

resource manager plans for each PDB in the CDB

the default TEMP tablespace for the entire CDB

Question 23

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.

Examine the steps to recover this table from an RMAN backup:

1. Determine which backup contains the table that needs to be recovered.

2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.

3. Import the Data Pump export dump file into the auxiliary instance.

4. Create a Data Pump export dump file that contains the recovered table on a target database.

Identify the required steps in the correct order.

Options:

1, 4, 3

1, 2

1, 4, 3, 2

1, 2, 4

Question 24

Examine the statements that use flashback technologies:

1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);

2. SELECT * FROM customers AS OF SCN 123456;

3. FLASHBACK TABLE customers TO BEFORE DROP;

4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);

5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;

6. ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace?

Options:

1, 2, 5

1, 3, 6

2, 3, 5, 6

3, 4, 5

Question 25

Your database is running in ARCHIVELOG mode. Examine the initialization parameters you plan to set for your database instance.

LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'

LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'

LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'

L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'

Identify the statement that correctly describes these settings.

Options:

An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.n destinations.

Optional destinations cannot use the fast recovery area.

An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.

These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DEST is set to a value of 4.

Question 26

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.

Examine the steps required to recover the database:

1. Restore an autobackup of the server parameter file.

2. Restore the control file.

3. Start up the database instance in NOMOUNT state.

4. Mount the database.

5. Restore the data files.

6. Open the database with the RESETLOGS option.

7. Recover the data files.

8. Set DBID for the database.

Identify the required steps in the correct order.

Options:

1, 8, 3, 2, 4, 5, 7, 6

8, 1, 3, 2, 4, 5, 7, 6

1, 3, 2, 4, 8, 5, 6, 7

8, 3, 2, 4, 5, 7, 6

8, 1, 3, 2, 4, 5, 6

Question 27

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.

Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)

Options:

Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

All the constraints defined on the table, except the referential integrity constraints, are flashed back.

All the triggers associated with the table are flashed back but are disabled.

Materialized views that use the CUSTOMERS table are flashed back.

LOB segments associated with the CUSTOMERS table are flashed back.

Question 28

Users report this error message when inserting rows into the orders table:

ERROR at line1:

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.

Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

Options:

drop and re-create the index

coalesce the order.ind index

coalesce the indexes tablespace

perform an on line table rebuild using dbms_redefinition

rebuild the index online moving it to another tablespace that has enough free space for the index

Question 29

Examine the parameters for your database instance:

NAME TYPE VALUE

------------------------------------------------

optimizer_adaptive_reporting_only boolean FALSE

optimizer_capture_sql_plan_baselines boolean FALSE

optimizer_dynamic_sampling integer 2

optimizer_features_enable string 12.1.0.1

Which three statements are true about the process of automatic optimization by using statistics feedback? (Choose three.)

Options:

The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

The optimizer can re optimize a query only once using cardinality feedback.

The optimizer enables monitoring for cardinality feedback after the first execution of a query.

The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Question 30

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

Options:

A PDB must be in closed state before it can be unplugged.

A PDB must have been opened at least once after creation.

A PDB must be in MOUNT state before it can be unplugged.

PDB data files are automatically removed from disk.

An unplugged PDB can be plugged into the same or another container database (CDB).

Question 31

Which four actions are possible during an Online Datafile Move operation? (Choose four.)

Options:

Creating and dropping tables in the datafile being moved

Performing file shrink of the data file being moved

Querying tables in the datafile being moved

Performing Block Media Recovery for a data block in the datafile being moved

Flashing back the database

Executing DML statements on objects stored in the datafile being moved

Question 32

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?

Options:

It succeeds and displays all the tablespaces that belong to the root database.

It fails and returns an error because a connection is not made by using the SYSDBA privilege.

It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

Question 33

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

Which table organization allows for generating the bills with minimum degree of row sorting?

Options:

a hash cluster

an index cluster

a partitioned table

a sorted hash cluster

a heap table with a rowid column

Question 34

Examine this command:

SQL> CREATE DATABASE cdb1

DEFAULT TABLESPACE users

DEFAULT TEMPORARY TABLESPACE temp

UNDO TABLESPACE undotbs1

ENABLE PLUGGABLE DATABASE

SEED

SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

SYSAUX DATAFILES SIZE 100M;

Which two requirements must be met to ensure that CDB1 is created? (Choose two.)

Options:

The ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE.

The PDB_FILE_NAME_CONVERT parameter must be configured.

The FILE_NAME_CONVERT clause must be added to the command.

The USER_DATA TABLESPACE clause must be added to the command.

The DB_CREATE_FILE_DEST parameter must be configured.

Question 35

Which two are true about incremental backups? (Choose two.)

Options:

A backup set can be used as the baseline for an incremental backup.

Differential backups can be taken at level 0.

An image copy can be used as the baseline for an incremental backup.

A tablespace incremental level 1 backup always backs up all blocks in the backed up tablespace.

Incremental backups are not permitted when using block change tracking.

A database incremental level 0 backup always backs up all database blocks.

Question 36

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

Options:

The backup must be performed in MOUNT state.

The tablespace must be taken offline.

All files must be backed up as backup sets.

The database must be backed up as an image copy.

Question 37

Your database is in ARCHIVELOG mode and is open.

You issue this command successfully:

Which two are true? (Choose two.)

Options:

Online logs are backed up.

The backup becomes obsolete after one day.

The restore point is automatically deleted after one day.

The restore point TESTDB06 is created.

The existing restore point TESTDB06 is updated.

Archived redo logs are backed up.

Question 38

You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.

One of the data files is corrupted and the current online redo log file is lost because of a media failure.

Which action must you take for recovery?

Options:

Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.

Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Restore all the data files, recover them by using the recover database command, and open the database.

Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Question 39

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)

Options:

Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB.

Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB.

Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.

Question 40

Which two statements are true about RMAN duplexed backups? (Choose two.)

Options:

It is only supported for backups to tape via the media management interface.

It is not supported for image copies.

For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

Duplex backups can contain only data files and control files.

Question 41

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

Options:

A supplemental log must be enabled for the primary key.

Undo retention guarantee must be configured for the database.

Fast Recovery Area must be enabled for the database.

The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

Row movement must be enabled.

Exam Detail

Vendor: Oracle

Certification: Oracle Other Certification

Exam Code: 1z0-063

Exam Name: Oracle Database 12c: Advanced Administration

Last Update: Dec 22, 2024

1z0-063 Question Answers

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-063 Dumps Questions Answers

Oracle Database 12c: Advanced Administration Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options: