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
  1. Boot Configuration Database

  2. Backup Configuration Database

  3. Boot Configuration Display

  4. Boot Connection Database

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

BCD stands for Boot Configuration Database. It is a database file used by Windows to store boot configuration data.

Multiple choice
  1. Primary data

  2. Secondary

  3. Tertiory

  4. Multi

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

A research paper that presents original empirical findings, experiments, or direct observations is considered a primary source of data. Secondary sources analyze, interpret, or summarize primary data.

Multiple choice
  1. Searching tool

  2. Searching data

  3. Searching structure

  4. Searching n.b

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

BLAST (Basic Local Alignment Search Tool) is an algorithm and tool used to compare primary biological sequence information, such as the amino acid sequences of proteins or the nucleotides of DNA sequences. It is primarily a searching tool.

Multiple choice
  1. it sounds better

  2. collected by another person, ensuring its authenticity

  3. it is collected by the user of the data and not processed

  4. primary data requires less effort to obtain

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

Primary data is collected directly by the researcher for their specific purpose, meaning it has not been altered or processed by third parties. This direct control over the collection process makes it highly reliable for the user's specific needs. Secondary data, by contrast, was collected by someone else and may have been manipulated or designed for a different purpose.

Multiple choice
  1. The process of adding redundancy to a database

  2. Using triggers to automate tasks

  3. Abstracting data

  4. Putting the database in an exceptional state that prevents public access

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

Denormalization is a database optimization technique where redundant data is intentionally added to one or more tables to improve read performance. This trades write performance and storage space for faster query execution.

Multiple choice
  1. Operations meant to encapsulate a task and must maintain ACID properties

  2. Used to track sequence values

  3. A column data type used to represent arrays

  4. The set of valid values in a BETWEEN clause

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

A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. It is commonly used to automatically generate unique primary key values.

Multiple choice
  1. resource

  2. replication

  3. project

  4. relative URL

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

Database replication is the process of copying and maintaining database objects in multiple databases that make up a distributed database system to ensure consistency. A resource is an asset, a project is a planned undertaking, and a relative URL is a web address path.

Multiple choice
  1. Deep URL

  2. Domain name

  3. Field

  4. codec

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

In a database table, a field (or column) represents a specific category of information, such as a first name or phone number. A Deep URL is a link to a specific web page, a domain name is a website address, and a codec is a device or program that compresses data.

Multiple choice
  1. information

  2. paper

  3. lies

  4. big ideas

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

"Data" refers to facts, statistics, or values collected together for analysis or reference. This is synonymous with "information" that can be processed by a computer or a researcher. Options like "paper" or "lies" do not define what data actually represents.