DBI202 Practice Questions with 100% Correct Answers

DBI202 Practice Questions with 100% Correct
Answers
What data structure will be represented for the hierarchical data model?A. Array

structure

B. Table structure

C. Tree structure

D. Pointers structure

C

What data structure will be represented for the hierarchical data model?

A. Array structure

B. Table structure

C. Tree structure

D. Pointers structure

C

The ACID Properties of transactions refer to

A. Atomicity, consistency, isolation, database

B. Atomicity, consistency, isolation, durability

C. Atomicity, consistency, inconsistent, durability

D. Atomicity, concurrency, isolation, durability

B

In SQL, what is a view?

A. A virtual table based on the result of a SELECT query

B. A physical table containing aggregated data

,C. A temporary table used for transactions

D. A stored procedure with read-only access

A

In SQL, after grouping data using the GROUP BY clause, the __________ clause is used

to filter the groups based on specific conditions. It allows the use of aggregate functions

and selects only the groups that satisfy the given criteria.

A. Where

B. Having

C. Group by

D. With

B

How are many-to-many relationships typically represented in the relational model?

A. By adding attributes to one of the related tables

B. By creating a new table with foreign keys from both related tables

C. By denormalizing the database

D. By creating a new table for each related entity

B

QN=2 (6808) What is a database?

a. A database is a collection of information that is organized so that it can easily be

accessed, managed, and updated

b. A database is a collection of data files

c. A database is a collection of records

d. A database is a collection of tuples

,A

What is a database?

A. Organized collection of information that cannot be accessed, updated, and managed

B. Collection of data or information without organizing

C. Organized collection of data or information that can be accessed, updated, and

managed

D. Organized collection of data that cannot be updated

C

Which of the following describes an SQL cursor?

A. It allows you to traverse the result set of a query and process each row individually

B. is a precompiled collection of one or more SQL statements that can be executed as a

single unit

C. A field within a database

D. Cursors are not related to SQL

A

Problems such as redundancy that occur when we try to cram too much into a single

relation are called _____________

A. Normal Form

B. Anomalies

C. Decomposing Relations

D. None of the others

B

, What is an index?

A. An index is a database table attribute, which speeds-up data search within a table.

B. An index is the same as alias.

C. An index is a special way to join 2 or more tables.

D. An index is a database row attribute, which speeds-up data search within a table.

A

________ returns a relation instance containing all tuples that occur in both R and S.

A. Intersection

B. Set-difference

C. Union

D. Cross-product

A

Which of the following statements is correct when converting from the ERD model to

the relational model?

A. The order of the columns is not important

B. The order of both rows and columns is important

C. The order of the rows is important

D. The order of the columns is important

A

What does an RDBMS consist of?

A. Collection of Tables

B. Collection of Records

C. Collection of Keys

D. Collection of Fields