How would you find out the total number of row i

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• Can one add columns to a table after it has been defined?
• What is the basic differnce between a join and a union?
• What is the syntax for a CREATE TABLE statement ?
• We have a table with a CHARACTER data type field
• Where in a table are added column located ?
• How is the SUBSTR keyword used in SQL?
• What are aggregate functions?
• Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project ?
• Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...
• What are the column name qualifiers?
• More...