SQL interview Questions I

1>

Which is not true regarding the SQL Procedure:

a>A too for querying data
b>A tool for data manipulation and management
c>An augmentation to the data step.
d>A DATA step replacement.
2>

Which is not feature of Proc SQL:

a>The PROC SQL statement doesn't need to be repeated with each query.
b>No proc print step is needed to view query results.
c>Proc SQL is terminated with Run Statement.
d>No proc sort step is needed to order query results.

3>

Which Statement is False:

a>Select-->specifies the columns to be selected.
b>from -->specifies the table to be queried
c>where-->subsets the data based on a condtion.
d>having--works before the group by clause.

4>

Which option is used to check the syntax of entire PROC SQL without executing it?

a>Mlogic
b>feedback
c>Noexec
d>validate


5>

What is false regarding PROC SQL?

a>We can use arrays inside proc SQL.
b>PDV is created and we have implicit output and implicit return.
c>We can use if statement inside PROC SQL.
d>All

6>

What is false regarding CASE Expression in PROC SQL?

a>We can create variable by using it.
b>CASE expression returns multiple value at a time.
c>It is evaluated for each row of a table or view.
d>If no ELSE expression is present and every WHEN condition is false then the CASE expression returns a missing value.


7>

Which is true regarding distinct Clause?

a>It Removes the duplicate rows.
b>It is used to keep duplicate rows.
c>Distinct keyword should be mentioned with every variables present in the select Clause.
d>All

8>

What is the use of calculated Keyword in PROC SQL?

a>Is use to do manipulation on already existing variables.

b>Is used to do manipulation on newly created variables.

c>Is used to calculate number of numeric variables.

d>Is used to calculate number of character variables.

9>
What SQL statement is used to display the values from columns in a table?

a>Describe statement.
b>update statement
c>select statement
d>create table statement.

10>Which clause is used to subset rows in the Query?

a>Where clause
b>case Clause
c>Update clause
d>modify clause.

Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com

For training related info kindly mail us at info@sankhyana.com
Sankhyana Consultancy Services
www.sankhyana.com