Validated Oracle 1Z0-063 Free Practice Test Online

NEW QUESTION 1

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

• A. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
• B. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
• C. All the triggers associated with the table are flashed back but are disabled.
• D. Materialized views that use the CUSTOMERS table are flashed back.
• E. LOB segments associated with the CUSTOMERS table are flashed back.

Answer: BE

Explanation:
B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that reference other tables.

NEW QUESTION 2

You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT ‘/disk1/%U; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT ‘/disk2/%U; RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUP command?

• A. The default channel is allocated and the backup set is created in only one destination.
• B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.
• C. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.
• D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2.

Answer: B

NEW QUESTION 3

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?

• A. The minimum size for the standard buffer cache is 100 MB.
• B. The maximum size for the standard buffer cache is 100 MB.
• C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
• D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
• E. The minimum size for all buffer caches is 100 MB.

Answer: A

NEW QUESTION 4

A user issues a query on the sales table and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace? (Choose two.)

• A. Drop the tenp01.dbf file, and then re-create the temp file.
• B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
• C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
• D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
• E. Create a new temporary tablespace and assign it as the default to the user.

Answer: BE

NEW QUESTION 5

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in
which several databases are registered. Both databases are open.
You execute the RMAN commands:

Which two tasks are performed as part of the import? (Choose two.)

• A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
• B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
• C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
• D. Imported databases are unregistered from the RC11 catalog.
• E. Recovery catalog is resynchronized with the control files of the registered databases.

Answer: AD

NEW QUESTION 6

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

• A. The backup must be performed in MOUNT state.
• B. The tablespace must be taken offline.
• C. All files must be backed up as backup sets.
• D. The database must be backed up as an image copy.

Answer: C

NEW QUESTION 7

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

• A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
• B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
• C. by using Active Session History (ASH) data and performing hang analysis
• D. by running ADDM in diagnostic mode

Answer: A

NEW QUESTION 8

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

• A. tracking the most recent read time for a table segment in a user tablespace
• B. tracking the most recent write time for a table segment in a user tablespace
• C. tracking insert time by row for table rows
• D. tracking the most recent write time for each block in a table segment
• E. tracking the most recent read time for a table segment in the sysaux tablespace
• F. tracking the most recent write time for a table segment in the sysaux tablespace

Answer: ABD

NEW QUESTION 9

Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true? (Choose two.)

• A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
• B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
• C. The tablespace specifications of pdb2 are the same as pdb1.
• D. All database objects belonging to common users in PDB1 are cloned in PDB2.
• E. pdb2 is created with its own private undo and temp tablespaces.

Answer: AC

NEW QUESTION 10

Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create CDB1 container database (CDB): SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE
temp
UNDO TABLESPACE
Undotbsl ENABLE
PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATAFILES SIZE 100M;
Which three statements are true? (Choose three.)

• A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
• B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
• C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
• D. It sets the users tablespace as the default for both the root and seed databases.
• E. undotbs1 is used as the undo tablespace for both the root and seed databases.
• F. It creates a multitenant container database with the root database opened and the seed database mounted.

Answer: ABE

NEW QUESTION 11

Examine the RMAN commands executed in your database: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command? (Choose two.)

• A. It performs a log switch.
• B. It creates compressed backup sets by using binary compression by default.
• C. It backs up only the used blocks in data files.
• D. It backs up data files, the control file, and the server parameter file.
• E. It creates a backup of only the control file whenever the database undergoes a structural change.

Answer: CD

NEW QUESTION 12

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

• A. It generates a log file containing the fixes that can be made to the source database.
• B. It recompiles all invalid PLSQL and Java code.
• C. It provides parallel upgrade options to finish the upgrade process with a reduced down time.
• D. It provides a summary of the upgrade results.
• E. It generates fixup scripts to be run on the source database before upgrade.

Answer: C

NEW QUESTION 13

Which three statements are true about Consolidated Database Replay? (Choose three.)

• A. The workload capture and replay systems must have the same operating system (OS).
• B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
• C. A subset of the captured workload can be replayed.
• D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
• E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Answer: BCE

NEW QUESTION 14

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAME TYPE VALUE
---------------- ------------------- -------------------
audit_file_dest string /u01/app/oracle/admin/eml2rep/adump background_dump_dest string
core_dump_dest string db_create_file_dest string
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area diagnostic_dest string
What is the location of the ADR base?

• A. It is set to /u01/app/oracle/product:/12.1.0/db_1/log.
• B. It is set to /u01/app/oracle/admin/enl2r&p/adump.
• C. It is set to /u01/app/oracle.
• D. It is set to /u01/app/oracle/flash_recovery_area.

Answer: C

NEW QUESTION 15

You want to create a guaranteed restore point for your database by executing the command: SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command. (Choose two.)

• A. The database must be running in ARCHIVELOG mode.
• B. Flashback Database must be enabled.
• C. Fast Recovery Area must be enabled.
• D. The recyclebin must be enabled for the database.
• E. Undo retention guarantee must be enabled.
• F. A database backup must be taken.

Answer: AC

NEW QUESTION 16

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

• A. to store backup information of multiple databases in one place
• B. to restrict the amount of space that is used by backups
• C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
• D. to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog
• E. to automatically delete obsolete backups after a specified period of time

Answer: ACD

NEW QUESTION 17

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter: DB_FLASH_CACHE_FILE= ‘ /dev/f lash_device_1‘,‘ /dev/f lash_device_2‘ How should the D3_flash_cache_size be configured to use both devices?

• A. Set DB_FLASH_CACHE_SIZE=64G.
• B. Set D3_FLASH_CACHE_SIZE=64G, 64G.
• C. Set D3_FLASK_CACKE_SI2E=128G.
• D. db_flash_cache_SI2E is automatically configured by the instance at startup.

Answer: B

Explanation:
* Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for “Database Smart Flash Cache” area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by “DB Smart Flash Cache”
/dev/sda – size 32G
/dev/sdb – size 32G
/dev/sdc – size 64G
New view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read counts of each file|device and compute the average latency

NEW QUESTION 18

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

• A. Creating and dropping tables in the datafile being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the datafile being moved
• D. Performing Block Media Recovery for a data block in the datafile being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the datafile being moved

Answer: ACDF

NEW QUESTION 19

You want to export the pluggable database (PDB) HR_PDB1 from the multitenant container database (CDB) CDB1 and import it into the CDB2 CDB as the EMP_PDB1 PDB.
Examine the list of possible steps required to perform the task:
1. Create a PDB named EMP_PDB1.
2. Export the HR_PDB1 PDB by using the FULL clause.
3. Open the EMP_PDB1 PDB.
4. Mount the EMP_PDB1 PDB.
5. Synchronize the EMP_PDB1 PDB in restricted mode.
6. Copy the dump file to the Data Pump directory.
7. Create a Data Pump directory in the EMP_PDB1 PDB.
8. Import data into EMP_PDB1 with the FULL and REMAP clauses.
9. Create the same tablespaces in EMP_PDB1 as in HR_PDB1 for new local user objects. Identify the required steps in the correct order.

• A. 2, 1, 3, 7, 6, and 8
• B. 2, 1, 4, 5, 3, 7, 6, 9, and 8
• C. 2, 1, 3, 7, 6, 9, and 8
• D. 2, 1, 3, 5, 7, 6, and 8

Answer: C

NEW QUESTION 20

Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, the common user C##ADMIN and the local user B_ADMIN have only the CONNECT privilege.
You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE privileges.
You then execute the commands:

Which two statements are true? (Choose two.)

• A. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
• B. B_ADMIN can create and select any table in both the root container and HR_PDB.
• C. C##ADMIN can create and select any table in the root container and all the PDBs.
• D. B_ADMIN can create and select any table only in HR_PDB.
• E. The GRANT c##role1 TO b_admin command returns an error because CONTAINER should be set to ALL.

Answer: CD

NEW QUESTION 21

You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?

• A. Create both jobs by using Scheduler raised events.
• B. Create both jobs using application raised events.
• C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
• D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Answer: C

NEW QUESTION 22

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

• A. Database Resident Connection Pooling
• B. Oracle Suggested Backup Strategy
• C. Database Vault in ORACLE_HOME
• D. Non default block size tablespaces
• E. Configure Label Security

Answer: CE

NEW QUESTION 23

Your database supports an OLTP workload. Examine the output of the query:

To ensure faster instance recovery, you set the FAST_START_MTTR_TARGET initialization parameter to 30.
What is the effect of this setting on the database?

• A. Automatic checkpoint tuning is disabled.
• B. The frequency of log switches is increased.
• C. The overhead on database performance is increased because of frequent writes to disk.
• D. The MTTR advisor is disabled.

Answer: C

NEW QUESTION 24

Which three statements are true about compression of backup sets? (Choose three.)

• A. Compressed backups can only be written to media.
• B. Binary compression creates performance overhead during a backup operation.
• C. Unused blocks below the high-water mark are not backed up.
• D. Compressed backups cannot have section size defined during a backup operation.
• E. It works only for locally managed tablespaces.

Answer: BCE

NEW QUESTION 25
......