CMPSC 116 MIDTERM EXAM PART 1

Question 1

1.	Which system is designed to manage and store a large amount of data?

Accepted Answer

2

Question 2

2.	What is the feature that allows modifying a schema without affecting other levels of a database?

Accepted Answer

0

Question 3

3.	Which of the following languages is used to manipulate data within a database?

Accepted Answer

0

Question 4

4.	Which language allows users to define the structure of a database?

Accepted Answer

3

Question 5

5.	Which language is used for defining the structures of a database?

Accepted Answer

0

Question 6

6.	Which general-purpose language is used for querying, updating, and managing data in a relational database?

Accepted Answer

3

Question 7

7.	What term refers to the actual data stored in the database?

Accepted Answer

1

Question 8

8.	Which component is responsible for executing queries and processing in a DBMS?

Accepted Answer

0

Question 9

9.	Who is responsible for the administration and overall control of a database?

Accepted Answer

0

Question 10

10.	When modifying a column’s data type without affecting its current data, what is this an example of?

Accepted Answer

3

Question 11

11.	Which datatype is most appropriate for storing monetary values in a database?

Accepted Answer

0

Question 12

12.	Which of the following is not a DDL command?

Accepted Answer

2

Question 13

13.	Which of the following is not a DML command?

Accepted Answer

3

Question 14

14.	Changing the location of the database from one drive to another is an example of what?

Accepted Answer

0

Question 15

15.	Which data structure helps in speeding up data retrieval by pointing to specific values?

Accepted Answer

2

Question 16

16.	Which component executes the low-level instructions generated by the DML compiler?

Accepted Answer

0

Question 17

17.	What is a characteristic or property of an entity?

Accepted Answer

1

Question 18

18.	What is used to uniquely identify an entity within a database?

Accepted Answer

1

Question 19

19.	What is the process of defining the structures of a database at a high level called?

Accepted Answer

0

Question 20

20.	A relationship that involves three or more entities is known as what?

Accepted Answer

2

# 1

Multiple Choice

1. Which system is designed to manage and store a large amount of data?

# 2

Multiple Choice

2. What is the feature that allows modifying a schema without affecting other levels of a database?

# 3

Multiple Choice

3. Which of the following languages is used to manipulate data within a database?

# 4

Multiple Choice

4. Which language allows users to define the structure of a database?