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

Which of the following is the syntax for sorting the dataset in descending order

  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

Which of the follwing variables will be produced by PROC MEANS procedure?

  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

Which of the following oprions will be used to limit the decimal places in proc Means ?

  1. MAXDEC

  2. DEC

  3. MINDEC

  4. LIMITDEC


Correct Option: A

Which one of the follwoing statment will be used to specify the variables that PROC MEANS analyzes?

  1. VAR

  2. BY

  3. COL

  4. None of the above


Correct Option: A

Which of the follwoing Statement will be used to produce separate analyses of grouped observations in Means procedure

  1. VAR

  2. CLASS

  3. BY

  4. LIMIT


Correct Option: B

Which of the follwing statement is correct regarding the PROC COPY procedure ?

  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

Choose correct syntax to insert values into r4r_team table

  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

AI Explanation

To answer this question, we need to understand the correct syntax for inserting values into a table in SQL.

Option A) INSERT INTO r4r_team (id, username, exp) VALUES (1, 'r4r01', '2'); This option is correct because it follows the correct syntax for inserting values into specific columns of a table. The column names are specified after the table name in parentheses, and the values are specified after the keyword "VALUES" in parentheses.

Option B) INSERT INTO r4r_team VALUES (1, 'r4r01', '2'); This option is also correct because it follows the shorthand syntax for inserting values into all columns of a table. In this case, the column names are not specified, and the values are directly listed after the table name.

Option C) INSERT INTO r4r_team (id, username, exp) VALUE (1, 'r4r01', '2'); This option is incorrect because it uses the singular form "VALUE" instead of "VALUES". The correct keyword is "VALUES" to insert multiple values at once.

Option D) INSERT INTO table r4r_team (id, username, exp) VALUE (1, 'r4r01', '2'); This option is incorrect because it includes the keyword "table" before the table name. The correct syntax is to directly specify the table name after the "INSERT INTO" statement without using the "table" keyword.

Therefore, the correct answers are options A and B.

What is true for following DML SQL statement SELECT username, exp, salary FROM r4r_team ORDER BY username DESC;

  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

Choose true option

  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

What is a FK

  1. FK

  2. PK

  3. UK

  4. CPK


Correct Option: A

What is a UK

  1. UK

  2. PK

  3. FK

  4. CPK


Correct Option: A
- Hide questions