Which two are true about the roles? (Choose two.)

• A.The SET ROLE statement enables as well as disables roles in a session.
• B.The SET ROLE statement can be used once per session.
• C.All privileges and roles granted to a user are enabled by default when the user logs in.
• D.The ALTER USER statement must be used to set specific default roles for a user.
• E.A role must be disabled before it can be revoked from a user.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about views in an Oracle database? (Choose three.)

• A.The WITH CHECK clause prevents certain rows from being updated or inserted
• B.The WITH CHECK clause prevents certain rows from being displayed when querying the view
• C.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• D.Views can be updated without the need to re-grant privileges on the view
• E.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• F.Tables in the defining query of a view must always exist in order to create the view
• G.Data Manipulation Language (DML) can always be used on views

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the DUAL table? (Choose two.)

• A.It can be accessed only by the SYS user
• B.It consists of a single row and single column of VARCHAR2 data type
• C.It can display multiple rows but only a single column
• D.It can be used to display only constants or pseudo columns
• E.It can be accessed by any user who has the SELECT privilege in any schema
• F.It can display multiple rows and columns

Comment: *

Name: *

Email: *

Verification: *

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR QUERY LOW
• B.ROW STORE COMPRESS BASIC
• C.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E.ROW STORE COMPRESS ADVANCED

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about UNDO and REDO? (Choose two.)

• A.The generation of UNDO generates REDO
• B.DML modifies Oracle database objects and only generates UNDO
• C.The generation of REDO generates UNDO
• D.DML modifies Oracle database objects and only generates REDO
• E.DML modifies Oracle database objects and generates UNDO and REDO

Comment: *

Name: *

Email: *

Verification: *