COSC 3318 Exam 1

referential integrity constraints

.......... is a special type if integrity constriant that relates two relations & maintains consistency across the relations

HAVING Clause

...........specifies a search condition for a group or an aggregate

Constraints

....is preferred method for enforcing data integrity

Domain integrity

One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as

Cardinality, Degree

The number of tuples in a relation is called it's.......... While the number of attributes in a relation is called it's......

Both A & B

The primary key must be

Database

Transaction is an action used to perform some manipulation on data stored in the .......

Atomicity, Consistency, Isolation, and Durability

What does ACID stand for?

Both of them

i)insert into <table_name> values<list of values> ii)insert into <table_name> (column list) values <list of values>

i-False, ii-True

i)select operator is NOT a unary operator ii)project operator chooses subset of attributes or columns of a relation

Structured query language

is a full form of SQL

Durability

What is D in ACID properties

Project

Which of the following is NOT binary operator in relational algebra?

Schema

defines the structure of a relation which consists of a fixed set of attribute- domain pairs.

Primary Key

the candidate key is that you choose to identify each row uniquely is called....

Candidate keys

the primary key is selected from the:

Alter

the statement in SQL which allows to change the schema of a table is

DISTINCT

to eliminate duplicate rows...... is used

drop r=removing a table delete from r = deletes the entry tuple

what is the difference between "DROP R" and "delete from R"?

ALTERNATE KEY

which of the following is NOT a type of SQL constraint

=<

which of the following is NOT comparison operator

Create, drop, alter, ALL OF THE ABOVE

which of the following is/are the DDL statements?