rachasak quiz

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

• Data Analysis

• Data Visualization

• DDL(Data Definition Language)

• DML(Data Manipulation Language)

To replace the relation section with some other relation the initial step to be carried out is

• Add more content to the existing relation section

• Select section

• Drop section

• Delete section

A........ is a representation of DBMS design.

• Database architecture

• Query Language

• Normalization Table

• Data Flow Diagram(DFD)

Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups

• First normal form(1NF)

• Second Normal form(2NF)

• Fourth Normal form(4NF)

• Third Normal Form(3NF)

Which of the following commands do we use to delete a relation(R) from a database?

• DELETE R

• REMOVE R

• DROP DATABASE R

• DROP TABLE R

IF you were collecting and storing information about your music collection, an album would be considered a/an______

Table below is the example of _____.

• Diagram representation

• Data redundancy

• Chart representation

• Graph representation

....... is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems.

• Data Management Service(DMS)

• Data Management Software(DMS)

• Data Management Solution(DMS)

• Database Design

What is the main purpose of Second Normal Form (2NF) in database normalization?

• To eliminate transitive dependencies

• To Allow repeating groups of data in a table

• To ensure all attributes are atomic

• To remove partial dependencies on any candidate

A table on the many side of a one to many or many to many relationship must

• Be optional

• Have a composite key

• Be on the one side of the relationship

• Have a primary key