Computer Knowledge

Database Management Systems

5,543 Questions

Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.

E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database

Database Management Systems Questions

Multiple choice java

A course enrolment application needs to define a JDBC resource reference for a DB2 database in the deployment descriptor. Assuming that the name of the resource reference is "enrolment", what is the appropriate JNDI declaration?

  1. java:comp/env/jdbc/db2/enrolment

  2. java:comp/env/jdbc/enrolment

  3. java:comp/env/enrolment

  4. java:jdbc/env/db2/enrolment
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

JDBC resource references follow the java:comp/env/jdbc/ convention in JNDI namespace. The resource reference name "enrolment" is appended to this standard prefix, giving java:comp/env/jdbc/enrolment. Database-specific names (like db2) are not part of the JNDI name.

Multiple choice java

The EJB Query Language is used

  1. to enhance the SQL96 standard with additional options for complex relationships

  2. instead of the findByPrimaryKey() method, to define alternative selection criteria

  3. to specify a concrete implementation for the find and select methods of CMP entity beans

  4. for accessing User Defined data types and Stored Procedures in the database.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

EJB-QL (EJB Query Language) is used to define the selection criteria for find and select methods in CMP entity beans. It provides an abstraction over SQL, allowing the container to generate efficient database queries. It's not an enhancement of SQL96 nor a replacement for findByPrimaryKey.

Multiple choice java

How many JDBC driver types does Sun define?

  1. One

  2. Two

  3. Three

  4. Four
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Sun defines four JDBC driver types: Type 1 (JDBC-ODBC bridge), Type 2 (native API/partly Java), Type 3 (pure Java/net protocol), and Type 4 (pure Java/direct connectivity). This categorization has been part of JDBC specification since early versions.

Multiple choice java

Where is metadata stored in MySQL?

  1. In the MySQL databasemetadata

  2. In the MySQL databasemetasql

  3. In the MySQL databasemysql

  4. None of the above is correct.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

MySQL stores system metadata (table definitions, user privileges, etc.) in a specific system database named 'mysql'. This database contains tables like 'user', 'db', and 'tables_priv'. Options A and B do not exist as standard system databases.

Multiple choice java

Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?

  1. Type 1 only

  2. Type 2 only

  3. Both Type 3 and Type 4

  4. All of Type 1, Type 2, Type 3 and Type 4
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In a scenario where the Web server and DBMS are on the same machine, all driver types are technically usable. Type 1 (Bridge) and Type 2 (Native-API) work via local client libraries. Type 3 (Network-Protocol) and Type 4 (Native-Protocol) work over network sockets, which function fine on localhost.

Multiple choice .net

Where is a single element of data stored?

  1. Field

  2. Record

  3. Table

  4. Both a and b.

  5. All of the above.

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In database terminology, a field is the smallest unit of data storage representing a single data element. A record is a collection of related fields, and a table contains related records.

Multiple choice .net

Where is a collection of related data elements stored?

  1. Field

  2. Record

  3. Table

  4. Both a and b.

  5. All of the above.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A record in a database contains a collection of related data elements stored as fields together. It represents a complete entry like a single customer profile with all their attributes.

Multiple choice .net

Which is not a program that can create a database?

  1. Access

  2. MySQL

  3. Oracle

  4. SQL Server

  5. All of the above can be used to create a database.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Microsoft Access is a desktop database system, MySQL is an open-source RDBMS, Oracle is an enterprise database system, and SQL Server is Microsoft's enterprise database platform. All four are fully capable of creating and managing databases.

Multiple choice .net

What does the term DBMS stand for?

  1. Database Management Schema

  2. Database Management Style

  3. Database Management System

  4. Database Manipulation Schema

  5. Database Manipulation Style
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DBMS is the standard acronym for Database Management System, which is software that manages databases. It provides an interface for users to create, maintain, and access databases efficiently.

Multiple choice .net

The normalization process is:

  1. used to remove redundant data.

  2. used to make the storage of data more efficient.

  3. not recommended for most databases.

  4. Both a and b.

  5. All of the above.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Database normalization eliminates redundant data by organizing it logically, which makes storage more efficient. It breaks large tables into smaller, related ones to reduce duplication and improve data integrity.

Multiple choice .net

Which database is the ADO.NET SqlConnection object designed for?

  1. Access

  2. Microsoft SQL Server

  3. MySQL

  4. Oracle

  5. None of the above.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To answer this question, the user needs to have knowledge about ADO.NET and SqlConnection object.

The SqlConnection object in ADO.NET is designed for connecting and interacting with Microsoft SQL Server databases.

Therefore, the correct answer is:

The Answer is: B. Microsoft SQL Server

Multiple choice .net

Which property of the database must the connection object contain?

  1. Location

  2. Type

  3. Query

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A connection object needs to know where the database is located (server address or file path), what type of database it is (SQL Server, Oracle, etc.), and may need query information to establish proper communication. All three properties are essential components for creating a valid database connection.

Multiple choice .net

What information is specified in the Connection tab of the DataLink window?

  1. Database login

  2. Database name

  3. Database type

  4. Both a and b.

  5. All of the above.

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Connection tab in database configuration dialogs typically requires authentication information (login credentials) and the database name to establish the connection. Database type is usually specified in a separate provider or driver selection step.

Multiple choice .net

The first step of configuring a DataAdapter is to select:

  1. an adapter object.

  2. a connection object.

  3. a database object.

  4. a dataset object.

  5. None of the above.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To solve this question, the user needs to have knowledge about the concepts related to configuring a DataAdapter in data access programming.

The first step of configuring a DataAdapter is to select a connection object.

Now, let's go through each option and explain why it is right or wrong:

A. an adapter object: This option is incorrect because selecting an adapter object is not the first step in configuring a DataAdapter. The adapter object is created and configured after selecting a connection object.

B. a connection object: This option is correct. The first step in configuring a DataAdapter is to select a connection object. The connection object represents the connection to the database and is used to establish a connection with the database.

C. a database object: This option is incorrect because selecting a database object is not the first step in configuring a DataAdapter. The database object is typically used after establishing a connection to the database.

D. a dataset object: This option is incorrect because selecting a dataset object is not the first step in configuring a DataAdapter. The dataset object is used to hold the retrieved data from the database and is typically configured after selecting a connection object.

E. None of the above: This option is incorrect because the correct answer is option B - a connection object.

Therefore, the correct answer is: B

Multiple choice .net

Which DataAdapter Query Type can be used with the Access database?

  1. Use SQL statements.

  2. Create new stored procedure.

  3. Use existing stored procedure.

  4. Both a and b.

  5. All of the above.

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To answer this question, the user needs to have knowledge of the different query types that can be used with a DataAdapter when working with an Access database.

Option A is correct. The "Use SQL statements" query type can be used with a DataAdapter when working with an Access database. This query type allows you to write SQL statements to retrieve, update, and delete data from the database.

Option B is incorrect. Creating new stored procedures is not a query type that can be used with a DataAdapter when working with an Access database. Stored procedures are typically used with SQL Server databases.

Option C is incorrect. Using existing stored procedures is also not a query type that can be used with a DataAdapter when working with an Access database. Again, stored procedures are typically used with SQL Server databases.

Option D is incorrect. Although option A is correct, option B is not. Therefore, option D cannot be correct because it includes option B.

Option E is incorrect. Although option A is correct, options B and C are not. Therefore, option E cannot be correct because it includes options B and C.

So, the correct answer is:

The Answer is: A. Use SQL statements.