All Topics
Topic10 questions
08 Dcl & Database ObjectsQuestions & Answers
Practice 10 08 Dcl & Database Objects questions with detailed answers and explanations. Tap any question below to study the full solution.
08 Dcl & Database Objects question list
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which of the following statements are true with respect to the above index?An owner can give specific privileges on the owner's objects to others. State True or False.The owner has all the privileges on the object. State true or False.Which SQL statement grants a privilege to all the database users?Equijoin is called as ______._____ is used to retrieve records that do not meet the join conditionJoining a table to itself 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.Practice more topics
PrimerPrep has independently reviewed practice questions and coding exercises — all free.