proc sort data = Wegiht_Activa; by descending weight; run;

proc sort data = Wegiht_Activa;descending by weight; run;

proc sort data=Weight_Activa;weight by descending ;run

B&C

True

False

Statement VAR

Statement By

option OBS

none if the above

True

False

label

Split

break

unstring

n-count,mean,standerd deviation,Min and MAX values

n-count,frequency,mean,standerd deviation,Min and MAX values

frequency,cumulative frequency ,mean,standerd deviation,Min and MAX values

both b&c

MAXDEC

DEC

MINDEC

LIMITDEC

VAR

BY

COL

None of the above

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

FK

PK

UK

CPK

UK

PK

FK

CPK