Q. In a client-server architecture, what is the role of the client?
-
A.
To manage the database and handle requests
-
B.
To send requests to the server and display results
-
C.
To store data locally
-
D.
To perform data backups
Solution
In a client-server architecture, the client sends requests to the server and displays results.
Correct Answer:
B
— To send requests to the server and display results
Learn More →
Q. In a client-server architecture, which layer is responsible for the user interface?
-
A.
Database layer
-
B.
Application layer
-
C.
Network layer
-
D.
Storage layer
Solution
In a client-server architecture, the application layer is responsible for the user interface.
Correct Answer:
B
— Application layer
Learn More →
Q. In a client-server database, what role does the server play?
-
A.
It processes user requests and manages data storage
-
B.
It only stores data without processing requests
-
C.
It acts as a client to other servers
-
D.
It is responsible for user interface design
Solution
In a client-server database, the server processes user requests and manages data storage.
Correct Answer:
A
— It processes user requests and manages data storage
Learn More →
Q. In a client-server database, which component is responsible for processing queries?
-
A.
Client
-
B.
Server
-
C.
Database
-
D.
Network
Solution
In a client-server database, the server is responsible for processing queries.
Correct Answer:
B
— Server
Learn More →
Q. What does an Entity-Relationship (ER) model primarily represent?
-
A.
The physical storage of data
-
B.
The relationships between data entities
-
C.
The SQL queries for data retrieval
-
D.
The performance metrics of a database
Solution
An Entity-Relationship (ER) model primarily represents the relationships between data entities.
Correct Answer:
B
— The relationships between data entities
Learn More →
Q. What is a transaction in the context of databases?
-
A.
A single operation on the database
-
B.
A sequence of operations treated as a single unit
-
C.
A backup of the database
-
D.
A query to retrieve data
Solution
A transaction in the context of databases is a sequence of operations treated as a single unit.
Correct Answer:
B
— A sequence of operations treated as a single unit
Learn More →
Q. What is concurrency control in a database system?
-
A.
Managing simultaneous operations without conflicting
-
B.
Ensuring data is backed up regularly
-
C.
Normalizing data to reduce redundancy
-
D.
Encrypting data for security
Solution
Concurrency control in a database system is managing simultaneous operations without conflicting.
Correct Answer:
A
— Managing simultaneous operations without conflicting
Learn More →
Q. What is normalization in the context of databases?
-
A.
The process of organizing data to reduce redundancy
-
B.
The process of backing up data
-
C.
The process of indexing data for faster retrieval
-
D.
The process of encrypting data
Solution
Normalization is the process of organizing data to reduce redundancy.
Correct Answer:
A
— The process of organizing data to reduce redundancy
Learn More →
Q. What is the primary purpose of a client-server database architecture?
-
A.
To store data in a single location
-
B.
To allow multiple clients to access a centralized database
-
C.
To eliminate the need for a database server
-
D.
To increase data redundancy
Solution
The primary purpose of a client-server database architecture is to allow multiple clients to access a centralized database.
Correct Answer:
B
— To allow multiple clients to access a centralized database
Learn More →
Q. What is the role of the client in a client-server database architecture?
-
A.
To store the database
-
B.
To send requests to the server
-
C.
To manage transactions
-
D.
To perform data backups
Solution
The role of the client in a client-server database architecture is to send requests to the server.
Correct Answer:
B
— To send requests to the server
Learn More →
Q. Which concurrency control method uses timestamps to manage transactions?
-
A.
Two-Phase Locking
-
B.
Optimistic Concurrency Control
-
C.
Pessimistic Concurrency Control
-
D.
Timestamp Ordering
Solution
Timestamp Ordering is a concurrency control method that uses timestamps to manage transactions.
Correct Answer:
D
— Timestamp Ordering
Learn More →
Q. Which of the following is NOT a benefit of using a client-server database?
-
A.
Centralized data management
-
B.
Improved data security
-
C.
Increased data redundancy
-
D.
Scalability
Solution
Increased data redundancy is NOT a benefit of using a client-server database; it typically aims to reduce redundancy.
Correct Answer:
C
— Increased data redundancy
Learn More →
Q. Which SQL command is used to retrieve data from a database?
-
A.
INSERT
-
B.
UPDATE
-
C.
SELECT
-
D.
DELETE
Solution
The SQL command used to retrieve data from a database is SELECT.
Correct Answer:
C
— SELECT
Learn More →
Showing 1 to 13 of 13 (1 Pages)
