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

Which of the following describes a logical schema?

  1. Entire database

  2. Organising data

  3. Storing of data on disk

  4. Revising the file structure

  5. Shows only user specific data
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The logical schema shows only that part of database that a user is interested in and hides the rest of the data.

Multiple choice

A transparent DBMS ___________.

  1. cannot hide sensitive data

  2. keeps its logical structure hidden

  3. keeps its physical structure hidden

  4. can hide sensitive data

  5. is highly safe
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Transparent DBMS as the name suggests is transparent to its users.

Multiple choice

A network structure represents

  1. physical structure of data

  2. many to many relationship

  3. logical representation of data

  4. a database of future

  5. designing of database
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A network structure shows many to many relationships that exist in the network.

Multiple choice

Semantics refers to

  1. a structure or format of data

  2. timing of data

  3. meaning of each section of bits

  4. speed of data

  5. route of data
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

How a particular pattern is to be interpreted.

Multiple choice

Example of non-numeric data is

  1. Employee address

  2. Examination score

  3. Bank balance

  4. All of the above

  5. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Non-numeric data refers to information that cannot be represented as numbers, such as text, addresses, names, or descriptions. An employee's address contains alphanumeric characters and special symbols, making it non-numeric. Examination scores and bank balances are numeric data as they can be expressed as numbers.