A.It must resolve to a valid connect descriptor in the server's tnsnames.ora file

B.It must resolve to a valid connect descriptor in the client's tnsnames.ora file

C.It must be the name of the database to whose instance HR wishes to connect

D.It must be the value of the SERVICE_NAMES parameter on the client side

E.It must be the name of the server running the database to whose instance HR wishes to connect

A.CONCAT : can be used to combine any number of values

B.CEIL : can be used for positive and negative numbers

C.FLOOR : returns the smallest integer greater than or equal to a specified number

D.MOD : returns the quotient of a division operation

E.TRUNC : can be used to combine any number of values

A.EXPIRY_ DATE cannot be used in arithmetic expressions.

B.EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

C.PRODUCT_NAKE cannot contain duplicate values.

D.PRODUCT _price contains the value zero by default if no value is assigned to it.

E.PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

F.PRODUCT _ic can be assigned the PRIMARY KEY constraint.

A.It generates a sql script that it uses to load data from EMP.DAT to EMP

B.It appends data from EMP.DAT to EMP

C.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

D.It uses the database buffer cache to load data

E.It overwrites data in EMP with data in EMP.DAT

A.when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

B.when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

C.when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

D.when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

E.when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

F.when issuing a DML statement after a DML statement failed in the same session