Database Study Materials for Competitive Exams

Database

Advanced SQL Data and Database Administration Data Modeling with ER Model Data Models into Database Designs Data Warehousing Database Design Using Normalization Database Processing for BIS Database Redesign Distributed Databases ER Model and Business Rules Introduction to Database Introduction to SQL JDBC, Java Server Pages, and MySQL Logical Database Design Managing Databases with Oracle Managing Multiuser Databases Modeling Data in the Organization Object-Oriented Data Modeling Object-Oriented Database ODBC, OLE DB, ADO, and ASP Physical Database Design SQL for Database Construction SQL Server 2000 The Client-Server Database The Database Development Process The Database Environment The Internet Database Environment The Relational Model and Normalization XML and ADO.NET

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 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.

Correct Answer: B — SELECT

Showing 121 to 135 of 135 (5 Pages)