Database Practice Midterm

Front 1

Which of the following is used to create and maintain the physical database?
1. Data mining
2. Database Management System (DBMS)
3. E-R Model
4. Systems Development Life Cycle (SDLC)

Back 1

Database Management System (DBMS)

Front 2

Which of the following terms represents a collection of fields?

1) field

2) record

3) character

4) file

Back 2

record

Front 3

Which of the following terms refers to a group of related records?

1) database

2) character

3) field

4) file

Back 3

file

Front 4

The multi-step process used when creating a new system is referred to as ____.

1) the Systems Development Life Cycle

2) data mining

3) E-R Modeling

4) SQL

Back 4

the Systems Development Life Cycle

Front 5

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

1) systems recovery

2) systems analysis

3) systems design

4) systems implementation and review

Back 5

systems design

Front 6

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?

1) entity

2) row

3) attribute

4) file

Back 6

entity

Front 7

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?

1) one-to-many

2) many-to-many

3) one-to-all

4) one-to-one

Back 7

many-to-many

Front 8

Which of the following is used to determine the correct organization for data that is to be stored in a database?

1) E-R model

2) normalization process

3) systems implementation and review

4) systems analysis

Back 8

normalization process

Front 9

Which of the following may contain transitive dependencies, but not partial dependencies?

1) unnormalized data

2) first normal form (1NF)

3) second normal form (2NF)

4) third normal form (3NF)

Back 9

second normal form

Front 10

Which of the following may contain partial dependencies, but cannot contain repeating groups?

1) unnormalized data

2) first normal form (1NF)

3) second normal form (2NF)

4) third normal form (3NF)

Back 10

first normal form

Front 11

Which of the following can lead to partial dependencies?

1) composite primary key

2) common fields

3) foreign keys

4) normalization

Back 11

composite primary key

Front 12

Data in second normal form (2NF) may contain which of the following?

1) repeating groups

2) transitive dependencies

3) partial dependencies

4) both a and b

Back 12

transitive dependencies

Front 13

Which of the following usually correlates to a primary key in another table?

1) transitive dependency

2) composite primary key

3) foreign key

4) partial dependency

Back 13

foreign key

Front 14

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?

1) duplicate key

2) foreign key

3) composite primary key

4) distinct key

Back 14

foreign key

Front 15

What is added to a relational database to eliminate many-to-many relationships?

1) bridging table

2) transitive dependency

3) primary entity

4) secondary entity

Back 15

bridging table

Front 16

A field in the logical design of a database is represented by what in the physical database?

1) column

2) row

3) field

4) row

Back 16

column

Front 17

Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g?

1) SQL

2) SQL*Plus

3) ASCII

4) Script

Back 17

SQL*Plus

Front 18

Which of the following commands is used to issue a query?


1)
QUER


2)
FROM


3)
SELECT


4)
QUESTION

Back 18

SELECT

Front 19

What is used to indicate the end of an SQL statement?


1)
/


2)
:


3)
;


4)
*

Back 19

;

Front 20

To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause.


1)
SELECT


2)
FROM


3)
WHERE


4)
HAVING

Back 20

FROM

Front 21

Which of the following symbols represents all the columns contained in a table?


1)
/


2)
;


3)
*


4)
^

Back 21

*

Front 22

Which of the following commands can be used to view the structure of a table?


1)
CONCATENATION


2)
DESCRIBE


3)
SELECT


4)
None of the above

Back 22

DESCRIBE

Front 23

If the results of a SELECT statement include more than one column of data, the column names must be separated in the SELECT clause by which of the following symbols?


1)
,


2)
" "


3)
' '


4)
*

Back 23

,

Front 24

Which of the following keywords can be used to indicate that a column alias should be included in the results?


1)
AS


2)
FROM


3)
SELECT


4)
ALIAS

Back 24

AS

Front 25

Which of the following types of columns will automatically left-align the column heading when it is displayed?


1)
character


2)
numeric


3)
date


4)
both a and c

Back 25

both a and c

Front 26

Which of the following symbols can be used to combine data from different columns into one column of output?


1)
||


2)
^


3)
%


4)
*

Back 26

||

Front 27

Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement?


1)
SELECT * FROM pubid;


2)
SELECT * FROM name;


3)
SELECT * FROM contact;


4)
SELECT * FROM publisher;

Back 27

SELECT*FROM publisher

Front 28

Which of the following is a valid SQL statement?


1)
SELECT title, retail-cost FROM books;


2)
SELECT title, retail-cost "Profit"


3)
SELECT DISTINCT title, category
FROM books/


4)
All of the above

Back 28

SELECT title, retail-cost FROM books;

Front 29

Based upon the structure of the ORDERS table, which of the following is a valid SQL statement?


1)
SELECT customer # FROM orders;


2)
SELECT "order#", "customer#" FROM orders;


3)
SELECT order#, orderdate DateOrdered FROM orders;


4)
None of the above

Back 29

SELECT order#, orderdate DateOrdered FROM orders;

Front 30

Which of the following statements can be used to view the structure of the ORDERS table?

1)
SELECT * FROM orders;


2)
DESCRIBE ORDERS


3)
LIST ORDERS;


4)
None of the above

Back 30

DESCRIBE ORDERS

Front 31

Which of the following is a valid table name?

1) MYTABLE

2) DISTINCT

3) SELECT

4) CHAR

Back 31

MYTABLE

Front 32

A(n) ____ simply identifies the type of data that Oracle11g will be expected to store in a column.

1) data definition

2) data format

3) datatype

4) data record

Back 32

datatype

Front 33

Which of the following datatypes refers to fixed-length character data, where n represents the maximum length of the column?

1) CHAR(n)

2) VARCHAR(n)

3) VARCHAR2(n)

4) LONG

Back 33

CHAR(n)

Front 34

The column definition of NUMBER(7, 4) indicates a precision of ____.

1) 7

2) 4

3) 11

4) 3

Back 34

7

Front 35

If a column is defined as NUMBER(5,2), which of the following is true?

1) The column can store a total of 7 digits, with 5 on the left side of the decimal point, and 2 on the right.

2) The column can store a total of 7 digits, all of them on the right side of the decimal point.

3) The column can store a total of 5 digits, with 3 on the left side of the decimal point, and 2 on the right.

4) The column can store a total of 5 digits, all of them on the left side of the decimal point.

Back 35

The column can store a total of 5 digits, with 3 on the left side of the decimal point, and 2 on the right.

Front 36

Which command instructs Oracle11g to create a new table?

1) CREATE NEW TABLE

2) CREATE TABLE...FROM
3) CREATE TABLE

4) ALTER TABLE

Back 36

CREATE TABEL

Front 37

Which of the following is a valid SQL statement?

1) CREATE TABLE newname (colA NUMBER, colB DATE);

2) CREATE TABLE newname as SELECT * FROM books;

3) CREATE TABLE newname (colA, colB);

4) CREATE TABLE newname (colA DATE, colB VARCHAR2(3);

Back 37

CREATE TABLE newname (colA NUMBER, colB DATE);

Front 38

Which of the following SQL*Plus commands will display the structure of a table?

1) DISPLAY

2) DESC

3) DSC

4) VIEW

Back 38

DESC

Front 39

Which of the following keywords cannot be used to modify an existing table?

1) ALTER TABLE...ADD

2) ALTER TABLE...DROP COLUMN

3) ALTER TABLE...MODIFY
Correct Answer 4) ALTER TABLE...AS

Back 39

ALTER TABLE...AS

Front 40

Which of the following keywords can be used to change the size, datatype, and/or default value of an existing column?

1) ADD

2) MODIFY

3) CHANGE

4) RESET

Back 40

MODIFY

Front 41

Which of the following keywords is used to remove a database table in Oracle11g?

1) DROP TABLE

2) ALTER TABLE...DROP

3) DELETE TABLE

4) TRUNCATE TABLE

Back 41

DROP TABLE

Front 42

Which of the following is a valid statement?

1) Constraints are rules used to enforce business rules, practices, and policies.

2) Constraints prevent errors by not allowing data to be added to tables if the data violates specific rules.

3) Constraints ensure the accuracy and integrity of data.

4) all of the above

Back 42

all of the above

Front 43

In a "one-to-many" relationship, which constraint is usually added to the "many" table?

1) UNIQUE

2) PRIMARY KEY

3) FOREIGN KEY

4) NOT NULL

Back 43

FOREIGN KEY

Front 44

How can constraints be added to a table?

1) as part of the CREATE TABLE command

2) as part of the ALTER TABLE command

3) as part of the PRIMARY KEY command

4) both a and b

Back 44

both a and b

Front 45

Which of the following is not a constraint type in Oracle11g?

1) CHECK

2) UNIQUE

3) NOT NULL

4) REFERENCE

Back 45

REFERENCE

Front 46

When a constraint is created at the ____ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition.

1) table

2) column

3) database

4) row

Back 46

column

Front 47

Which of the following statements about creating constraints is incorrect?

1) If a constraint applies to more than one column, the constraint must be created at the table level.

2) Using the column level approach, the definition of the constraint is included as part of the column definition.

3) When you create constraints at the column level, the constraint being created applies to the column specified.

4) The NOT NULL constraint can be created at either the column level or the table level.

Back 47

The NOT NULL constraint can be created at either the column level or the table level.

Front 48

A PRIMARY KEY constraint can be added to an existing table by using the ____ clause of the ALTER TABLE command.

1) MODIFY
2) ADD

3) CONSTRAINT

4) none of the above

Back 48

ADD

Front 49

Which keywords identify a column that, if it contains a value, it must match data contained in another table?

1) FOREIGN KEY

2) PRIMARY KEY

3) CHECK

4) UNIQUE

Back 49

FOREIGN KEY

Front 50

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column. However, it can contain NULL values.

1) PRIMARY KEY
2) UNIQUE

3) CHECK

4) FOREIGN KEY

Back 50

UNIQUE