please fast i will rate you

QUESTION 1

In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.

relations

keys

indexes

logical structures

QUESTION 2

All changes in a table structure are made using the _____ command, followed by a keyword that produces the specific changes a user wants to make.

ALTER TABLE

UPDATE TABLE

COMMIT TABLE

ROLLBACK TABLE

QUESTION 3

The _____ statement combines rows from two queries and excludes duplicates.

MINUS

UNION ALL

INTERSECT

UNION

QUESTION 4

The syntax for a left outer join is _____.

SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition

SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition

SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition

SELECT column-list WHERE LEFT table1 = table 2

QUESTION 5

The special operator used to check whether an attribute value is within a range of values is _____.

NULL

BETWEEN

LIKE

IN

QUESTION 6

A(n) _____ join will select only the rows with matching values in the common attribute(s).

outer

natural

full

cross

QUESTION 7

Oracle recommends _____ for creating audit logs.

triggers

tables

stored functions

stored procedures

QUESTION 8

A (n) _________ trigger is assumed if a designer omits the FOR EACH ROW keywords.

instead of

before

row-level

statement-level

QUESTION 9

An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

data

existence

relationship

business

QUESTION 10

A relation is in third normal form (3NF) if and only if it is in 2NF and ________.

there are no non-key attributes determined by another non-key attribute

every attribute is a candidate key

every candidate key is a determinant

all non-key attributes are determined by the entire primary key