CSS - PMS - CCE - PCS - Basic Computing
Database Basics
If table A has 7 rows and table B has 7 rows, how many rows are produced by A CROSS JOIN B?
A. 14
B. 49
C. 7
D. 0
Correct Answer: B
A CROSS JOIN forms every pair, so 7 × 7 = 49 rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
If table A has 5 rows and table B has 9 rows, how many rows are produced by A CROSS JOIN B?
A. 4
B. 9
C. 45
D. 14
Correct Answer: C
A CROSS JOIN forms every pair, so 5 × 9 = 45 rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
If table A has 12 rows and table B has 2 rows, how many rows are produced by A CROSS JOIN B?
A. 24
B. 10
C. 14
D. 12
Correct Answer: A
A CROSS JOIN forms every pair, so 12 × 2 = 24 rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
If table A has 10 rows and table B has 4 rows, how many rows are produced by A CROSS JOIN B?
A. 40
B. 14
C. 6
D. 10
Correct Answer: A
A CROSS JOIN forms every pair, so 10 × 4 = 40 rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
If table A has 8 rows and table B has 3 rows, how many rows are produced by A CROSS JOIN B?
A. 5
B. 24
C. 11
D. 8
Correct Answer: B
A CROSS JOIN forms every pair, so 8 × 3 = 24 rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
If table A has 6 rows and table B has 7 rows, how many rows are produced by A CROSS JOIN B?
A. 13
B. 1
C. 7
D. 42
Correct Answer: D
A CROSS JOIN forms every pair, so 6 × 7 = 42 rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
If table A has 4 rows and table B has 5 rows, how many rows are produced by A CROSS JOIN B?
A. 5
B. 9
C. 1
D. 20
Correct Answer: D
A CROSS JOIN forms every pair, so 4 × 5 = 20 rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
If table A has 2 rows and table B has 3 rows, how many rows are produced by A CROSS JOIN B?
A. 1
B. 6
C. 5
D. 3
Correct Answer: B
A CROSS JOIN forms every pair, so 2 × 3 = 6 rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: extracts data, loads it into the destination, and performs transformations there?
A. Nonrepeatable read
B. Query optimizer
C. SAVEPOINT
D. ELT
Correct Answer: D
ELT extracts data, loads it into the destination, and performs transformations there.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: extracts data, transforms it, and loads it into a destination?
A. ETL
B. Isolation
C. Hierarchical model
D. Alternate key
Correct Answer: A
ETL extracts data, transforms it, and loads it into a destination.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is optimized for multidimensional analysis and complex analytical queries?
A. Data dictionary
B. DELETE
C. OLAP
D. Domain integrity
Correct Answer: C
OLAP is optimized for multidimensional analysis and complex analytical queries.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is optimized for frequent, short, day-to-day transactions?
A. OLTP
B. UPDATE
C. Phantom read
D. Nonrepeatable read
Correct Answer: A
OLTP is optimized for frequent, short, day-to-day transactions.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is a smaller analytics store focused on a department or subject area?
A. Denormalization
B. Entity
C. Deadlock
D. Data mart
Correct Answer: D
Data mart is a smaller analytics store focused on a department or subject area.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: maintains a copy primarily used to offload read workloads?
A. UPDATE
B. Read replica
C. Lock
D. Trigger
Correct Answer: B
Read replica maintains a copy primarily used to offload read workloads.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: horizontally partitions data across multiple servers or nodes?
A. Second Normal Form
B. First Normal Form
C. Sharding
D. Document database
Correct Answer: C
Sharding horizontally partitions data across multiple servers or nodes.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: maintains copies of data on multiple database servers or nodes?
A. Lock
B. Replication
C. Phantom read
D. GROUP BY
Correct Answer: B
Replication maintains copies of data on multiple database servers or nodes.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: restores a database to a chosen time using backups and logs?
A. Stored procedure
B. UPDATE
C. Clustered index
D. Point-in-time recovery
Correct Answer: D
Point-in-time recovery restores a database to a chosen time using backups and logs.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: records database changes so recovery and transactional durability can be supported?
A. UPDATE
B. NOT NULL constraint
C. Candidate key
D. Transaction log
Correct Answer: D
Transaction log records database changes so recovery and transactional durability can be supported.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: uses locks or similar mechanisms assuming conflicts may occur?
A. UNIQUE constraint
B. LEFT OUTER JOIN
C. Pessimistic concurrency control
D. Materialized view
Correct Answer: C
Pessimistic concurrency control uses locks or similar mechanisms assuming conflicts may occur.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: assumes conflicts are infrequent and checks for conflicts before commit?
A. DELETE
B. Optimistic concurrency control
C. Document database
D. Denormalization
Correct Answer: B
Optimistic concurrency control assumes conflicts are infrequent and checks for conflicts before commit.