Logo 
Search:

Interview FAQs

Submit Interview FAQ
Home » Interview FAQsRSS Feeds
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

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

What makes SQL a nonprocedural language?

SQL determines what should be done, not how it should be done. The database must implement the SQL request. This feature is a big plus in cross-platform, cross-language development.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

How can you tell whether a database is truly relational?

Apply Dr. Codd's 12 (we know there are 13) rules.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What can you do with SQL?

SQL enables you to select, insert, modify, and delete the information in a database; perform system security functions and set user permissions on tables and databases; handle online transaction processing within an application; create stored procedu...
Posted By:Shruti Sharma      Posted On: Dec 21

Oracle
Comments: 0

COUNT(field_name) with example

returns the number of rows where field_value is NOT NULL.

SELECT COUNT(rating) FROM Customers;
Posted By:Shruti Sharma      Posted On: Dec 17

  11  12  13  14  15  16  17  18  19  20  21