Free Access Oracle.1Z0-060.v2022-02-12.q102 Practice Test (Page 22)

Home
Oracle Certification
1Z0-060 Exam
Oracle.1Z0-060.v2022-02-12.q102 Practice Test

««
«
…
13
14
15
16
17
18
19
20
21
22

Question 101

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A.The valid time columns employee_time_start and employee_time_end are automatically created.

B.The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C.The valid time columns are not populated by the Oracle Server automatically.

D.The valid time columns are visible by default when the table is described.

E.Setting the session valid time using DBMS_FLASHBACK_ARCHIVENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Correct Answer: A,B,E

A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause would be creating them internally.
E: ENABLE_AT_VALID_TIME Procedure
This procedure enables session level valid time flashback.

Comment: *

Name: *

Email: *

Verification: *

Question 102

You created a new database using the "CREATE DATABASE" statement without specifying the "ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE DATABASE" clause? (Choose two.)

A.The database is created as a non-CDB and can never contain a PDB.

B.The database is created as a PDB and must be plugged into an existing multitenant container database (CDB).

C.The database is created as a non-CDB and can never be plugged into a CDB.

D.The database is created as a non-CDB but can be plugged into an existing CDB.

E.The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

Correct Answer: A,D

Explanation
A (not B, not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.
D: You can create a PDB by plugging in a Non-CDB as a PDB.
The following graphic depicts the options for creating a PDB:

Comment: *

Name: *

Email: *

Verification: *

««
«
…
13
14
15
16
17
18
19
20
21
22

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 162TheSecOpsGroup.CNSP.v2025-09-08.q20; 221CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 184Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

[×]

Download PDF File

Enter your email address to download Oracle.1Z0-060.v2022-02-12.q102 Practice Test

Email: