The Oracle 1Z0-062 Sample Question Set is designed to help you prepare for the Oracle Database 12c Administration (1Z0-062) certification exam. To become familiar with actual Oracle Certification exam environment, we suggest you to try Sample Oracle 1Z0-062 Certification Practice Exam.
This sample Oracle 1Z0-062 certification practice exam is designed for evaluation purposes only. If you really want to test your knowledge to identify your weak areas and familiarize with actual exam format, we suggest you to practice with Premium Oracle 1Z0-062 Certification Practice Exam for Oracle Database 12c Administration (1Z0-062) certification. Our team of Oracle Database experts have designed Questions-Answers for this premium practice exam by collecting inputs from recently certified candidates. Hence, We strongly recommend you to use Premium Oracle 1Z0-062 Certification Practice Exam to clear your actual Oracle 1Z0-062 Certification Exam with great score.
1Z0-062 Sample Questions:
01. A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:
1. The user account must be locked after five unsuccessful login attempts.
2. Data read per session must be limited for the user.
3- The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?
a) by granting a secure application role to the user
b) by implementing Database Resource Manager
c) by using Oracle Label Security options
d) by assigning a profile to the user
02. Which two statements correctly describe the relationship between data files and logical database structures?
a) A segment cannot span data files.
b) A data file can belong to only one tablespace.
c) An extent cannot span data files.
d) The size of an Oracle data block in a data file should be the same as the size of an OS block.
03. Which two tasks can be performed on an external table?
a) partitioning the table
b) creating an invisible index
c) updating the table by using an update statement
d) creating a public synonym
e) creating a view
04. Which three statements are true about a job chain?
a) It can contain a nested chain of jobs.
b) It can be used to implement dependency-based scheduling.
c) It cannot invoke the same program or nested chain in multiple steps in the chain.
d) It cannot have more than one dependency.
e) It can be executed using event-based or time-based schedules.
05. Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).
a) Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
b) Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
c) Use the DBMS_PDB package to clone an existing PDB.
d) Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
e) Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (220.127.116.11.0) non-CDB database into an existing CDB.
06. Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);
Which three statements are true about the effect of this command?
a) Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
b) Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
c) Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time
d) Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
e) Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
07. Which two are true concerning a multitenant container database with three pluggable database?
a) All administration tasks must be done to a specific pluggable database.
b) The pluggable databases increase patching time.
c) The pluggable databases reduce administration effort.
d) The pluggable databases are patched together.
e) Pluggable databases are only used for database consolidation.
08. Examine the current value for the following parameters in your database instance:
Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTS table?
a) The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
b) The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
c) Referential integrity constraint cannot be set on the invisible column.
d) The invisible column cannot be made visible and can only be marked as unused.
e) A primary key constraint can be added on the invisible column.
09. Which two are prerequisites for performing a flashback transaction?
a) Flashback Database must be enabled.
b) Undo retention guarantee for the database must be configured.
c) EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
d) Supplemental logging must be enabled.
e) Recycle bin must be enabled for the database.
f) Block change tracking must be enabled tor the database.
10. Choose the best statement from the options related to segments.
a) A contiguous set of blocks constitutes a segment.
b) A nonpartitioned table can have only one segment.
c) A segment can belong to more than one tablespace.
d) All of the above are true.
Answer: b, c
Answer: d, e
Answer: a, b, e
Answer: a, c, d
Answer: c, d, e
Answer: d, e
Answer: a, b, e
Answer: c, d