Intermediate SQL

Question 1

a join operation that allows you to specify an explicit join clause.

Answer 1

Inner Join

Question 2

It preserves the unmatched rows from the first (left) table, joining them with a NULL row in the shape of the second (right) table.

Answer 2

Left Outer Join

Question 3

– It preserves the unmatched rows from the first (right) table, joining them with a NULL in the shape of the first (left) table.

Answer 3

Right Outer Join

Question 4

operation that produces the Cartesian product of two tables.

Answer 4

Cross Join

Question 5

a join operation that creates an implicit join clause for you based on the common columns in the two tables being join.

Answer 5

Natural Join

Question 6

Are virtual tables formed by a query

Answer 6

View

Question 7

A dictionary that you can use until you drop it.

Answer 7

View

Question 8

Not updatable.

Answer 8

View

Question 9

consists of a sequence of query and/or update statements.

Answer 9

Transaction

Question 10

ensure that changes made to the database by authorized users do not result in a loss of data consistency.

Answer 10

Integrity Constraints

Question 11

prohibits the insertion of a null value for the attribute.

Answer 11

Not Null

Question 12

defines a set of columns that uniquely identify rows in a table only if all the key values are not NULL.

Answer 12

Unique

Question 13

ensure that a value that appears in one relation (the referencing relation) for a give set of attributes also appears for a certain set of attributes in other relation (the referenced relation)

Answer 13

Referential integrity constraints

Question 14

can specify that if a delete or update action on the referenced relation violates the constraint, then, instead of rejecting the action, the system must take steps to change the tuple in the referencing relation to restore constraint.

Answer 14

Foreign key clause

Question 15

a calendar date containing a (four-digit) year, month and day of the month.

Answer 15

Date

Question 16

the time of day, in hours, minutes and seconds.

Answer 16

Time

Question 17

a combination of date and time.

Answer 17

Timestamp

Question 18

a collection of database objects.

Answer 18

Schema

Question 19

Owned by a database user and has the same name as that user.

Answer 19

Schema

Question 20

a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

Answer 20

Index

Question 21

used to confer authorization

Answer 21

Grant

Question 22

to revoke authorization

Answer 22

Revoke

Question 23

a set or group of privileges that can be granted to users or another role.

Answer 23

Role