COBOL-68

COBOL-74

COBOL-85

COBOL-9x

Regulate the transport of the table's data records during installs, upgrades, copies

Regulate the scope that you may use to display and maintain data records

Answers A & B

None of the above

a and b

x and y

p and f

c and n

Type N

Type C

Type F

Type P

Constants:x(3) type c value '123'.

Data:x(3) type c.

Constants:x(3) type c.

Data:x(3) type c value '123'.

All the lines of the table are deleted

The work area is initialized

All the lines of the table are initialized

Nothing

0

1

5

true

false

sql>

from emp

WHERE sal, bonus IN

WHERE deptid=20);

DELETE clause

UPDATE clause

ROWID pseudocolumn

FOR UPDATE clause

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.

var2 NUMBER := 0;

INTO var2

WHERE name = 'JORDAN';

var1 :=var2 + 2000;

There are no errors in this PL/SQL block