What RDMS objects are required before you can cr

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What RDMS objects are required before you can create a table ?

Before you can create a table, you need an existing database and tablespace.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between group by and order by ?
• When do you use a LINK statement ?
• Is DECLARE CURSOR executable?
• Where in a table are added column located ?
• What are the wildcard characters ?
• Explain the EXPLAIN statement?
• Describe the elements of the SELECT query syntax?
• What is meant by an index?
• In the WHERE clause what is BETWEEN and IN?
• What are correlated subqueries?
• More...