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.
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
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
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, 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
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
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
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
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
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 smaller subject-focused part of a data warehouse is called a:
A. Data mart
B. Data type
C. Foreign key
D. Transaction log
Correct Answer: A
A data mart contains data for a particular department or business subject.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A large integrated collection of historical data for analysis is called a:
A. Data warehouse
B. Transaction form
C. Primary key
D. Temporary query
Correct Answer: A
A data warehouse combines historical data from multiple sources for reporting and analysis.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A system designed for complex analysis and reporting is called:
A. OLAP
B. OLTP
C. DML
D. TCL
Correct Answer: A
Online Analytical Processing supports multidimensional analysis, summaries, and decision-making.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A system designed for frequent day-to-day transactions is called:
A. OLTP
B. OLAP
C. ERD
D. DDL
Correct Answer: A
Online Transaction Processing systems handle routine operations such as orders, payments, and registrations.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Copying database data to another server for availability or performance is called:
A. Replication
B. Normalization
C. Deletion
D. Compilation
Correct Answer: A
Replication maintains copies of database data on multiple systems.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A record of who accessed or changed data is called an:
A. Audit trail
B. Foreign key
C. Data type
D. View alias
Correct Answer: A
An audit trail records important user and system activities for accountability and investigation.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which file records database changes and supports recovery?
A. Transaction log
B. Image file
C. Style sheet
D. Audio track
Correct Answer: A
A transaction log records changes and helps the DBMS recover committed or incomplete transactions.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Who is mainly responsible for database security, performance, backup, and availability?
A. Database Administrator
B. Graphic Designer
C. Network Cable Installer only
D. Data Entry Operator only
Correct Answer: A
A Database Administrator, or DBA, manages operation, security, performance, backup, and recovery.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Using a backup to return data to a previous state is called:
A. Restore
B. Normalize
C. Join
D. Grant
Correct Answer: A
A restore operation loads backed-up data into the database system.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A differential backup stores changes since:
A. The most recent full backup
B. The most recent incremental backup only
C. The last user login
D. The last SELECT query
Correct Answer: A
A differential backup accumulates all changes made since the last full backup.