DBMS

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

• DML

• DDL

• Relational Schema

• Query

Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

• DML

• DDL

• Relational Schema

• Query

What do you mean by one to many relationships?

• One class may have many teachers

• One teacher can have many classes

• Many classes may have many teachers

• Many teachers may have many classes

Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.

• Data Repository

• Data Inconsistency

• Data Mining

• Data Redundancy

Which of the following is not a schema?

• Database schema

• Logical schema

• Critical schema

• Physical schema

Who proposed the relational model?

• Bill gates

• E.F.Codd

• Charles Babbage

• Herman Hollerith

In SQL, which command is used to changes data in a table?

• UPDATE

• INSERT

• BROWSE

• APPEND

The term "Data" refers to

• The electronic representation of the information( or data)

• Basic information

• Row Facts and figures

• Both A and C

Rows of a relation are known as the

• Degree

• Tuples

• Entity

• All of the above

The term "SQL" stands for

• Standard query language

• Sequential query language

• Structured query language

• Server-side query language