How would you find out the total number of row in a table?

COBOL SQL Interview Questions

(Continued from previous question...)

How would you find out the total number of row in a table?

Use SELECT COUNT(*) ....

(Continued on next question...)

Other Interview Questions

• What RDMS objects are required before you can create a table ?
• What is a cursor? Why should it be used ?
• Which RDMS objects can you change with the SQL ALTER statements?
• What does the term "grant privileges" mean?
• What is referential integrity?
• What are aggregate functions?
• Compare a subselect to a join?
• Describe a primary key?
• When can an insert of a new primary key value threaten referntial integrity?
• Explain an outer join ?
• More...