Tag: technology

GRANT select ON dept TO ALL USERS;

GRANT select ON dept TO ALL;

GRANT QUERY ON dept TO ALL USERS;

GRANT select ON dept TO PUBLIC;

A MERGE statement is used to merge the data of one table with data from another

A MERGE statement replaces the data of one table with that of another

A MERGE statement can be used to insert new rows into a table

A MERGE statement can be used to update existing rows in a table

Once created, a sequence belongs to a specific schema

Once created, a sequence is linked to a specific table

Once created, a sequence is automatically available to all users

Only the DBA can control which squence is used by certain a table

Once created, a sequence is automatically in all INSERT and UPDATE statements

2,3

3,2

2,2

3,3

a=5 b=6

a=6 b=5

a=6 b=0

None of the above

Compile-Time error

5 -6

5 65530

none of the above

Compile-Time error

Run-Time Error

24

Unpredictable

Compile-Time Error

i=1680 j=1680

i=629 j=6561

i=1681 j=3024

Compile-Time Error

10 9 8 7 6

9 8 7 6 6

10 8 7 6 6

Compile-Time Error

2

4

1