For which two database objects can the VERSIONS clause of th

第1题：

第2题：

Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  

• A、 The VERSIONS BETWEEN clause may be used in DML statements.
• B、 The VERSIONS BETWEEN clause may be used in DDL statements.
• C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
• D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

第3题：

第4题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in

第5题：

Which of the following database objects can be used to raise an error if a table is updated?（）

• A、Package
• B、Trigger
• C、Stored Procedure
• D、Informational Constraint

第6题：

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）

• A、Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• B、The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• C、The command will, create a common user whose description is contained in the root and each pdb.
• D、The schema for the common user C # # A_ADMIN can be different in each container.
• E、The command will create a user in the root container only because the container clause is not used

第7题：

Which two statements about views are true? （）

• A、A view can be created as read only.
• B、A view can be created as a join on two or more tables.
• C、A view cannot have an ORDER BY clause in the SELECT statement.
• D、A view cannot be created with a GROUP BY clause in the SELECT statement.
• E、A view must have aliases defined for the column names in the SELECT statement.

第8题：

第9题：

You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

• A、 VERSIONS_STARTSCN
• B、 VERSIONS_STARTTIME
• C、 VERSIONS_XID
• D、 VERSIONS_OPERATION

第10题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

• A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
• B、 You can use this feature to identify the versions of V$ views.
• C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
• D、 You can use this feature for a table only if row movement is enabled for the table.
• E、 You can use this feature to identify the versions of external and fixed tables.