Tag: programming languages

Cursor FOR loop

FETCH statement

%ISOPEN attribute

Parameters

ANALYZE_SCHEMA

CREATE OR REPLACE

SHOW ERRORS

FORMAT_ERROR_STACK

True

False

func( 9, 5.67 )

func( 4 )

func()

func( ,4 )

Pointer

References

Both

None of the above

for a

is a

with a

has a

True

False

Only Carl can access the EMPLOYEE synonym.

The EMPLOYEE synonym is a public synonym.

The synonym name cannot be the same as the object name.

Stanley can access the EMPLOYEE synonym.

The synonym can be accessed remotely.

The EMPLOYEE synonym is a private synonym.

SELECT lname, jobid, sal, sal+500 FROM emp;

SELECT lname, jobid, sal FROM emp (sal + 500);

SELECT lname, jobid, sal, sal + 500 “Bonus” FROM emp;

SELECT lname, jobid, sal, sal + 500 bonus FROM emp

SELECT lname || to_char(sal+500) “Employee Bonus” FROM emp;

SELECT lname, sal + 500 Employee Bonus FROM emp;

This is an equijoin.

This is a self join.

Line 2 will return an error.

Line 3 will return an error.

The statement will execute successfully.