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 technology packaged enterprise solutions

Which of the following is recommended by SAP to be used for copying very large R/3 System clients?

  1. Database export and import.

  2. Generic operating system utilities.

  3. The R/3 Client Copy transactions.

  4. R3SETUP
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SAP recommends using the R/3 Client Copy transactions (like SCCL, SCC3) for copying very large clients because these transactions are optimized for large data volumes, handle data consistency properly, and maintain referential integrity. While database export/import or generic OS utilities might work for smaller clients, they can cause issues with large clients. R3SETUP is for system installation, not client copy.

Multiple choice technology packaged enterprise solutions

When creating a logon group for Logon Load Balancing, which of the following CANNOT be specified?

  1. Maximum allowable response time.

  2. Maximum number of users who may be logged on to the instance.

  3. Maximum number of sessions per user.

  4. Name of the instance defined for the logon group.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When configuring logon groups in SAP (transaction SMLG), you can define thresholds for response time and user counts to balance the load. However, the maximum number of sessions per user is a profile parameter (rdisp/max_alt_modes) and cannot be specified within the logon group definition.

Multiple choice technology packaged enterprise solutions

Given an R/3 Central Instance with all services installed on Instance ID01, and having an SAP ID of C11, what is the name of the directory where the work process trace files are written (for Windows NT replace the "/" with "\")?

  1. /usr/sap/C11/DVEBMGS01/data

  2. /usr/sap/C11/DVEBMGS01/log

  3. /usr/sap/C11/DVEBMGS01/work

  4. The trace files are written in internal database tables.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SAP R/3 architecture, work process trace files are written to the 'work' directory under the instance directory. The path /usr/sap/C11/DVEBMGS01/work is correct where C11 is the SAP system ID and DVEBMGS01 is the instance name. Trace and log files are stored here, not in data or log directories.

Multiple choice technology databases

Choose the database objects

  1. TABLE

  2. VARCHAR2

  3. SEQUENCE

  4. INDEX
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

TABLE, SEQUENCE, and INDEX are database objects in Oracle and other RDBMS. TABLE stores data, SEQUENCE generates unique numbers, and INDEX improves query performance. VARCHAR2 is a data type used to define columns, not a database object itself.

Multiple choice technology programming languages

You develop a Windows-Based application that accesses a Microsoft SQL Server database named ABC. Users must supply a user name and password when they start the application. This information is then used to dynamically build a connection string. When you test the application, you discover that it is not using the SqlClient connection pooling feature. You must reduce the time needed to retrieve information. How should you modify the connection string?

  1. to use the Windows user logon when connection to the TestKing1 database.

  2. to use the SQL Server used login when connection to the TestKing1 database.

  3. to use the same application logon ID and password for every connection to the TestKing1 database.

  4. to use the guest login ID and password for every connection to the TestKing1 database.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Connection pooling in ADO.NET relies on exact string matching. If every user has a unique connection string (different credentials), a new pool is created for each, defeating the purpose. Using a single service account enables pool reuse.

Multiple choice technology programming languages

You develop a Windows-based application ABCApp by using Visual Studio .NET. ABCApp uses a SqlConnection object for database access. You typically run ABCApp on a computer that has limited RAM and hard disk space. After the code finishes using the SqlConnection object, you must ensure that the connection is closed and that any resources consumed by the object are released immediately. What should you do?

  1. Call the Finalize method of the SqlConnection object.

  2. Call the Dispose method of the SqlConnection object.

  3. Set the SqlConnection object equal to Nothing.

  4. Set the SqlConnection object equal to “”.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Dispose method is the correct approach to immediately release resources and close the connection. Dispose is deterministic - it frees resources right when called. Finalize is non-deterministic (called by garbage collector eventually), setting to Nothing just removes the reference without closing the connection, and setting to "" is invalid for objects.

Multiple choice technology programming languages

You plan to develop a customer information application CustomABC that uses a Microsoft SQL Server database. CustomABC will be used frequently by a large number of users. Your application code must obtain the fastest possible performance when accessing the database and retrieving large amounts of data. You must accomplish this goal with the minimum amount of code. How should you design CustomABC?

  1. Use classes in the System.Data.OleDb namespace.

  2. Use classes in the System.Data.SqlClient namespace.

  3. Use remoting to connect to the SQL Server computer.

  4. Use interoperability to include legacy COM-based data access components.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The System.Data.SqlClient namespace is specifically optimized for Microsoft SQL Server. It uses the TDS (Tabular Data Stream) protocol directly, providing better performance than the generic OleDb provider.

Multiple choice technology programming languages

Which three are DATETIME data types that can be used when specifying column definitions? ( Choose Three)

  1. TIMESTAMP

  2. INTERVAL MONTH TO DAY

  3. INTERVAL DAY TO SECOND

  4. INTERVAL YEAR TO MONTH

  5. TIMESTAMP WITH DATABASE TIMEZONE
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

TIMESTAMP, INTERVAL DAY TO SECOND, and INTERVAL YEAR TO MONTH are valid Oracle datetime/interval types. 'INTERVAL MONTH TO DAY' is not a valid Oracle type, and 'TIMESTAMP WITH DATABASE TIMEZONE' is also not a standard type name.

Multiple choice technology web technology

5.What is a lookup file?

  1. File containing intermediate data while processing

  2. File containing static dataset which is keyed

  3. File containing daily transaction data

  4. Partitioned file which is non-keyed
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A lookup file contains a static reference dataset that is keyed, allowing you to join with transactional data during processing to enrich or validate records. Common examples include state code mappings, currency conversion tables, or product catalogs that don't change frequently. Unlike intermediate files, lookup files are pre-loaded before processing begins.

Multiple choice technology web technology

What is the function to start the session?

  1. session_start()

  2. session_init()

  3. session_boot()

  4. None of the Above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

session_start() is the correct PHP function to initialize a session - it must be called before any output is sent to the browser. The other options don't exist - session_init() and session_boot() are not valid PHP functions. Once started, session data becomes available through the $_SESSION superglobal.

Multiple choice technology databases

You have a mission critical database named MCDB1 that you want to configure for automatic failover. You have decided to utilize database mirroring. Which database mirroring operating mode should you use?

  1. High safety mode

  2. Asynchronously

  3. High performance mode

  4. Synchronously

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

High safety mode (also called high safety with automatic failover) is the correct database mirroring operating mode for mission critical databases requiring automatic failover. In this mode, transactions are committed synchronously to both principal and mirror servers before acknowledging success, ensuring zero data loss. High performance mode is asynchronous and doesn't support automatic failover.