0

databases Online Quiz - 107

Description: databases Online Quiz - 107
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. proc sort data = Wegiht_Activa; by descending weight; run;

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

  3. proc sort data=Weight_Activa;weight by descending ;run

  4. B&C


Correct Option: A

What is the statement that will be used to select required columns in the PROC PRINT?

  1. Statement VAR

  2. Statement By

  3. option OBS

  4. none if the above


Correct Option: A

SUM statement usage in PROC PRINT step is Generating column totals for numeric variables to be summed ?

  1. True

  2. False


Correct Option: A

Which of the follwing option will be used to split the long names for the columns in proc print ?

  1. label

  2. Split

  3. break

  4. unstring


Correct Option: B
  1. n-count,mean,standerd deviation,Min and MAX values

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

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

  4. both b&c


Correct Option: A
  1. PROC COPY will be used to copy files from one library to another library

  2. PROC COPY copies columns from one dataset to another

  3. Proc Copy copies oberservations from one library to another

  4. All of the above


Correct Option: A

What is the statement to specify the varibales in the Freq procdure

  1. VAR

  2. TABLES

  3. BY

  4. COLUMNS


Correct Option: B
  1. INSERT INTO r4r_team (id, username, exp) VALUES (1, ‘r4r01’, ‘2’);

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

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

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


Correct Option: A,B
  1. Used to select username,exp, salary from r4r_team which is decreasing order by username.

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

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

  4. none


Correct Option: A

Which is true for AND & OR

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

  2. These Operators are used to join two tables.

  3. Never used in SQL

  4. None


Correct Option: A
  1. BETWEEN -->>Used for range with in values

  2. LIKE -->>Used for Search a pattern

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

  4. None


Correct Option: A,B,C

<> and != both are same operator into SQL

  1. true.

  2. false.

  3. both are not used into SQL.

  4. Both are used assembly languages only.


Correct Option: A

Which is not used into SQL =,<>,> ,=,<=,>>>

  1. all are used

  2. only >>> not used

  3. only <>

  4. None


Correct Option: B

What is a PK

  1. UK + Not null

  2. UK

  3. UK + null

  4. UKKKK


Correct Option: A
  1. FK

  2. PK

  3. UK

  4. CPK


Correct Option: A
  1. UK

  2. PK

  3. FK

  4. CPK


Correct Option: A
- Hide questions