DBMS_5thsem_CS2_2023-24

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?

• 1. DML(Data Manipulation Language)

• 1. DDL(Data Definition Language)

• 1. Relational Schema

• 1. Query

What do you mean by one to many relationships?

• 1. One class may have many teachers

• 1. One teacher can have many classes

• 1. Many classes may have many teachers

• 1. Many teachers may have many classes

In the following Query, which of the following can be placed in the Query's blank portion to display the salary from highest to lowest amount, and sorting the employs name alphabetically?

1. SELECT *  

2. FROM instructor  

3. ORDER BY salary ____, name ___;  

• 1. Ascending, Descending

• 1. Asc, Desc

• 1. Desc, Asc

• 1. All of the above

The term "Data" refers to:

• 1. The electronic representation of the information( or data)

• 1. Basic information

• 1. Row Facts and figures

• 1. Both A and C

Which of the following refers to the number of tuples in a relation?

• 1. Entity

• 1. Column

• 1. Cardinality

• 1. None of the above

Which of the following command is a type of Data Definition language command?

• 1. Create

• 1. Update

• 1. Delete

• 1. Merge

Which of the following commands is used to save any transaction permanently into the database?

• 1. Commit

• 1. Rollback

• 1. Savepoint

• 1. None of the above

The term "SQL" stands for

• 1. Standard query language

• 1. Sequential query language

• 1. Structured query language

• 1. Server-side query language

The term "ODBC" stands for_____

• 1. Oral database connectivity

• 1. Oracle database connectivity

• 1. Open database connectivity

• 1. Object database connectivity

Select the correct foreign key constraint?

• Referential integrity

• Entity integrity

• Domain integrity

• None of the above