Topic10 questions

8. Dcl & Database ObjectsQuestions & Answers

Practice 10 8. Dcl & Database Objects questions with detailed answers and explanations. Tap any question below to study the full solution.

An owner can give specific privileges on the owner's objects to others. State True or False.Which SQL statement grants a privilege to all the database users?CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which of the following statements are true with respect to the above index?Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?The owner has all the privileges on the object. State true or False.Joining a table to itself is called as ______.Equijoin is called as ______.The _______ join is based on all columns in the two tables that have the same data type.The _______ join produces the cross product of two tables._____ is used to retrieve records that do not meet the join condition

Practice more topics

PrimerPrep has independently reviewed practice questions and coding exercises — all free.

Browse all topics All subjects