Craig Willey
Quiz by , created more than 1 year ago

College C192 Databases Quiz on C192 Advanced SQL, created by Craig Willey on 27/06/2020.

5
0
0
Craig Willey
Created by Craig Willey over 4 years ago
Close

C192 Advanced SQL

Question 1 of 14

1

You can join tables by using a condition in the ____ clause.

Select one of the following:

  • FROM

  • WHERE

  • SELECT

  • JOIN

Explanation

Question 2 of 14

1

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?

Select one of the following:

  • inner

  • outer

  • nested

  • product

Explanation

Question 3 of 14

1

In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.

Select one of the following:

  • normal

  • inner

  • full outer

  • combined

Explanation

Question 4 of 14

1

In a ____, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query).

Select one of the following:

  • left inner join

  • left outer join

  • right inner join

  • right outer join

Explanation

Question 5 of 14

1

In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left.

Select one of the following:

  • left inner join

  • left outer join

  • right outer join

  • right inner join

Explanation

Question 6 of 14

1

The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.

Select one of the following:

  • AC

  • SA

  • AS

  • IN

Explanation

Question 7 of 14

1

The main mechanism for providing access to a database is the ____ command.

Select one of the following:

  • PERMIT

  • ACCESS

  • GRANT

  • REVOKE

Explanation

Question 8 of 14

1

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

Select one of the following:

  • DROP

  • REMOVE

  • UPDATE

  • DELETE

Explanation

Question 9 of 14

1

The privilege ____ can be granted to retrieve data.

Select one of the following:

  • SELECT

  • UPDATE

  • RETRIEVE

  • READ

Explanation

Question 10 of 14

1

When you specify a foreign key, the table referenced by the foreign key is the ____.

Select one of the following:

  • super

  • sibling

  • parent

  • child

Explanation

Question 11 of 14

1

The privilege ____ can be granted to change data.

Select one of the following:

  • WRITE

  • UPDATE

  • ALTER

  • READ AND WRITE

Explanation

Question 12 of 14

1

The privilege ____ can be granted to change the table structure.

Select one of the following:

  • WRITE

  • UPDATE

  • ALTER

  • MODIFY

Explanation

Question 13 of 14

1

To create a stored procedure in Oracle, use the ____ command.

Select one of the following:

  • CREATE ROUTINE

  • CREATE SCRIPT

  • CREATE PROCEDURE

  • CREATE EXECUTABLE

Explanation

Question 14 of 14

1

A(n) ____ is a procedure that is executed automatically in response to an associated database operation.

Select one of the following:

  • cursor

  • trigger

  • waypoint

  • fetchpoint

Explanation