# 1Multiple Choice
1. Which system is designed to manage and store a large amount of data?
A. LOGICAL SCHEMA
B. RELATIONAL DATABASE
C. DATABASE SYSTEM
D. DATA STORAGE SYSTEM
CMPSC 116 MIDTERM EXAM PART 1
GI AN
Pagkakasunod-sunod
CMPSC 116 MIDTERM EXAM PART 1
123
CMPSC 116 MIDTERM EXAM PART 1
123
20 na tanong
Payagan ang maling sagot
Itago ang sagot
Pampublikong quiz
# 2Multiple Choice
2. What is the feature that allows modifying a schema without affecting other levels of a database?
a) Data independence
b) Integrity constraints
c) Atomicity
d) Data isolation
# 3Multiple Choice
3. Which of the following languages is used to manipulate data within a database?
a) DML
b) DDL
c) SQL
d) DQL
# 4Multiple Choice
4. Which language allows users to define the structure of a database?
A. SQL
B. DML
C. DQL
D. DDL
# 5Multiple Choice
5. Which language is used for defining the structures of a database?
a) DDL
b) SQL
c) DQL
d) DML
# 6Multiple Choice
6. Which general-purpose language is used for querying, updating, and managing data in a relational database?
a) DQL
b) DML
c) DDL
d) SQL
# 7Multiple Choice
7. What term refers to the actual data stored in the database?
a) Data
b) Instance
c) Information
d) Datatype
# 8Multiple Choice
8. Which component is responsible for executing queries and processing in a DBMS?
a) Database engine
b) Storage manager
c) DBMS
d) Query processor
# 9Multiple Choice
9. Who is responsible for the administration and overall control of a database?
a) Database administrator
b) Database manager
c) Database user
d) Database programmer
# 10Multiple Choice
10. When modifying a column’s data type without affecting its current data, what is this an example of?
a) Logical Independence
b) Data Independence
c) Data Isolation
d) Physical Independence
# 11Multiple Choice
11. Which datatype is most appropriate for storing monetary values in a database?
a) Decimal
b) Float
c) Double
d) Integer
# 12Multiple Choice
12. Which of the following is not a DDL command?
a) Create
b) Drop
c) Update
d) Alter
# 13Multiple Choice
13. Which of the following is not a DML command?
a) Insert
b) Delete
c) Update
d) Alter
# 14Multiple Choice
14. Changing the location of the database from one drive to another is an example of what?
a) Physical Independence
b) Logical Independence
c) Data Independence
d) Atomicity of Data
# 15Multiple Choice
15. Which data structure helps in speeding up data retrieval by pointing to specific values?
a) Data Files
b) Storage Manager
c) Index
d) Data Dictionary
# 16Multiple Choice
16. Which component executes the low-level instructions generated by the DML compiler?
a) Evaluation Engine
b) DML Interpreter
c) Index
d) Parsing and Translation
# 17Multiple Choice
17. What is a characteristic or property of an entity?
a) Key
b) Attribute
c) Derived
d) Relationship
# 18Multiple Choice
18. What is used to uniquely identify an entity within a database?
a) ID
b) Key
c) Index
d) Foreign Key
# 19Multiple Choice
19. What is the process of defining the structures of a database at a high level called?
a) Schema design
b) Logical schema
c) Physical design
d) Database design
# 20Multiple Choice
20. A relationship that involves three or more entities is known as what?
a) Singular
b) Binary
c) Ternary
d) One to One
I-share sa Google Classroom
Restricted ang access dahil nag-expire na ang plan. Copy at i-edit sa ibang map.