Multiple choice urgent please:

QUESTION 1

1. A _____ is the primary key of one table that has been placed into another table to create a common attribute.

   		superkey
   		candidate key
   		foreign key
   		composite primary key

0.5 points

QUESTION 2

1. Which command of the followings is used to DELETE tuples from a database table?

   		DROP
   		REMOVE
   		DELETE
   		CLEAR

0.5 points

QUESTION 3

1. Creating a dynamic subset of rows and columns from one or more tables is called as_________.

   		CREATE VIEW
   		CREATE INDEX
   		CREATE TABLE
   		CREATE DYNAMIC SUBSET

0.5 points

QUESTION 4

1. The statement SELECT * FROM T1, T2 produces a(n) _____ join.

   		outer
   		equi-
   		cross
   		natural

0.5 points

QUESTION 5

1. The _____ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

   		LIST
   		UPDATE
   		RETRIEVE
   		SELECT

0.5 points

QUESTION 6

1. In subquery terminology, the first query in the SQL statement is known as the _____ query.

   		outer
   		base
   		inner
   		left

0.5 points

QUESTION 7

1. __________ are very useful for creating audit logs.

   		Triggers
   		Procedures
   		Packages
   		Functions

0.5 points

QUESTION 8

1. In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

   		cursor-style processing
   		Procedural Language SQL
   		embedded SQL
   		stored procedures

0.5 points

QUESTION 9

1. _____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

   		Dependence
   		Relationship
   		Cardinality
   		Connectivity

0.5 points

QUESTION 10

1. The defining characteristic of BCNF is that a table is in BCNF if ________.

   		all determinants are candidate keys
   		all columns are consistent
   		all rows are unique
   		the primary key is a candidate key