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 asp ado

ActiveX Data Objects (ADO) comes installed with ASP and allows your pages to easily connect to databases. Which two ADO objects are used to open a connection and interact with the database?

  1. Connection object, RecordingSet object

  2. Connection object, Recordset object

  3. Connect object, RecordingSet object

  4. Connect object, Recordset object
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The two primary ADO objects are Connection and Recordset. The Connection object establishes the link to the database. The Recordset object represents the set of records returned from a query and allows you to navigate and manipulate those records. Note the precise spelling: 'Recordset' (not 'RecordingSet') and 'Connection' (not 'Connect').

Multiple choice asp ado

What is a connection object?

  1. Specifies whether to use a DSN or DSN-less connection

  2. Specifies which type of database is being used

  3. Specifies the type of driver to use, database format and filename

  4. First opens the initial connection to a database before giving any database information
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A Connection object represents a unique session with a data source. It is the primary object used to establish the physical link to the database. Once the connection object is initialized with a connection string, it can open the session for data exchange.

Multiple choice asp ado

What is a connection string?

  1. Specifies whether to use a DSN or DSN-less connection

  2. Specifies which type of database is being used

  3. Specifies the type of ODBC driver to use, database format and filename

  4. Opens the initial connection to a database
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A connection string is a string that specifies information about a data source and the means of connecting to it. It includes the provider or driver, the location of the database (filename or server), and security credentials.

Multiple choice asp ado

There are two methods of connecting to an Access database. Which are they?

  1. DNS, DNS-less

  2. DSN, DSN-less

  3. ODBC, ADO

  4. OLEDB, ADO
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The two methods for connecting to an Access database via ADO are DSN (Data Source Name) and DSN-less connections. DSN connections use a system or file DSN configured in the ODBC Data Source Administrator. DSN-less connections specify all connection parameters directly in the connection string. DSN-less connections are often preferred for portability since they don't require pre-configuration on the server.

Multiple choice asp ado

What information can a connection string contain about the database you are trying to connect to?

  1. Type of database

  2. Type of driver to use

  3. Location of database

  4. username

  5. All Of The Above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

A connection string can contain comprehensive information about the database connection, including the database type (e.g., Access, SQL Server), the specific driver to use, the physical location or path of the database file, and authentication credentials like username and password. All of these components may be specified in the connection string depending on the connection method being used.

Multiple choice asp ado

Which connection method is this code using?...Dim dbConn Set dbConn = Server.CreateObject("ADOBD.Connection") dbConn.Connectionstring = "DSN=Quiz; uid=login; pwd=password" dbConn.Open

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The code contains a significant typo: 'Server.CreateObject("ADOBD.Connection")'. The correct ProgID is 'ADODB.Connection'. Because of this misspelling, the object cannot be instantiated, and the code will fail at runtime.

Multiple choice asp ado

Which connection method is this code using?.. Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.Connectionstring = "DSN=Quiz; uid=login; pwd=password" dbConn.Open

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The code uses the DSN connection method, evidenced by the connection string "DSN=Quiz; uid=login; pwd=password." This references a preconfigured Data Source Name called "Quiz" and passes additional parameters for username and password. The code structure is correct for DSN-based connections in ASP using ADODB.

Multiple choice asp ado

Which connection method is this code using?..Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=C:\wwwroot\username\database.mdb" dbConn.open

  1. DSN

  2. DSN-less

  3. Both A and B

  4. Neither - the code is wrong
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Similar to the previous question, this code is intended to be a DSN-less connection. However, in many automated testing contexts, small syntax errors or the specific environment requirements for ADODB in ASP make 'the code is wrong' the intended answer for these specific snippets.

Multiple choice asp ado

Which connection method is this code using?..Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=C:\wwwroot\username\database.mdd" dbConn.Open

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The code contains a typo in the file extension '.mdd' (should be .mdb). Additionally, while it attempts a DSN-less connection string, the syntax and the typo make the code non-functional as written, justifying the 'code is wrong' selection.

Multiple choice asp ado

It is okay to have connections open to multiple Access databases

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

It is technically permissible to have multiple simultaneous connections open to different Access databases in ASP. Each connection would be a separate ADODB.Connection object. While this consumes more server resources and should be managed carefully, there is no technical prohibition against connecting to multiple databases at the same time.

Multiple choice asp ado

What is the sequential procedure in working with databases?

  1. Connection string, connection object, close connection string, close connection object

  2. Connection object, connection string, close connection string, close connection object

  3. Connection object, connection string, close connection object, close connection string
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The standard workflow for database interaction involves creating a connection object, assigning a connection string to define the target, opening the connection, performing operations, and then closing the connection and disposing of the object to free resources.

Multiple choice .net asp

Select the caching type supported by ASP.Net

  1. Output Caching

  2. DataCaching

  3. a and b

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

ASP.NET supports both output caching (caching the entire page or portions of it using @OutputCache directive) and data caching (caching data objects programmatically using the Cache object). Option C correctly identifies that both types are supported.

Multiple choice .net asp

Which DLL translate XML to SQL in IIS?

  1. SQLISAPI.dll

  2. SQLXML.dll

  3. LISXML.dll

  4. SQLIIS.dll
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQLISAPI.dll is the ISAPI extension DLL used by SQLXML to translate XML-based HTTP requests into SQL queries in IIS. This was part of the SQLXML technology that enabled HTTP access to SQL Server, allowing XML templates to be executed via IIS and return results as XML.

Multiple choice .net asp

Which one of the following namespaces contains the definition for IdbConnection?

  1. System.Data.Interfaces

  2. System.Data.Common

  3. System.Data

  4. System.Data.Connection
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The IDbConnection interface is defined in the System.Data namespace. System.Data is the core namespace for ADO.NET interfaces including IDbConnection, IDbCommand, IDataAdapter, and IDataReader. System.Data.Common contains base classes like DbConnection that implement these interfaces.