CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A document database commonly stores records in:
A. JSON-like documents
B. Only spreadsheet formulas
C. Audio tracks
D. Printed pages
Correct Answer: A
Document databases store self-contained documents, often using JSON or similar formats.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
The term NoSQL is commonly interpreted as:
A. No Security Query Language
B. Not Only SQL
C. No Stored Query Logic
D. New Operating System Query Language
Correct Answer: B
NoSQL is commonly expanded as Not Only SQL and refers to non-relational or flexible database approaches.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A database hosted on remote cloud infrastructure is known as a:
A. Cloud database
B. Paper database
C. Local cache
D. Manual register
Correct Answer: A
A cloud database runs on cloud infrastructure and can often be accessed over the internet.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A database whose data is stored across multiple locations is called a:
A. Flat database
B. Distributed database
C. Personal database
D. Temporary database
Correct Answer: B
A distributed database stores data at more than one physical or network location.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A database stored and managed at one main location is called a:
A. Centralized database
B. Distributed database
C. Graph database
D. Mobile database
Correct Answer: A
A centralized database is primarily stored and controlled at a single location.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
An object-oriented database stores data as:
A. Objects
B. Only numbers
C. Only printed reports
D. Network cables
Correct Answer: A
Object-oriented databases store data in the form of objects that may contain both attributes and methods.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database model allows a record to have multiple parent records?
A. Hierarchical model
B. Network model
C. Flat-file model
D. Sequential model
Correct Answer: B
The network model supports more complex links, including records with multiple parents.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database model organizes data in a tree-like structure?
A. Relational model
B. Hierarchical model
C. Object model
D. Document model
Correct Answer: B
The hierarchical model arranges records in parent-child relationships like a tree.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A relational database stores data mainly in:
A. Tables
B. Audio files
C. Web browsers
D. Flowcharts
Correct Answer: A
Relational databases organize data into tables made of rows and columns.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Who introduced the relational database model?
A. Charles Babbage
B. E. F. Codd
C. Tim Berners-Lee
D. Bill Gates
Correct Answer: B
Edgar F. Codd proposed the relational model while working at IBM.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
The process of returning a database to a usable state after failure is called:
A. Recovery
B. Sorting
C. Filtering
D. Indexing
Correct Answer: A
Database recovery restores data and consistency after hardware, software, or user failure.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A copy of database data kept for protection against loss is called a:
A. Backup
B. Join
C. View
D. Constraint
Correct Answer: A
A backup is a separate copy of database data used to restore information after loss or damage.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
In applications such as Microsoft Access, a form is mainly used to:
A. Enter and view data through a user-friendly interface
B. Replace the operating system
C. Compress the database
D. Create network cables
Correct Answer: A
A form provides a convenient interface for users to enter, edit, and view records.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A formatted presentation of database information is usually called a:
A. Report
B. Key
C. Index
D. Constraint
Correct Answer: A
A report presents database information in a readable, printable, or summarized format.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A request used to retrieve or manipulate database data is called a:
A. Query
B. Driver
C. Pixel
D. Folder
Correct Answer: A
A query is an instruction or set of instructions used to retrieve or modify data in a database.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which is an important advantage of using a DBMS?
A. Increased uncontrolled duplication
B. Improved data sharing and security
C. Removal of all hardware requirements
D. Elimination of every possible error
Correct Answer: B
A DBMS improves controlled data sharing, security, integrity, backup, and concurrent access.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
When duplicated copies of the same data do not match, the problem is called:
A. Data consistency
B. Data inconsistency
C. Data security
D. Data validation
Correct Answer: B
Data inconsistency occurs when different copies of the same data contain conflicting values.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Unnecessary duplication of data is known as:
A. Normalization
B. Redundancy
C. Encryption
D. Validation
Correct Answer: B
Data redundancy means storing the same fact in multiple places without a valid need.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database component stores information about tables, fields, and constraints?
A. Data dictionary
B. Recycle bin
C. Clipboard
D. Print queue
Correct Answer: A
A data dictionary stores metadata describing database objects and their properties.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Data that describes other data is called:
A. Metadata
B. Redundant data
C. Binary data
D. Temporary data
Correct Answer: A
Metadata is data about data, such as column names, data types, table definitions, and constraints.