Relational Implementation With SQL

Question 1

Schema Owner

Answer 1

Person who has authority and responsibility for granting access to tables columns and views in a database schema,

Question 2

Schema Definition

Answer 2

Description of database to the DBMS.

Question 3

Multiset

Answer 3

A set that may have duplicate entries.

Question 4

Simple Query

Answer 4

A query involving only one database table.

Question 5

SELECT clause

Answer 5

Identifies the columns desired in the query.

Question 6

FROM clause

Answer 6

Lists the existing tables referenced by the query.

Question 7

WHERE clause

Answer 7

Gives the condition for selecting rows from identified tables.

Question 8

Comparison Operators

Answer 8

= , <>,<,>,<=,>=

Question 9

Boolean Connectives

Answer 9

AND-OR-NOT

Question 10

Wild Card Characters

Answer 10

Special symbols that stand for unspecified strings of characters.

Question 11

Cartesian Product

Answer 11

Result of pairing each row in one table withe every row in another table.

Question 12

Alias

Answer 12

Alternate name given to a relation.

Question 13

Correlated Subquery

Answer 13

A subquery whose result depends on the row being examined by an outer query.

Question 14

EXISTS operator

Answer 14

Evaluates to true if resulting set is not empty.

Question 15

NOT EXISTS operator

Answer 15

Evaluates to ture if resulting set is empty.

Question 16

Built-in function

Answer 16

Statistical function that operates on a set of rows
SUM-AVG-COUNT-MAX-MIN

Question 17

Set function

Answer 17

Built-in function

Question 18

DISTINCT

Answer 18

Operator that eliminates duplicate rows.

Question 19

GROUP BY

Answer 19

Indicates that rows should be grouped on a common value of specified columns.

Question 20

HAVING

Answer 20

Places conditions on groups.

Question 21

Union Compatible

Answer 21

Two or more relations that have equivalent columns
as to number and domains.

Question 22

UNION

Answer 22

Operation that creates the set union of two relations.

Question 23

INTERSECT

Answer 23

The operation that creates the set intersection of two relations.

Question 24

EXCEPT

Answer 24

An operation that creates the set difference of two relations.

Question 25

Natural Join

Answer 25

Operation that connects relations when common columns have equal values.

Question 26

Join USING

Answer 26

Operation that connects relations when designated common columns have equal values.

Question 27

Join ON

Answer 27

Operation that connects relations when a condition holds.

Question 28

INSERT

Answer 28

Operation that causes rows to be added to be a relation.

Question 29

UPDATE

Answer 29

Operation that changes column values in rows.

Question 30

DELETE

Answer 30

Operation that removes rows from a relation

Question 31

Embedded SQL

Answer 31

A set of statements that allows SQL to be used with traditional programming languages.

Question 32

Host Langauge

Answer 32

Language of programs in which SQL statements can be embedded.

Question 33

Flag Statements

Answer 33

SQL statements embedded in an application program to signal the beginning or end of a set of SQL statements.

Question 34

Cursor

Answer 34

Embedded SQL facility where the result of an SQL query is stored for subsequent processing.

Question 35

OPEN cursor statement

Answer 35

Embedded SQL statement that causes the DBMS to process a cursors query and store its result in the cursor.

Question 36

FETCH statement

Answer 36

A statement that retrieves a single row from an opened cursor.