Logo 
Search:

sql Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » sqlRSS Feeds
SQL
Comments: 0

Name the process that separates data into distinct, unique sets

Normalization reduces the amount of repetition and complexity of the structure of the previous level.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Do the following statements return the same or different output.

SELECT * FROM CHECKS;
select * from checks;?

The only difference between the two statements is that one statement is in lowercase and the other uppercase. Case sensitivity is not normally a factor in the syntax of SQL. However, be aware of capita...
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Will below statements will work or not?

a.) Select *

The FROM clause is missing. The two mandatory components of a SELECT statement are the SELECT and FROM.


b.) Select * from checks

The semicolon, which identifies the end of a SQL statement, is missing.


c.) Select amount na...
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Which of the following SQL statements will work?

a) select *
from checks;

b) select * from checks;

c) select * from checks


All the above work.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Using the CHECKS table from earlier today, write a query to return just the check numbers and t

Using the CHECKS table from earlier today, write a query to return just the check numbers and the remarks.

SELECT CHECK#, REMARKS FROM CHECKS;
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Rewrite the query from exercise 1 so that the remarks will appear as the first column in query

Rewrite the query from exercise 1 so that the remarks will appear as the first column in your query results.

SELECT REMARKS, CHECK# FROM CHECKS;
Posted By:Shruti Sharma      Posted On: Dec 21

  1  2  3  4  5  6  7  8