Gumawa ng quiz
# 1
pumili
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
Silid-aralan
Pagkasunod
CMPSC 116 MIDTERM EXAM PART 1
121
Payagan ang maling sagot
Itago ang sagot
public na pagsusulit
# 2
pumili
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
# 3
pumili
3. Which of the following languages is used to manipulate data within a database?
- a) DML
- b) DDL
- c) SQL
- d) DQL
# 4
pumili
4. Which language allows users to define the structure of a database?
- A. SQL
- B. DML
- C. DQL
- D. DDL
# 5
pumili
5. Which language is used for defining the structures of a database?
- a) DDL
- b) SQL
- c) DQL
- d) DML
# 6
pumili
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
# 7
pumili
7. What term refers to the actual data stored in the database?
- a) Data
- b) Instance
- c) Information
- d) Datatype
# 8
pumili
8. Which component is responsible for executing queries and processing in a DBMS?
- a) Database engine
- b) Storage manager
- c) DBMS
- d) Query processor
# 9
pumili
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
# 10
pumili
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
# 11
pumili
11. Which datatype is most appropriate for storing monetary values in a database?
- a) Decimal
- b) Float
- c) Double
- d) Integer
# 12
pumili
12. Which of the following is not a DDL command?
- a) Create
- b) Drop
- c) Update
- d) Alter
# 13
pumili
13. Which of the following is not a DML command?
- a) Insert
- b) Delete
- c) Update
- d) Alter
# 14
pumili
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
# 15
pumili
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
# 16
pumili
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
# 17
pumili
17. What is a characteristic or property of an entity?
- a) Key
- b) Attribute
- c) Derived
- d) Relationship
# 18
pumili
18. What is used to uniquely identify an entity within a database?
- a) ID
- b) Key
- c) Index
- d) Foreign Key
# 19
pumili
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
# 20
pumili
20. A relationship that involves three or more entities is known as what?
- a) Singular
- b) Binary
- c) Ternary
- d) One to One
Google Classroom ibahagi