How does SQL handle NULL values in arithmetic expressions?

• A.Produces an error
• B.Treats them as zero
• C.Treats them as the largest possible number
• D.Produces a NULL result

Comment: *

Name: *

Email: *

Verification: *

The column data type is converted to a primary key.

• A.CREATE ALIAS
• B.CREATE SEQUENCE
• C.CREATE SYNONYM
• D.CREATE INDEX

Comment: *

Name: *

Email: *

Verification: *

Which command creates a new role in Oracle Database?

• A.CREATE ROLE role_name;
• B.CREATE NEW ROLE role_name;
• C.ADD ROLE role_name;

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of a correlated subquery?

• A.A subquery that depends on the result of another subquery
• B.A subquery that references columns from the outer query
• C.A subquery that combines data from multiple tables
• D.A subquery that can be used only with aggregate functions

Comment: *

Name: *

Email: *

Verification: *

Which data dictionary view provides information about all the columns in tables accessible to the current user?

• A.DBA_TAB_COLUMNS
• B.USER_COLUMNS
• C.ALL of the above
• D.ALL_TAB_COLUMNS

Comment: *

Name: *

Email: *

Verification: *