Computer Knowledge
Database Management Systems
5,344 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
There are _______ types of data.
B
Correct answer
Explanation
Data is generally classified into two main types based on the source of collection: primary data and secondary data.
-
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.
-
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.
-
Full access to target computer
-
Network access to computer only
-
Ability to edit all files
-
Can access database and manipulate data
D
Correct answer
Explanation
The primary effect of a successful SQL injection attack is unauthorized access to the application's database, allowing the attacker to view, edit, or delete sensitive data. It does not typically grant direct control over the entire operating system or local files of the server.