CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A system-generated identifier with no business meaning is called a:
A. Surrogate key
B. Natural key
C. Composite attribute
D. Report key
Correct Answer: A
A surrogate key is an artificial identifier such as an auto-incrementing number.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A field that refers to a key in another table is called a:
A. Foreign key
B. Candidate key
C. Primary file
D. Calculated field
Correct Answer: A
A foreign key creates a relationship by referencing a key, usually a primary key, in another table.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A key made of two or more fields is called a:
A. Composite key
B. Natural key
C. Foreign key
D. Temporary key
Correct Answer: A
A composite key uses multiple columns together to uniquely identify a record.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A candidate key that is not selected as the primary key is called an:
A. Alternate key
B. External key
C. Weak key
D. Sort key
Correct Answer: A
An alternate key is a candidate key that was not chosen to be the table's primary key.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Any field or combination of fields that uniquely identifies a record is called a:
A. Super key
B. Foreign key
C. Data type
D. Report
Correct Answer: A
A super key uniquely identifies a record but may contain unnecessary additional attributes.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A minimal field or combination of fields that can uniquely identify a record is called a:
A. Candidate key
B. Foreign key
C. Secondary file
D. Default value
Correct Answer: A
A candidate key is a minimal set of attributes capable of uniquely identifying a row.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which key uniquely identifies each record in a table?
A. Primary key
B. Foreign key
C. Sort key
D. Display key
Correct Answer: A
A primary key uniquely identifies every record in a table.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which statement best describes an RDBMS?
A. It manages related tables using keys and constraints
B. It is used only to edit images
C. It cannot store structured data
D. It has no support for queries
Correct Answer: A
An RDBMS manages data in related tables and enforces relationships through keys and constraints.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which of the following is an RDBMS?
A. MySQL
B. Microsoft Paint
C. Adobe Reader
D. Windows Calculator
Correct Answer: A
MySQL is a relational database management system. The other choices are not database systems.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A column-family database is designed to organize data by:
A. Groups of related columns
B. Paper files
C. Video frames
D. Operating system folders
Correct Answer: A
Column-family databases group related columns and are useful for large, distributed datasets.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A graph database represents data mainly using:
A. Nodes and edges
B. Pages and paragraphs
C. Rows and printers
D. Files and folders only
Correct Answer: A
Graph databases represent entities as nodes and relationships as edges.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A key-value database stores data as:
A. Pairs of keys and associated values
B. Rows without columns
C. Printed tables only
D. Images without names
Correct Answer: A
A key-value store associates each unique key with a corresponding value.
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.