0

Relational Database Design Tools and Techniques

Description: This test basically related to the design and tools that are used in database design by the database administrators while maintaining database. This test has equally importance for CS students as well as for gate aspirants.
Number of Questions: 17
Created by:
Tags: databse design gate cs ugc dbms Database Management System
Attempted 0/17 Correct 0 Score 0

Which of the following characteristics is defined for a Relational Database model?

  1. Each row of the database table should be unique.

  2. The values are atomic in the database tables.

  3. Each column has a unique name.

  4. The column values are of the same type.

  5. All of the above


Correct Option: E
Explanation:

All statements are applicable for Relational Database model.

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


Correct Option: D
Explanation:

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

Which of the following is/are the characteristic(s) that the Network model contain(s)?

  1. It can allow many-to-many relationships.

  2. The record types can be linked through the circular linked list.

  3. In this model, a child can have only one parent and the parent can have multiple children.

  4. All of the above.

  5. Only (1) and (2).


Correct Option: E
Explanation:

These options have correct statements about Network model.

What is/are the disadvantage(s) of using Network Models?

  1. Data integrity

  2. Operational anomalies

  3. System complexity

  4. Data independence

  5. Both (2) and (3)


Correct Option: E
Explanation:

These are the disadvantages of using this model.

Which of the following is/are false statements about the database models?

  1. Relational database model does not have deletion anomalies.

  2. Network database does not have deletion anomalies.

  3. Network database does not have updation anomalies.

  4. None of the above.

  5. Both (2) and (3).


Correct Option: D
Explanation:

All are the correct statements about the relational database models.

Which of the following describes the disadvantage(s) of using CASE tools in database design?

  1. Improved productivity

  2. Slow implementation

  3. Increased cost

  4. All of the above

  5. Both (2) and (3)


Correct Option: E
Explanation:

These are the disadvantages of CASE tools.

What is/are the function(s) of CASE (Computer-Aided Software Engineering) tools in relational database design?

  1. Designing a data model

  2. Data conversion

  3. Generating reports

  4. Programming and testing

  5. All of the above


Correct Option: E
Explanation:

These are the functions related to CASE tools.

Which of the following CASE tools are used for creating the system forms and the reports?

  1. Diagramming tools

  2. Prototype tools

  3. Project management tools

  4. Code generators

  5. Analysis tools


Correct Option: B
Explanation:

These tools generate the prototype model for the system to be build. These tools create the system forms, reports and screens.

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


Correct Option: E
Explanation:

These are the correct statements about the Central Repository tool.

What is/are the condition(s) of using Third Normal form?

  1. The table should be in 2 NF.

  2. The non-prime attributes must be dependent on primary key.

  3. There must be transitive functional dependency to be in 3NF.

  4. All of the above.

  5. Both (1) and (2).


Correct Option: E
Explanation:

These are correct statements.

Which of the following CASE tools is/are responsible for the system construction for the predefined objects?

  1. Analysis tool

  2. Code generator

  3. Visual development tool

  4. Central repository tool

  5. Both (2) and (3)


Correct Option: C
Explanation:

This tool assists in system construction by providing a piecing for visual predefined object rather than typing programming commands.

What is/are the advantage(s) after removing the transitive dependency form the database tables?

  1. Amount of data duplication is not possible.

  2. Data integrity is achieved.

  3. Less amount of overhead possible.

  4. All of the above.

  5. Both (1) and (2).


Correct Option: D
Explanation:

All are the advantages of removal of transitive dependency form the database.

Which of the following is/are the false statement(s) in database normalization?

  1. First normal form provides the unordered set of data.

  2. Second normal from considers all the non primary columns in the table should depend on the primary key.

  3. Third normal form does not have any transitive dependency.

  4. There are no anomalies possible in data normalization.

  5. None of the above


Correct Option: E
Explanation:

All are the correct statements.

Which of the following is/are false about First Normal form?

  1. It creates a set of separate table for each set of data.

  2. It identify each set of related data with a foreign key.

  3. It eliminates the repeating groups of data.

  4. Both (2) and (3).

  5. None of the above


Correct Option: B
Explanation:

It uses a primary key for identification of each set of related data in the database.

Which of the following is/are false statement(s) about 'Specializaton' in database design?

  1. It is a bottom up approach to arrange the entities.

  2. In this, two entities can be treated as single entity.

  3. Specialization follows the ISA approach.

  4. Specialization is opposite of generalization.

  5. Both (1) and (2).


Correct Option: E
Explanation:

These are the incorrect statements.

Which of the following is/are correct about Data Dictionary in the database design?

  1. Data dictionary provides the name and description of the data structure.

  2. It provides the database report generation.

  3. It provides easy search for the data type sand keywords.

  4. All of the above.

  5. Both (1) and (3).


Correct Option: D
Explanation:

These are the correct statements about data dictionary.

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


Correct Option: A
Explanation:

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

- Hide questions