Database Design [State Exam | 119 questions including MID/ENDterms 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

Modification, insertion, deletion

Random answer (do not click on this button)

Full, partial, transitive

Random answer (do not click for the God's sake)

Transaction control language

Transaction command language

Transaction connect language

None of the given

Unqiue values

Random answer (do not click here for Nazarbayev's sake)

INNER JOIN

OUTER JOIN (LEFT, RIGHT, FULL JOIN)

CROSS JOIN

All of the mentioned

CREATE USER

Random answer (do not click here)

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

The logical relationships of entities (or objects) in order to create a database

Random answer (do not click)

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

All of the above

Random answer (do not click)

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

Creates a stored procedure

Creates a new database table

Creates a database

None of these

Artist

Price

Songs

Albums

Student

Albums

Memory

DVD

Vehicles M-to-M Customers

Mechanics M-to-M Department

Customers M-to-M Mechanics

Garage M-to-M Vehicles

Each normal form contains a state of independent properties, unrelated to other normal forms

The lower the normal form number, the better the schema design is

A relation that is in second normal form is also in first normal form

Schemes that are in second normal form are considered the best

Physical Design

Logical Design

Conceptual Design

DBMS Selection

INSERT

CREATE

DROP

ALTER

SELECT

DELETE

UPDATE

CREATE TABLE

SELECT

UPDATE

DELETE

ALTER TABLE

ORDER BY

GROUP BY

ALIGN BY

SORT BY

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79;

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79;

SELECT * FROM weather WHERE humidity = 63 to 79;

SELECT * FROM weather WHERE humidity = 63 AND 79;

SELECT COLUMNS (*) FROM Persons;

SELECT COUNT( ) FROM Persons;

SELECT COLUMNS ( ) FROM Persons;

SELECT COUNT(*) FROM Persons;

SELECT * FROM Persons WHERE FirstName = ‘Peter’;

SELECT [all] FROM Persons WHERE FirstName = ‘Peter’;

SELECT [all] FROM Persons WHERE FirstName LIKE ‘Peter’;

SELECT * FROM Persons WHERE FirstName <> ‘Peter’;

SELECT * FROM Persons WHERE LastName = ‘Jackson’;

SELECT FirstName = ‘Peter’, LastName = ‘Jackson’ FROM Persons;

SELECT * FROM Persons WHERE FirstName <> ‘Peter’ AND LastName <> ‘Jackson’;

SELECT * FROM Persons WHERE FirstName = ‘Peter’ AND LastName = ‘Jackson’;

SELECT * FROM Persons ORDER BY FirstName DESC;

SELECT * FROM Persons SORT BY ‘FirstName’ DESC;

SELECT * FROM Persons ORDER FirstName DESC;

SELECT * FROM Persons SORT ‘FirstName’ DESC;

SELECT * .Persons

SELECT [all] FROM Persons

SELECT * FROM Persons

SELECT Persons

SELECT * FROM student WHERE name LIKE ‘%r%’;

SELECT * FROM student WHERE name LIKE ‘%r’;

SELECT * FROM student WHERE name LIKE ‘r%’;

SELECT * FROM student WHERE name LIKE ‘_r%’;

SELECT Username AND Password FROM Users

SELECT Username, Password WHERE Username = ‘user1’

SELECT Username, Password FROM Users

None of the given

DELETE SalesData

DELETE * FROM SalesData

DELETE FROM SalesData

DELETE ALL SalesData

SELECT * FROM SALES WHERE OrderID < 1;

SELECT * FROM Sales

DELETE FROM Sales

DELETE * FROM Sales

The result will be all rows from Table1 which have Column1 values greater than 10.

The result will be empty data set.

The SQL statement will generate an error.

None of the given

Select

Locate

Project

Join

EQUALS

WHAT

CONDITIONS

WHERE

Represent 0 value

Represent a missing or unknown value. NULL in SQL represents nothing.

Represent positive infinity

Represent negative infinity

SELECT NULL FROM Employee;

SELECT name FROM Employee WHEN salary = NULL;

SELECT name FROM Employee;

None of the given

Selects the total number of orders from the Sales table, if this number is greater than 5

Selects all customers from the Sales table

Selects all customers with number of orders from table Sales that have made more than 5 orders

None of the given

SELECT * FROM Customers ORDER ON customer_name;

SELECT * FROM Customers ORDER customer_name;

SELECT * FROM Customers ORDERED customer_name;

SELECT * FROM Customers ORDER BY customer_name;

DCL

DDL

DML

TCL

ELIMINATE

NODUPLICATE

DISTINCT

None of these

ALTER

MIN

BETWEEN

CREATE

SELECT

JOIN

DISTINCT

AVG

Equi-joins

Natural join

Outer join

All of the mentioned

UPDATE

INSERT

ALTER TABLE

DELETE

SELECT

CREATE TABLE

ALTER TABLE

GRANT

Use FROM to name the source table(s) and list the columns to be shown after SELECT

Use USING to name the source table(s) and list the columns to be shown after SELECT

Use SELECT to name the source table(s) and list the columns to be shown after SUSING

Use USING to name the source table(s) and list the columns to be shown after WHERE

ADD

CREATE

INSERT

MAKE

MS SQL Server

Oracle

PostgreSQL

All of these

NUMERIC

CHARACTER

DATE

All of the given

ADD

APPEND

INSERT

CREATE

Always satisfies 1NF

Always satisfies 3NF

May violate 1NF

None

Process model

Customer model

Event model

Data model