Tag: databases

VAR

CLASS

BY

LIMIT

PROC COPY will be used to copy files from one library to another library

PROC COPY copies columns from one dataset to another

Proc Copy copies oberservations from one library to another

All of the above

VAR

TABLES

BY

COLUMNS

INSERT INTO r4r_team (id, username, exp) VALUES (1, ‘r4r01’, ‘2’);

INSERT INTO r4r_team VALUES (1, ‘r4r01’, ‘2’);

INSERT INTO r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

INSERT INTO table r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

Used to select username,exp, salary from r4r_team which is decreasing order by username.

Used to select username,exp, salary from r4r_team which is increasing order by username.

Used to select username,exp, salary from r4r_team which is decreasing order by exp.

none

These are Operators .Which are used to filter records based on more than one conditions.

These Operators are used to join two tables.

Never used in SQL

None

BETWEEN -->>Used for range with in values

LIKE -->>Used for Search a pattern

IN -->>return east one of the columns in given set of values

None

true.

false.

both are not used into SQL.

Both are used assembly languages only.

all are used

only >>> not used

only <>

None

UK + Not null

UK

UK + null

UKKKK