0

Advanced Database System (NCO)

Description: DBMS
Number of Questions: 15
Created by:
Tags: DBMS Database
Attempted 0/15 Correct 0 Score 0

The normal form in DBMS which states that every determinant in the database is a candidate key is

  1. 1 NF

  2. 2 NF

  3. BCNF

  4. 3 NF

  5. 4 NF


Correct Option: C
Explanation:

This normal form in DBMS states that every determinant in the database is a candidate key.

The rule of database software, which states that every transaction must preserve the integrity constraints is called

  1. atomicity

  2. isolation

  3. consistency

  4. durability

  5. rollback


Correct Option: C
Explanation:

This rule of database software states that every transaction must preserve the integrity constraints.

The data models like PICK aka MultiValue and MUMPS aka M is a/an _______________ type of database model.

  1. object

  2. post relational

  3. dimensional model

  4. domain/key normal form

  5. SQL


Correct Option: B
Explanation:

The models like PICK aka MultiValue and MUMPS aka M comes under post-relational model.

The replication is the result of read and write requests calculated by querying a majority of replicas is __________ type of replication.

  1. master/slave replication

  2. multimaster

  3. quorum

  4. schema

  5. data dictionary


Correct Option: C
Explanation:

This type of replication is the result of read and write requests calculated by querying a majority of replicas.

The first step in executing a SQL query in DBMS is

  1. scanning and parsing

  2. query optimiser

  3. query code generator

  4. runtime database processor

  5. subquery


Correct Option: A
Explanation:

This is the first step in executing a SQL query in DBMS as once a query is entered into the system its meaning is to be clearly understood by the compiler.

The set of steps used to access information is a SQL relational database management system is called

  1. query optimiser

  2. DML precompiler

  3. selection operation

  4. query plan

  5. projection operation


Correct Option: D
Explanation:

This is a set of steps used to access information is a SQL relational database management system.

Which type of queries use a term based specification of the desired images that can be matched to textual image descriptors?

  1. Attribute based queries

  2. Textual queries

  3. Visual queries

  4. Metadata descriptors

  5. Visual descriptors


Correct Option: B
Explanation:

This type of queries use a term based specification of the desired images that can be matched to textual image descriptors.

Which of the entity types in DBMS represents the central objects of the system?

  1. Weak

  2. Subclass

  3. Base

  4. Shared subclass

  5. Category


Correct Option: C
Explanation:

This entity types in DBMS represents the central objects of the system.

Which of the following systems are used for management of the semi-structured spatial data represented in maps?

  1. RDBMS

  2. Information Retrieval Systems

  3. Geographic Information Systems

  4. Media Retrieval Systems

  5. Management Information Systems


Correct Option: C
Explanation:

These systems are used for management of the semi-structured spatial data represented in maps

The data model in DBMS, which organises data into a structure that appears as a tree is called

  1. network

  2. hierarchical

  3. relational

  4. object relational

  5. object model


Correct Option: B
Explanation:

This data model in DBMS organises data into a structure, which appears as a tree.

The integrity constraint in DBMS which is also called as attribute integrity in which a column is assigned the possible value only is

  1. entity integrity

  2. Referential integrity

  3. Domain integrity

  4. DDL

  5. DML


Correct Option: C
Explanation:

This type of integrity constraint in DBMS is also called as attribute integrity in which a column is assigned the possible value only.

The denormalisation technique in DBMS in which the database table is split by rows that reduces the number of records per table and hence, drives the performance is

  1. vertical fragmentation

  2. horizontal fragmentation

  3. summary data

  4. duplicate data

  5. functional dependency


Correct Option: B
Explanation:

This is the denormalization technique in DBMS in which the database table is split by rows that reduces the number of records per table and hence, drives the performance.

The methodology of optimising a group of SQL queries altogether with the help of common sub-expressions to save cost and time is

  1. greedy algorithm

  2. mobile database system

  3. multi query optimisation

  4. query optimisation

  5. query tree


Correct Option: C
Explanation:

This is a methodology of optimising a group of SQL queries altogether with the help of common sub-expressions to save cost and time.

The standard in DBMS environment that specifies the process of storing the data into network database and retrieving the data from network database is

  1. centralised database

  2. data model

  3. CODASYL

  4. database server

  5. IMS


Correct Option: C
Explanation:

This is a standard in DBMS environment that specifies the process of storing the data into network database and retrieving the data from network database.

The condition where one attribute is functionally dependent on another non-key attribute of the same relation is

  1. normalisation

  2. transitive dependency

  3. denormalisation

  4. functional dependency

  5. BCNF


Correct Option: B
Explanation:

This is the condition where one attribute is functionally dependent on another non-key attribute of the same relation.

- Hide questions