Oracle 1Z0-067 Free Practice Questions

NEW QUESTION 1
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

• A. It can be used to allow the access privilege settings for users but not roles.
• B. It can be used to allow the access privilege settings for users as well as roles.
• C. It can be used to control the time interval for which the access privilege is available to a user.
• D. It can be used to selectively restrict the access for each user in a database to different hostcomputers.
• E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

Answer: BCD

NEW QUESTION 2
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

• A. A DBA can check specific tables with the DMU
• B. The database to be migrated must be opened read-only.
• C. The release of the database to be converted can be any release since 9.2.0.8.
• D. The DMU can report columns that are too long in the converted characterset
• E. The DMU can report columns that are not represented in the converted characterset

Answer: ADE

Explanation: A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion. E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

NEW QUESTION 3
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?

• 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 use

Answer: BE

NEW QUESTION 4
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

• A. It returns an error because there is no level 0 backup available for new data files.
• B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
• C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
• D. It performs an image copy backup of all data files including those that belong to the new tablespace.
• E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.

Answer: B

Explanation: References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm

NEW QUESTION 5
Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

• A. The password for the encryption must be set up.
• B. Oracle wallet for the encryption must be set up.
• C. All the tablespaces in the database must be encrypted.
• D. Oracle Database Vault must be enabled.

Answer: B

Explanation:
Configuration encryption will used by Transparent encryption. For transparent encryption, you will need to create a wallet, and it must be open. Transparent encryption will then occur automatically
after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR TABLESPACE ON command. http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABH
CONFIGURE ENCRYPTION : You can use this command to persistently configure transparent encryption. You cannot persistently configure dual mode or password mode encryption. SET ENCRYPTION : You can use this command to configure dual mode or password mode encryption at the RMAN session level.

NEW QUESTION 6
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. 3, 2, 1, 4
• B. 2, 3, 4, 1
• C. 4, 1, 3, 2
• D. 3, 2, 4, 1

Answer: B

Explanation: Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column
groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the
DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for
each column group whenever statistics are gathered on the table. Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statistics
Here are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.
2 – Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute (“exec”) statement, Oracle extended statistics are created via a select statement.

NEW QUESTION 7
Examine these parameter settings: SGA_TARGET = 700M SGA_MAX_SIZE = 1024M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M
You attempt this:
SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140M
Which statement is true based on the information available?

• A. It will fail because DB_8K_CACHE_SIZE cannot be changed dynamically.
• B. It succeeds only if memory is available from the autotuned components of the SGA.
• C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
• D. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: B

NEW QUESTION 8
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace.
A user issues a query on the orders table and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?

• A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
• B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
• D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Answer: A

NEW QUESTION 9
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

• A. assigned to a class with rights to browse all directories and catalogs
• B. assigned to a class with rights to back up or restore Oracle database
• C. OSB encryption for data in transport and on tape
• D. RMAN preauthorization on the host
• E. matching the OS user identity of the Oracle instance associated with the database username
• F. scheduling of the RMAN backup to occur automatically at user-defined intervals

Answer: BDE

NEW QUESTION 10
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 the databases are open.
You execute the RMAN commands:
RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c RMAN> IMPORT CATALOG rc11/pwdcat11@ract11
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 database

Answer: AD

NEW QUESTION 11
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

• A. Oracle Data Pump
• B. Oracle Recovery Manager (RMAN)
• C. Oracle Label Security
• D. Oracle Database Vault
• E. Oracle Real Application Security

Answer: B

Explanation: Unlike other Oracle Database components, you do not create a unified audit policy for Oracle
Recovery Manager events. The UNIFIED_AUDIT_TRAIL data dictionary view has a set of fields, whose names begin with RMAN_, that automatically record Recovery Manager-related events. https://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDDHEIA

NEW QUESTION 12
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> 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?

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

Answer: ABD

NEW QUESTION 13
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?

• A. The PDB is closed.
• B. The PDB is placed in mount state.
• C. The command executes only if the common user is granted the set container privilege for the PDB.
• D. The command results in an error because the PDB can be shut down only by a local use

Answer: B

Explanation: The PDB is placed in mount state. SQL> shutdown immediate; Pluggable Database closed. SQL>
select status from v$instance; STATUS ———— MOUNTED SQL> There is no closed Status in a PDB. PDB can have Mount/Read Write/Read Only.

NEW QUESTION 14
Which two statements are true about service creation for pluggable databases (PDBs)?

• A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
• B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
• C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
• D. Only a common user can create additional services for a PDB.
• E. When a PDB is created, a service with the same name as the PDB is created in the PD

Answer: AC

NEW QUESTION 15
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID).
SSL has been configure for the database and OLD and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name. Which authentication method will be attempted first?

• A. authentication by password file
• B. authentication by using certificates over SSL
• C. authentication by using the Oracle Internet Directory
• D. authentication by using the local OS of the database server

Answer: A

Explanation: If the database is configured to use a password file for remote authentication, Oracle Database checks the password file first. http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authentication.htm

NEW QUESTION 16
Which parameter must be set to which value to implement automatic PGA memory management?

• A. Set memory_target to zero.
• B. Set STATISTICS_LEVEL to BASIC.
• C. Set pga_aggregate_target to a nonzero value.
• D. Set pga_aggregate_target and sga_target to the same value.
• E. Set sgajtarget to zer

Answer: C

Explanation: When automatic memory management is not enabled, the default method for the instance PGA is automatic PGA memory management http://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm

NEW QUESTION 17
Which three statements are true about the SQL*Loader utility?

• A. It can be used to load data from multiple external files into multiple tables.
• B. It can be used to extract and reorganize data from external files, and then load it into a table.
• C. It can be used to load data from external files using direct path only.
• D. It can be used to create tables using data that is stored in external files.
• E. It can be used to generate unique sequential values in specified columns while loading dat

Answer: ABE