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 databases

Conventional path load (the default) uses the SQL INSERT statement and a bind array buffer to load data into database tables. When SQL*Loader performs a conventional path load, it wont competes equally with all other processes for buffer resources. This can slow the load significantly. Extra overhead is added as SQL statements are generated, passed to Oracle, and executed. Although appropriate during normal use, this can slow bulk loads dramatically.

  1. True

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

Conventional path loads use SQL INSERT statements and do compete with other processes for buffer resources, which can slow down loading. The statement correctly describes that this overhead makes conventional loads slower than direct path loads for bulk data operations.

Multiple choice technology databases

In Direct Path Loading, Oracle will not use SQL INSERT statement for loading rows. It directly writes the rows, into fresh blocks beyond High Water Mark, in datafiles i.e. it does not scan for free blocks before high water mark. Direct Path load is very fast because Partial blocks are not used, so no reads are needed to find them, and fewer writes are performed. SQL*Loader need not execute any SQL INSERT statements; therefore, the processing load on the Oracle database is reduced. A direct path load calls on Oracle to lock tables and indexes at the start of the load and releases them when the load is finished. During a direct path load, processes perform their own write I/O, instead of using Oracle's buffer cache. This minimizes contention with other Oracle users.

  1. True

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

Direct Path Loading bypasses SQL INSERT, writing rows directly to data blocks beyond the high water mark. This avoids buffer cache contention and SQL processing overhead, making it significantly faster for bulk loads. The statement accurately describes the direct path mechanism.

Multiple choice technology databases

Figure out the indexes which are not part of Sybase IQ?

  1. HG,LF,HNG

  2. DATE,DTTM,CMP,WD

  3. TIME

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

All the index types listed in options A, B, and C are valid Sybase IQ indexes. HG (High_Group), LF (Low_Fast), HNG (High_Non_Group), DATE, DTTM (DateTime), CMP (Compare), WD (WD), and TIME indexes are all part of Sybase IQ's indexing capabilities. Therefore D is correct.

Multiple choice technology databases

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When no TABLESPACE clause is specified, Oracle stores the segment in the user's default tablespace. This is assigned when the user is created and can be viewed with the DEFAULT_TABLESPACE column in DBA_USERS. The SYSTEM tablespace is reserved for data dictionary objects.

Multiple choice technology testing

What is Version Object Base?

  1. It is a repository for storing versioned project artifacts and metadata

  2. It is the creation of multiple releases of a product that's improved, upgraded or customized

  3. It is the management of changes of computer files

  4. It is a component of a program that knows how to perform certain actions
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Version Object Base is a repository for storing versioned project artifacts and metadata. It maintains different versions of project components like reports, models, and configurations, allowing version control, rollback, and tracking of changes over time.

Multiple choice technology

What are the different types of segments in Oracle?

  1. 1- Data segment, 2 - Disk segment, 3- Table segment

  2. 1-Table segment,2-Temporary segment, 3 - View Segment

  3. 1- Data segment,2- Index segment,3- Temporary segment,4- Rollback segment

  4. 1- Data segment,2- Index segment,3- View segment,4- disk segment
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle uses different types of segments to store data efficiently. Data segments store table data, index segments store index structures, temporary segments hold intermediate results during sort operations, and rollback segments store before-images for transaction rollback and recovery. Option C correctly lists all four fundamental segment types used in Oracle database storage management.

Multiple choice technology programming languages

What is the namespace used in .NET Data Provider for Oracle

  1. System.Data.Oracle

  2. System.Data.OracleClient

  3. System.Data

  4. System.Data.Sql
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The .NET Framework Data Provider for Oracle resides in the System.Data.OracleClient namespace, containing classes like OracleConnection and OracleCommand. System.Data.Oracle is not a standard .NET namespace, while System.Data and System.Data.Sql are for general ADO.NET and SQL Server classes.

Multiple choice technology programming languages

You want to cache the data for your application and do some extensive processing, which object will be best suited for your application

  1. DataReader

  2. Linq

  3. DataSet

  4. All of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A DataSet represents an in-memory cache of data. It is disconnected from the database, allowing developers to perform extensive data manipulation, filtering, and caching. A DataReader is read-only and requires a continuous connection, while LINQ is a query syntax rather than a storage object.

Multiple choice technology programming languages

Class used for the .NET database transaction

  1. System.Data.sql

  2. DBtransaction

  3. SqlTransaction

  4. DbConnectionStringBuilder
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In .NET, the DbTransaction class (in System.Data.Common) is the base class for database transactions. SqlTransaction and other provider-specific transactions inherit from DbTransaction, making it the correct answer for the general database transaction class.

Multiple choice technology programming languages

Following namespace used for dataset and datatable

  1. System.Data.SqlClient

  2. System.Data.OracleClient

  3. System.Data.Odbc

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

DataSet and DataTable are core ADO.NET classes in the System.Data namespace. The other options are provider-specific namespaces for SQL Server, Oracle, and ODBC respectively, which contain connection and command classes but not the core DataSet/DataTable types.

Multiple choice technology programming languages

Which is not the an ADO.NET object

  1. SqlDataAdapter

  2. SqlConnection

  3. SqlDataReader

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

SqlDataView is not a valid ADO.NET class. DataView is the correct class name and is provider-independent. SqlDataAdapter, SqlConnection, and SqlDataReader are all legitimate SQL Server-specific ADO.NET objects found in System.Data.SqlClient namespace.

Multiple choice technology web technology

A DataView can provide different views of which one of the following objects?

  1. DataTable

  2. Dataset

  3. RecordSet

  4. DataRelation

  5. RowSet
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DataView is specifically designed to provide different views (sorted, filtered, etc.) of a single DataTable. It cannot directly view an entire DataSet, DataRelation (which defines relationships between tables), or other data structures. RecordSet and RowSet are from ADO classic and Java respectively, not .NET.