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

An effect of SQL injection...

  1. Full access to target computer

  2. Network access to computer only

  3. Ability to edit all files

  4. Can access database and manipulate data
Reveal answer Fill a bubble to check yourself
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.

Multiple choice

Primary data is more reliable then secondary data because....

  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 firsthand by the researcher for a specific purpose, meaning it is tailored to the current problem and has not been altered or misinterpreted by others.

Multiple choice

What is metadata?

  1. Data that describes the content, quality, and structure of other data

  2. Data that describes the location of geographic features

  3. Data that describes the relationships between geographic features

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

Metadata is data that describes the content, quality, and structure of other data. It is used to help users understand and use the data.

Multiple choice

Which of the following is NOT a type of CDSS?

  1. Rule-based systems.

  2. Knowledge-based systems.

  3. Data-driven systems.

  4. Hybrid systems.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data-driven systems are not a type of CDSS. CDSSs are typically rule-based, knowledge-based, or hybrid systems.

Multiple choice

What is the most common type of CDSS?

  1. Rule-based systems.

  2. Knowledge-based systems.

  3. Data-driven systems.

  4. Hybrid systems.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Rule-based systems are the most common type of CDSS. They use a set of predefined rules to generate recommendations for clinicians.

Multiple choice

What is the concept of data minimization in the context of big data research?

  1. Collecting only the data that is necessary for the research question

  2. Storing data in a secure and encrypted format

  3. Anonymizing data to protect patient privacy

  4. All of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data minimization refers to the practice of collecting only the data that is essential for the research question, thereby reducing the risk of data breaches and misuse.

Multiple choice

Which data exchange format is commonly used for interoperability between heterogeneous systems?

  1. XML

  2. JSON

  3. CSV

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

XML, JSON, and CSV are widely used data exchange formats that enable interoperability between systems with different data structures and formats.

Multiple choice

Which of the following is NOT a commonly used data format for storing language archives?

  1. Plain text

  2. XML

  3. JSON

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

Binary format is not commonly used for storing language archives because it is not human-readable and can be difficult to process.

Multiple choice

What is the primary modeling language used in MBD?

  1. Unified Modeling Language (UML).

  2. Business Process Model and Notation (BPMN).

  3. Systems Modeling Language (SysML).

  4. Structured Query Language (SQL).
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SysML is specifically designed for modeling complex systems and is widely used in MBD due to its ability to capture both structural and behavioral aspects of systems.

Multiple choice

Which of the following is NOT a common data source for e-commerce analytics?

  1. Website traffic data

  2. Customer purchase history

  3. Social media data

  4. Point-of-sale data
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Point-of-sale data is typically not collected directly through e-commerce platforms, but rather through physical retail stores.

Multiple choice

Which of the following is NOT a characteristic of big data?

  1. Volume

  2. Variety

  3. Velocity

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

Veracity refers to the accuracy and reliability of data, which is not a defining characteristic of big data.

Multiple choice

Which technology is commonly used for storing large volumes of structured data?

  1. Relational databases

  2. NoSQL databases

  3. Data warehouses

  4. Hadoop Distributed File System (HDFS)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

HDFS is a distributed file system designed for storing large volumes of data in a reliable and scalable manner.

Multiple choice

Which of the following job roles is responsible for designing and implementing data analytics solutions?

  1. Data Analyst

  2. Data Scientist

  3. Data Engineer

  4. Business Intelligence Analyst
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data Scientists are responsible for designing and implementing data analytics solutions, using statistical and machine learning techniques.