Database Design [State Exam | 75 questions]

Specifies a range to test

None of the given

Specifies that a column is a primary key

Specifies which tables we are selecting from

MIN, MAX, AVG, COUNT, SUM

SUM, AVG, MULT, DIV, MIN

SUM, AVG, MIN, MAX, MULT

SUM, AVG, MIN, MAX, NAME

HAVING

WHERE

SELECT

FIND

The sum of values in a column

Average in the values in a group.

Maximum value from a column.

Selection condition

List of columns that will be selected or the * symbol

None of the given

Name of the table we are selecting from

Specifies the tables to retrieve rows from.

Specifies a search condition

None of the given

Specifies the columns we are retrieving

UPPER

MOST

TOP

MAX

List of columns to be selected or the * symbol

Name of the table we are selecting from

None of the given

Selection condition

COUNT ( )

NUMBER ( )

SUM ( )

COUNTOF ( )

The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column

The AS clause is used with the JOIN clause only

The AS clause defines a search condition

All of the mentioned

SELECT

OPEN

GET

EXTRACT

SELECT DIFFERENT

SELECT UNIQUE

SELECT DISTINCT

SELECT *

ORDER BY

FILTER

SORT BY

SORT

AND

BOTH

TRUE

WHERE

ORDER BY

GROUP BY

BY

JOIN

FIND STRING

HAS STRING

CONTAINS STRING

LIKE

SELECT, FROM, WHERE

FROM, WHERE, SELECT

WHERE, FROM, SELECT

SELECT, WHERE, FROM

parenthesis -- (...).

brackets -- [...].

CAPITAL LETTERS.

braces -- {...}.

report

form

file

table

all columns of the table are to be returned

all records meeting the full criteria are to be returned

all records with even partial criteria met are to be returned

None of the above is correct

Acts EXACTLY like a WHERE clause

Acts like a WHERE clause but is used for columns rather than groups

Acts like a WHERE clause but is used for groups rather than rows

Acts like a WHERE clause but is used for rows rather than columns

asterisk (*) ; percent sign (%)

question mark (?) ; asterisk (*)

percent sign (%) ; underscore ( _ )

underscore ( _ ) ; question mark (?)

The LIMIT constraint

The CHECK constraint

The VALUE constraint

None of the above is correct

NOT operator

IS NULL operator

EXISTS operator

All of the above

Feature has two 0's in it, at any position

Feature begins with two 0's

Feature has more than two 0's

Feature ends with two 0's

Select

None

Intersect

Difference

Compute the left outer join between the STUDENT and GROUP relations

Compute the full outer join between the STUDENT and GROUP relations

Compute the cartesian product between the STUDENT and GROUP relations

Compute the right outer join between the STUDENT and GROUP relations

None

When two or more tables share the same (or compatible) domains

When two or more tables share the same number of columns and when they share the same domains

When two or more tables share the same number of columns

Pi (Greek)

Sigma (Greek)

Lambda (Greek)

Omega (Greek)

None

Equijoins

Both

Cartesian

Intersect

Difference

Union

Divide

Pi (Greek)

Sigma (Greek)

Lambda (Greek)

Omega (Greek)

GROUP BY clause

HAVING clause

FROM clause

WHERE clause

DROP FROM CUSTOMER ...

UPDATE FROM CUSTOMER ...

REMOVE FROM CUSTOMER ...

DELETE FROM CUSTOMER WHERE ...

manipulate the structure of database applications

add and delete tables

add / modify / delete data in the database

specify the structure of a database

Atomicity

Durability

Isolation

All of the mentioned

COMMIT TRANSACTION

ROLLBACK TRANSACTION

COMMIT WORK

All of the mentioned

Data Control Language

Data Console Language

Data Console Level

Data Control Level

ц

у

w

2

Transaction control language

Transaction command language

Transaction connect language

None of the given

4

5

INNER JOIN

OUTER JOIN (LEFT, RIGHT, FULL JOIN)

CROSS JOIN

All of the mentioned

w

2

Entity

Degree

Tuple

Attribute

Attribute

Tuple

Degree

Entity

A relationship

A tuple

A unique attribute

Any attribute

Diamond (rhombus)

Rectangle

Ellipse

Dashed ellipse

Primary Key

Foreign Key

Secondary Key

None of these

?

3

No, removed from

At least one, removed from

At least one, added to

No, added to

can be eliminated

can be maximized

can be minimized, but not eliminated

are usually left unchanged

Can be eliminated

Can be maximized

Are usually unchanged

Can be minimized, but not eliminated

a primary key, a foreign key

a non-primary key, a foreign key

a non-primary key, the primary key

a primary key, a non-primary key

every non-primary key, the primary key

every alternate key, the primary key

every non-key, every key

every non-key, at least one key

3NF

2NF

1NF

4NF

3NF

2NF

1NF

4NF

Record

Column

Field

Relation

2NF

4NF

5NF

None of these

Tables

Relations

Rows

Attributes

Rectangle

Ellipse

Circle

Diamond box

Rectangle

Square

Ellipse

Triangle

Bill Gates

Charles Babbage

E. F. Codd

Herman Hollerith

Logical Design

Conceptual Design

Physical Design

All of these

Minimize the number of relationships

Minimize the number of tables

Minimize the number of entities

Minimize the number of redundancy

None of these

Always violates 2NF

Never violates 2NF

May violate 2NF

None of the above

w

2

None of these

Database Administrator System

Database Basic Management System

Database Management System

the process of adding primary key to a table

the process of arranging information stored in a database in a way, which redundancy and ambiguity

a special way of selecting data

none of these

Standard Query Language

Structured Query Language

Strict Query Language

Strong Query Language

Data Manipulation Language

Data Management Language

Data Definition Language

Data Development Language

SELECT

ALTER

CREATE

UPDATE

create a new table in the database

modify an existing table in a database

delete a table from the database

none of these

One-to-One

One-to-Many

Many-to-Many

None of these