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. Is it possible ? If so, please give the SQL query for this ?

The query SELECT * FROM SYSIMB.SYSTABLES WHERE CREATOR = 'owner id ' This displays the table names with that if you want only the number of tables give the following query. SELECT COUNT(*) FROM SYSIBM.SYSTABLES WHERE CREATOR = 'owner id' Make sure that you are in correct subsystem.

(Continued on next question...)

Other Job Interview Questions

• What is a Resource Control Table (RCT)? Describe its characteristics.
• What is the difference between static and dynamic SQL?
• What is meant by index cardinality?
• What is subselect? Is it different from a nested select ?
• What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ?
• When is the results table for the query in a DECLARE CURSOR statement created ?
• How can you quickly find out the number of rows updated after an update statement?
• What is lock contention?
• What does CURRENTDATA option in bind indicate ?
• What does the RUNSTATS Utility do?
• More...