I need to view the number of tables existing und

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

(Continued from previous question...)

I need to view the number of tables existing under one particular OWNER

Q: I need to view the number of tables existing under one particular OWNER. Is it possible ? If so, please give the SQL query for this ?

An:
The query SELECT * FROM SYSTABLES WHERE OWNER = should work.

(Continued on next question...)

Other Job Interview Questions

• What is a buffer pool ?
• What is an access path?
• EXPLAN has output with MATCHCOLS ...
• When does the SQL statement gets executed when you use cursor in the application programming ?
• What are some SQL aggregates and other built-in functions?
• What is ACQUIRE/RELEASE in BIND?
• What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
• What is IMAGECOPY
• Which transaction use a command thread?
• What is a cursor ?
• More...