Tag: databases
Questions Related to databases
-
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
-
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