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

The distinguishable parts of a record are called

  1. files

  2. data

  3. database

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

Fields are the distinguishable parts or individual data elements within a record. A record contains multiple fields (like name, age, address in an employee record). Files are collections of records, data is the general term for information, and a database is an organized collection of related data. Fields are the smallest named units.

Multiple choice

What is a 'tuple' in RDBMS?

  1. A row or record in a database table

  2. Another name for the key linking different tables in a database

  3. An attribute attached to a record

  4. Another name for a table in an RDBMS
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In relational database terminology, a tuple refers to a single row or record in a table. It represents one complete set of related data values. A key is called a primary or foreign key (not tuple), an attribute is a column, and a table is a relation. The term comes from mathematical set theory.

Multiple choice

Controlled vocabulary in indexing is called:

  1. A thesaurus

  2. A language dictionary

  3. A dictionary of syononyms

  4. A list of subject heading
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Controlled vocabulary in indexing is called a thesaurus. A thesaurus provides standardized terminology for indexing and retrieval, showing relationships between terms (broader, narrower, related). It ensures consistency in indexing by controlling term selection and helping indexers choose appropriate terms. Unlike a general dictionary, a thesaurus is designed specifically for information organization and retrieval systems.

Multiple choice

In which of the following techniques, the storage requirement of a particular constituent is calculated from various information items like its length and dimensionality stored in the tables?

  1. Data flow analysis

  2. Semantic analysis

  3. Source code analysis

  4. Synthesis analysis

  5. Program execution activity
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In this technique, the storage requirement of a particular constituent is calculated from various information items like its length and dimensionality stored in the tables.

Multiple choice

Which of the following methods in ResultSetMetaData interface retrieves the designated column's database-specific type name?

  1. getColumnName(int column)

  2. getColumnType(int column)

  3. getColumnTypeName(int column)

  4. getColumnNameType(int column)

  5. getColTypeName(int column)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

getColumnTypeName(int column) method is present in the ResultSetMetaData interface and it retrieves the designated column's database-specific type name. So, this answer is correct.

Multiple choice

Which of the following methods in the ParameterMetaData interface retrieves the designated parameter's database-specific type name?

  1. getParameterName(int param)

  2. getParameterType(int param)

  3. getParameterTypeName(int param)

  4. getParameterNameType(int param)

  5. getTypeOfParameter(int param)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the correct answer because getParameterTypeName(int param) method is defined in the ParameterMetaData interface and it retrieves the designated parameter's database-specific type name.