CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: uses two or more columns together to identify a row?
A. Replication
B. Schema
C. Composite key
D. Second Normal Form
Correct Answer: C
Composite key uses two or more columns together to identify a row.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: allows records to participate in multiple parent-child style links forming a graph-like structure?
A. LIKE
B. View
C. Network model
D. Full backup
Correct Answer: C
Network model allows records to participate in multiple parent-child style links forming a graph-like structure.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: organizes records in a tree-like parent-child structure?
A. Hierarchical model
B. Nonrepeatable read
C. CREATE
D. Trigger
Correct Answer: A
Hierarchical model organizes records in a tree-like parent-child structure.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: organizes data primarily into tables composed of rows and columns?
A. Relational model
B. LEFT OUTER JOIN
C. CREATE
D. Candidate key
Correct Answer: A
Relational model organizes data primarily into tables composed of rows and columns.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: stores metadata about database objects, columns, constraints, and related definitions?
A. INSERT
B. Data dictionary
C. Network model
D. Durability
Correct Answer: B
Data dictionary stores metadata about database objects, columns, constraints, and related definitions.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is data that describes the structure, meaning, or properties of other data?
A. Metadata
B. Transaction
C. Graph database
D. Domain integrity
Correct Answer: A
Metadata is data that describes the structure, meaning, or properties of other data.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: refers to the data stored in a database at a particular moment?
A. Durability
B. Full backup
C. Instance
D. OLAP
Correct Answer: C
Instance refers to the data stored in a database at a particular moment.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: graphically represents entities, attributes, and relationships?
A. Nonclustered index
B. ER diagram
C. UPDATE
D. Data dictionary
Correct Answer: B
ER diagram graphically represents entities, attributes, and relationships.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: allows one parent row to relate to multiple child rows?
A. Entity integrity
B. Candidate key
C. WHERE
D. One-to-many relationship
Correct Answer: D
One-to-many relationship allows one parent row to relate to multiple child rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: allows at most one related row on each side for a given relationship?
A. One-to-one relationship
B. Query optimizer
C. Self join
D. Cardinality
Correct Answer: A
One-to-one relationship allows at most one related row on each side for a given relationship.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: describes how many instances of one entity can be associated with instances of another?
A. CROSS JOIN
B. Cardinality
C. Nonclustered index
D. Consistency
Correct Answer: B
Cardinality describes how many instances of one entity can be associated with instances of another.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A database component that chooses an efficient way to execute a query is the:
A. Query optimizer
B. Data entry form
C. Report footer
D. Backup device
Correct Answer: A
The query optimizer evaluates possible execution plans and selects an efficient one.
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.