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 is/are correct about the 'Central Repository' CASE tool?

  1. This tool has data dictionary as a main component.

  2. This is the integrating tools to share the data among the different tools.

  3. This tool is used to automatic generation of reports and the programs.

  4. All of the above.

  5. Only (1) and (2).
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are the correct statements about the Central Repository tool.

Multiple choice

Which of the following is known as Nonsubversion rule in relational database?

  1. There is no bypass integrity rule allowed for the low level access in the system.

  2. This rule defines the database existence in the distributed environment.

  3. This rule maintains the integrity independence of the database.

  4. This rule defines the data storage irrespective of physically independence.

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

Nonsubversion rule indicates the security feature of the system by maintaining the data with some encryption techniques. This is correct statement.

Multiple choice

Which of these is a schema which allows groups of people to describe social networks without the need for a centralised database?

  1. GFO

  2. BFO

  3. Swoogle

  4. FOAF

  5. Dublin Core
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

FOAF (an acronym of Friend of a friend) is a machine-readable ontology describing persons, their activities and their relations to other people and objects. Anyone can use FOAF to describe him- or herself. FOAF allows groups of people to describe social networks without the need for a centralised database.

Multiple choice

What contents does a factless fact table contain?

  1. numeric facts

  2. textual facts

  3. pseudo-factsSX

  4. dimesional keys

  5. E-R diagram
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A factless fact table is fact table that does not contain fact.They contain only dimesional keys and it captures events that happen only at information level but not included in the calculations level.just an information about an event that happen over a period.

Multiple choice

Which of these refers to the data stored in a data structure and which is not part of the structure of the data structure?

  1. satellite data

  2. pointer

  3. control tables

  4. lookup table

  5. hooks
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Satellite data refers to any payload data which you want to store in your data structure and which is not part of the structure of the data structure. It can be anything you want. It can be a single value, a large collection of values or a pointer to some other location that holds the value.

Multiple choice

Which of these represents a group of data elements that are considered semantically equivalent?

  1. Hyponym

  2. Metadata

  3. Synset

  4. Taxonomy

  5. Meronymy
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Synset, is a group of data elements that are considered semantically equivalent for the purposes of information retrieval. A synset or synonym set is defined as a set of one or more synonyms that are interchangeable in some context without changing the truth value of the proposition in which they are embedded.

Multiple choice

Which of the following tables is a permanent database that has an entry for each terminal symbol?

  1. Terminal Table

  2. Literal Table

  3. Identifier Table

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

The Terminal Table is a permanent database in compiler design that stores entries for each terminal symbol (tokens) in the language. Terminal symbols are the basic atomic elements that cannot be further broken down, such as keywords, operators, and identifiers. The Literal Table stores string/numeric constants, the Identifier Table tracks variable names, and these are distinct from the Terminal Table.

Multiple choice

Which of the following is a permanent database in a general model of compiler?

  1. Literal Table

  2. Identifier Table

  3. Terminal Table

  4. Source code
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In the general model of a compiler, the Terminal Table is a permanent database that maintains information about all terminal symbols used in the language. The Identifier Table tracks variables and names, the Literal Table stores constants, and while source code is input, it's not a permanent database structure maintained by the compiler.