Test: Database System Architectures - 1 - Software Development MCQ

A set of software tools used to manage databases

The physical arrangement of database files on disk

The overall structure that defines how a database system operates

The process of designing tables and relationships in a database

The database is directly accessible by the user interface layer

The business logic is executed on the client-side

The presentation logic is responsible for data validation

Each tier is independent and can be developed separately

Presentation tier

Application tier

Database tier

Integration tier

Improved data integrity and security

Reduced network traffic and latency

Simplified backup and recovery processes

Higher scalability and availability

Client-server architecture

Centralized architecture

Peer-to-peer architecture

Distributed architecture

All customers with an age greater than 30

All customers with an age less than or equal to 30

All customers with an age exactly equal to 30

All customers with an age between 30 and 40

A table named "employees" will be created with three columns

An error will occur because the PRIMARY KEY constraint is missing

An error will occur because the VARCHAR data type is not supported

An error will occur because the table name is already used in the database

Inserts a new row into the "products" table with specific values

Updates the row with id 1 in the "products" table

Deletes the row with id 1 from the "products" table

Retrieves the row with id 1 from the "products" table

The average price of all products in the "Electronics" category

The sum of the prices of all products in the "Electronics" category

The maximum price of all products in the "Electronics" category

The minimum price of all products in the "Electronics" category

The number of unique categories in the "products" table

The total number of products in the "products" table

The average count of products in each category

The maximum count of products in a single category

client_code = connect_to_server()
data = client_code.query_database("SELECT * FROM customers")
render_data(data)

data = query_database("SELECT * FROM customers")
render_data(data)

client_code = connect_to_server()
data = client_code.query_database("SELECT * FROM customers")

render_data("SELECT * FROM customers")

db = Database()
data = db.query("SELECT * FROM customers")
render_data(data)

data = query_database("SELECT * FROM customers")
render_data(data)

client_code = connect_to_server()
data = client_code.query_database("SELECT * FROM customers")

render_data("SELECT * FROM customers")

db = Database()
data = db.query("SELECT * FROM customers")
render_data(data)

client_code = connect_to_peer()
data = client_code.query_database("SELECT * FROM customers")
render_data(data)

client_code = connect_to_server()
data = client_code.query_database("SELECT * FROM customers")

render_data("SELECT * FROM customers")

db = Database()
data = db.query("SELECT * FROM customers")
render_data(data)

client_code = connect_to_peer()
data = client_code.query_database("SELECT * FROM customers")
render_data(data)

client_code = connect_to_server()
data = client_code.query_database("SELECT * FROM customers")

render_data("SELECT * FROM customers")

db = Database()
data = db.query("SELECT * FROM customers")
render_data(data)

client_code = connect_to_peer()
data = client_code.query_database("SELECT * FROM customers")
render_data(data)

client_code = connect_to_server()
data = client_code.query_database("SELECT * FROM customers")

render_data("SELECT * FROM customers")