Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

SQL Server QUESTIONS : PART 1

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

all columns of the table are to be returned. 

all records meeting the full criteria are to be returned.

all records with even partial criteria met are to be returned.

None of the above is correct.

SHOW ANSWER

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

ONLY

UNIQUE

DISTINCT 

SINGLE

SHOW ANSWER

Which of the following do you need to consider when you make a table in SQL?

Data types 

 

Primary keys  

 

Default values  

 

SHOW ANSWER

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

LIKE only.

IN only.

NOT IN only.

Both IN and NOT IN. 

SHOW ANSWER

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); 

SHOW ANSWER

Which one of the following sorts rows in SQL?

SORT BY

ALIGN BY

ORDER BY 

GROUP BY

SHOW ANSWER

To sort the results of a query use:

SORT BY.

GROUP BY.

ORDER BY.

None of the above is correct.

SHOW ANSWER

SQL can be used to:

create database structures only.

query database data only.  

 

modify database data only.

SHOW ANSWER

The SQL statement that queries or reads data from a table is ________

SELECT 

READ

QUERY

None of the above is correct.

SHOW ANSWER

 

The SQL keyword BETWEEN is used:

for ranges.

to limit the columns displayed.

as a wildcard.

None of the above is correct.

SHOW ANSWER

A subquery in an SQL SELECT statement

can only be used with two tables.

can always be duplicated by a join.

has a distinct form that cannot be duplicated by a join.

cannot have its results sorted using ORDER BY.

SHOW ANSWER

SQL is

a programming language.

an operating system.

a data sublanguage.  

a DBMS.

SHOW ANSWER

Wrong statement about UPDATE keyword is

If WHERE clause in missing in statement the all records will be updated.

Only one record can be updated at a time using WHERE clause  

 Multiple records can be updated at a time using WHERE clause

 None is wrong statement

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in