Logo 
Search:

sql Interview FAQs

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

From which two sources can you generate SQL scripts?

You can generate SQL scripts from database tables and the data dictionary.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What is the ed command?

The ed command takes you into a full screen text editor. ed is very similar to vi on a UNIX system and appears like a Windows Notepad file.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What does the spool off command do?

The spool off command closes an open spool file.
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

1  2  3  4  5  6  7  8