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

Multiple choice

You can create which of the following components of the RMAN environment that contains the RMAN metadata for multiple target database unless you are using RMAN with a physical standby database?

  1. Media management application

  2. Media management catalog

  3. Recovery catalog database

  4. Duplicate database

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

You can create this component of the RMAN environment that contains the RMAN metadata for multiple target database unless you are using RMAN with a physical standby database.

Multiple choice

Which of the following best describes Oracle?

  1. Spreadsheet

  2. Relational Database Management System

  3. Database Management System

  4. Object Relational Database Management System
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

An ORDBMS offers all the features of a RDBMS plus it offers the benefits of creating user defined objects and types. Oracle offers the user an option to not only create and maintain relationships between different tables but also user defined data types such as Varrays, Types, Nested Table etc..

Multiple choice

A user in Oracle must have which of the following privileges in order to create objects like tables, views, etc.?

  1. Connect

  2. Admin

  3. Create User

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

The resource role allows a user to create and modify new objects like Table, View etc. It is the basic permission that a user requires to create objects. When a user in Oracle is created, it is a two step process - first a new user is created by issuing the create user statement which is create user username identified by password;For example : create user amit identified amit_manager; Once the user is created , it is assigned permissions so that it can carry on with its work. To grant permissions, the create grant statement is issued. For example : Grant connect,resource to amit. This statement will permit the user amit to login(connect) and create objects(resource) 

Multiple choice

Which of the following is/are correct about Hierarchical database model?

  1. This model can have many -to -many relationships among its entities.

  2. This model use SQL language to store the database.

  3. This model does not suffer any insertion anomaly.

  4. This model suffers from deletion anomaly.

  5. Both (2) and (4).
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This is true as deletion of any records in the parent can cause the deletion of that in the child table too.

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

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 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.