Q. Which of the following is an example of an attribute in an ER model?
A.Customer
B.Orders
C.OrderID
D.Many-to-Many
Solution
OrderID is an example of an attribute in an ER model.
Correct Answer: C — OrderID
Q. Which of the following is NOT a benefit of data warehousing?
A.Improved data quality
B.Enhanced data analysis capabilities
C.Increased transaction speed
D.Consolidated data from multiple sources
Solution
Data warehousing focuses on analytical processing rather than transaction speed, which is a characteristic of operational databases.
Correct Answer: C — Increased transaction speed
Q. Which of the following is NOT a benefit of normalization?
A.Reduced data redundancy
B.Improved data integrity
C.Faster query performance
D.Easier maintenance
Solution
Normalization can sometimes lead to slower query performance due to the need for more joins.
Correct Answer: C — Faster query performance
Q. Which of the following is NOT a characteristic of a transaction in a DBMS?
A.Atomicity
B.Consistency
C.Isolation
D.Redundancy
Solution
Redundancy is not a characteristic of a transaction; the main properties are Atomicity, Consistency, Isolation, and Durability (ACID).
Correct Answer: D — Redundancy
Q. Which of the following is NOT a component of DBMS architecture?
A.Database Engine
B.User Interface
C.Data Warehouse
D.Database Schema
Solution
A Data Warehouse is not a component of DBMS architecture; it is a separate system used for reporting and data analysis.
Correct Answer: C — Data Warehouse
Q. Which of the following is NOT a property of transactions in a DBMS?
A.Atomicity
B.Consistency
C.Isolation
D.Redundancy
Solution
Redundancy is not a property of transactions; the properties are known as ACID: Atomicity, Consistency, Isolation, and Durability.
Correct Answer: D — Redundancy
Q. Which of the following is NOT a property of transactions in the ACID model?
A.Atomicity
B.Consistency
C.Isolation
D.Durability
Solution
All options listed are properties of transactions in the ACID model; however, the question asks for the one that is NOT a property, which is incorrect.
Correct Answer: D — Durability
Q. Which of the following is NOT a type of data warehouse architecture?
A.Single-tier architecture
B.Two-tier architecture
C.Three-tier architecture
D.Multi-dimensional architecture
Solution
Multi-dimensional architecture is not a recognized type of data warehouse architecture; the common types are single-tier, two-tier, and three-tier.
Correct Answer: D — Multi-dimensional architecture
Q. Which of the following is NOT a type of distributed database architecture?
A.Homogeneous
B.Heterogeneous
C.Centralized
D.Federated
Solution
Centralized is not a type of distributed database architecture; it refers to a database that is managed from a single location.
Correct Answer: C — Centralized
Q. Which of the following is NOT a type of join in SQL?
A.INNER JOIN
B.OUTER JOIN
C.CROSS JOIN
D.LINK JOIN
Solution
LINK JOIN is not a recognized type of join in SQL; the common types are INNER JOIN, OUTER JOIN, and CROSS JOIN.
Correct Answer: D — LINK JOIN
Q. Which of the following is NOT a type of normalization?
A.First Normal Form
B.Second Normal Form
C.Third Normal Form
D.Fourth Normal Form
Solution
Fourth Normal Form is a valid type of normalization; however, the question is misleading as all options are types of normalization.
Correct Answer: D — Fourth Normal Form
Q. Which of the following is NOT a type of relationship in an ER model?
A.One-to-One
B.One-to-Many
C.Many-to-Many
D.Many-to-One
Solution
All listed options are types of relationships in an ER model; however, 'Many-to-One' is typically described as 'One-to-Many' from the other entity's perspective.
Correct Answer: D — Many-to-One
Q. Which of the following is NOT a typical use case for a data warehouse?
A.Business intelligence reporting
B.Data mining
C.Real-time transaction processing
D.Historical data analysis
Solution
Data warehouses are not typically used for real-time transaction processing, which is better suited for operational databases.
Correct Answer: C — Real-time transaction processing
Q. Which of the following is NOT a valid HTML tag?
A.<div>
B.<span>
C.<section>
D.<bodytag>
Solution
<bodytag> is not a valid HTML tag; the correct tag is <body>.
Correct Answer: D — <bodytag>
Q. Which of the following is NOT a valid IPv6 address format?
A.2001:0db8:85a3:0000:0000:8a2e:0370:7334
B.2001:db8::ff00:42:8329
C.192.168.1.1
D.::1
Solution
192.168.1.1 is an IPv4 address format, while the others are valid IPv6 address formats.
Correct Answer: C — 192.168.1.1
Q. Which of the following is NOT a valid IPv6 address format?
A.2001:0db8:85a3:0000:0000:8a2e:0370:7334
B.2001:db8::ff00:42:8329
C.192.168.1.1
D.::1
Solution
192.168.1.1 is an IPv4 address format, while the others are valid IPv6 address formats.
Correct Answer: C — 192.168.1.1
Q. Which of the following is NOT a valid IPv6 address format?
A.2001:0db8:85a3:0000:0000:8a2e:0370:7334
B.2001:db8::ff00:42:8329
C.192.168.1.1
D.::1
Solution
192.168.1.1 is an IPv4 address format, while the others are valid IPv6 address formats.
Correct Answer: C — 192.168.1.1
Q. Which protocol is used for secure communication over a computer network?
A.HTTP
B.FTP
C.HTTPS
D.SMTP
Solution
HTTPS (HyperText Transfer Protocol Secure) is used for secure communication over a computer network.
Correct Answer: C — HTTPS
Q. Which protocol is used for secure communication over the internet?
A.HTTP
B.FTP
C.HTTPS
D.SMTP
Solution
HTTPS (HyperText Transfer Protocol Secure) is used for secure communication over a computer network.
Correct Answer: C — HTTPS
Q. Which SQL clause is used to filter records in a query?
A.ORDER BY
B.GROUP BY
C.WHERE
D.HAVING
Solution
The 'WHERE' clause is used to filter records in a SQL query based on specified conditions.
Correct Answer: C — WHERE
Q. Which SQL command is used to remove a table from a database?
A.DELETE
B.DROP
C.REMOVE
D.TRUNCATE
Solution
The SQL command used to remove a table from a database is DROP.
Correct Answer: B — DROP
Q. Which SQL statement is used to create an index?
A.CREATE INDEX
B.ADD INDEX
C.NEW INDEX
D.INDEX CREATE
Solution
The SQL statement used to create an index is 'CREATE INDEX'.
Correct Answer: A — CREATE INDEX
Q. Which SQL statement is used to remove a table from a database?
A.DELETE TABLE
B.DROP TABLE
C.REMOVE TABLE
D.ALTER TABLE
Solution
The correct SQL statement to remove a table from a database is 'DROP TABLE'.
Correct Answer: B — DROP TABLE
Q. Which SQL statement is used to retrieve data from a database?
A.GET
B.SELECT
C.FETCH
D.RETRIEVE
Solution
The SELECT statement is used to retrieve data from a database in SQL.
