The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.

A. DROP
B. REMOVE
C. UPDATE
D. DELETE

Answer: D

Computer Science & Information Technology

You might also like to view...

The HTTP protocol is by definition stateless, meaning that it has no mechanism for "remembering" data from one interaction to the next. (a) Suggest a means by which you can preserve state between two HTTP calls. For example, you may send the user a page of books and prices matching a user's query, and you want to avoid having to look up the price of each book again once the user chooses one to

purchase. (b) Suggest a means by which you can preserve some notion of state between two web accesses many days apart. For example, the user may prefer prices quoted in euros instead of dollars, and you want to present prices in the preferred currency next time without asking the user. What will be an ideal response?

Computer Science & Information Technology

What is the problem (if any) with the following Select Case block which is intended to determine the price of a movie depending on the patron's age?

``` Private Sub btnDisplay_Click(...) Handles btnDisplay.Click Dim age as Integer, price As Decimal age = CInt(InputBox("Enter your age:")) Select Case age Case Is >= 65 'Senior citizen price = 4.50D Case Is >= 5 'Regular price price = 6.00D Case Is .= 0 'Child (no charge with parents) price = 0 Case Else txtBox.Text = "Entry error" End Select End Sub ``` (A) Everyone will get in free at the child rate. (B) The output will always be "Entry error." (C) The Case Is statements have bad syntax. (D) There is nothing wrong.

Computer Science & Information Technology