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
-
Boot Configuration Database
-
Backup Configuration Database
-
Boot Configuration Display
-
Boot Connection Database
A
Correct answer
Explanation
BCD stands for Boot Configuration Database. It is a database file used by Windows to store boot configuration data.
B
Correct answer
Explanation
SQL (Structured Query Language) is the standard language used to communicate with and manage relational databases.
-
Primary data
-
Secondary
-
Tertiory
-
Multi
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.
-
Searching tool
-
Searching data
-
Searching structure
-
Searching n.b
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.
-
it sounds better
-
collected by another person, ensuring its authenticity
-
it is collected by the user of the data and not processed
-
primary data requires less effort to obtain
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.
-
The process of adding redundancy to a database
-
Using triggers to automate tasks
-
Abstracting data
-
Putting the database in an exceptional state that prevents public access
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.
A
Correct answer
Explanation
Data Definition Language (DDL) consists of SQL commands like CREATE, ALTER, and DROP, which are used to define or modify the structure of database objects such as tables and schemas.
B
Correct answer
Explanation
A third table (junction or association table) is typically used to resolve many-to-many relationships. In a one-to-one relationship, the connection is usually made by placing a foreign key directly in one of the two related tables.
-
Operations meant to encapsulate a task and must maintain ACID properties
-
Used to track sequence values
-
A column data type used to represent arrays
-
The set of valid values in a BETWEEN clause
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.
-
resource
-
replication
-
project
-
relative URL
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.
-
Deep URL
-
Domain name
-
Field
-
codec
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.
-
information
-
paper
-
lies
-
big ideas
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.