Can ALl Users Have The Privilege To Use The SQL

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

(Continued from previous question...)

Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?

No the user should be granted privilege to use it.

(Continued on next question...)

Other Job Interview Questions

• What is a clustered index?
• Can DASD types assigned to storage groups be intermixed ?
• Describe what a storage group (STOGROUP) is?
• How is the SUBSTR keyword used in SQL?
• Explain an outer join ?
• How do you define a correlated name ?
• When do you use the IMAGECOPY ?
• What is the purpose of the WHENEVER statement?
• What is the best lock size that you could use when you create a tablespace?
• What are simple, segmented and partitioned table spaces?
• More...