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

• A.The WITH CHECK clause prevents certain rows from being displayed when querying the view
• B.Data Manipulation Language (DML) can always be used on views
• C.The WITH CHECK clause prevents certain rows from being updated or inserted
• 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.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

Comment: *

Name: *

Email: *

Verification: *

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A.Dynamic service registration cannot be used for this database instance
• B.The LREG process registers services dynamically with the LISTENER_1 listener
• C.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• D.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• E.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A.Set OS_AUTHENT_PREFIX to OPS$
• B.Have the OS administrator add KING to the OSDBA group
• C.Grant DBA to KING
• D.Unset REMOTE_LOGIN_PASSWORDFILE
• E.Alter user KING to be IDENTIFIED EXTERNALLY

Comment: *

Name: *

Email: *

Verification: *

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

• A.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
• B.The names and number of columns must be identical for all SELECT statements in the query.
• C.The number, but not names, of columns must be identical for all SELECT statements in the query.
• D.The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.
• E.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about single row functions? (Choose two.)

• A.MOD : returns the quotient of a division operation
• B.TRUNC : can be used with NUMBER and DATE values
• C.CONCAT : can be used to combine any number of values
• D.FLOOR : returns the smallest integer greater than or equal to a specified number
• E.CEIL : can be used for positive and negative numbers

Comment: *

Name: *

Email: *

Verification: *