Which statement is true regarding external tables?

• A.The CREATE TABLE AS SELECT statement can be used to upload data into a normal table in the database from an external table.
• B.The data and metadata for an external table are stored outside the database.
• C.The default REJECT LIMIT for external tables is UNLIMITED.
• D.ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.

Comment: *

Name: *

Email: *

Verification: *

Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)

• A.Read data from a table in the database and insert it into an external table
• B.Create a directory object for an external table
• C.Create a directory object for a flat file
• D.Read data from an external table and load it into a table in the database
• E.Query data from an external table
• F.Execute DML statements on an external table

Comment: *

Name: *

Email: *

Verification: *

Which three are true about privileges and roles?

• A.PUBLIC acts as a default role granted to every user in a database.
• B.System privileges always set privileges for an entire database.
• C.A role is owned by the user who created it.
• D.A role can contain a combination of several privileges and roles.
• E.A user has all object privileges for every object in their schema by default.
• F.PUBLIC can be revoked from a user.
• G.All roles are owned by the SYS schema.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMP_DETAILS table given below:

Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?

• A.An EMP_IMAGE column cannot be included in the ORDER BY clause.
• B.You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column.
• C.You cannot add a new column to the table with LONG as the data type.
• D.An EMP_IMAGE column can be included in the GROUP BY clause.

Comment: *

Name: *

Email: *

Verification: *

Examine this query:
SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL;
What is the result?

• A.16
• B.200
• C.100
• D.160
• E.150

Comment: *

Name: *

Email: *

Verification: *