CSS - PMS - CCE - PCS - Basic Computing
Database Basics
ETL stands for:
A. Extract, Transform, Load
B. Enter, Test, Link
C. Encrypt, Transfer, Lock
D. Edit, Type, List
Correct Answer: A
ETL extracts data from sources, transforms it into a useful format, and loads it into a destination.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A computer that provides database services to other computers is called a:
A. Database server
B. Print server only
C. Keyboard controller
D. Web page
Correct Answer: A
A database server runs database software and responds to requests from client applications.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
In client-server architecture, the client usually:
A. Requests services from the server
B. Stores every database backup automatically
C. Replaces the DBMS
D. Controls the internet
Correct Answer: A
The client provides the user interface and sends requests to the database server.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
The ability to change physical storage without changing the logical schema is called:
A. Physical data independence
B. Logical data dependence
C. Data redundancy
D. Query duplication
Correct Answer: A
Physical data independence allows storage structures to change without affecting the logical database design.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
The ability to change the logical schema without changing user views is called:
A. Logical data independence
B. Physical data dependence
C. Data inconsistency
D. Index duplication
Correct Answer: A
Logical data independence protects external user views from many logical schema changes.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
In the three-schema architecture, the level that describes user-specific views is the:
A. External level
B. Conceptual level
C. Internal level
D. Hardware level
Correct Answer: A
The external level contains different user views of the database.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
In the three-schema architecture, the overall logical database design is at the:
A. Conceptual level
B. External level
C. Internal level
D. Printer level
Correct Answer: A
The conceptual level describes the complete logical structure of the database.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
In the three-schema architecture, physical storage details are at the:
A. Internal level
B. External level
C. Conceptual level
D. Report level
Correct Answer: A
The internal level describes how data is physically stored and accessed.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A stored set of SQL statements that can be executed by name is called a:
A. Stored procedure
B. Foreign key
C. Data type
D. Report heading
Correct Answer: A
A stored procedure is a reusable program stored in the database and executed by name.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A database action that runs automatically when a specified event occurs is called a:
A. Trigger
B. Form
C. Backup
D. Index page
Correct Answer: A
A trigger automatically executes in response to events such as INSERT, UPDATE, or DELETE.