Question

1. Which of the following is generally used for performing tasks like creating the

structure of the relations, deleting relation?

a. DML(Data Manipulation Language) b. Query

c. Relational Schema d. DDL(Data Definition Language)

2. 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?

a. DML(Data Manipulation Language) b. DDL(Data Definition Language)

c.Query d. Relational Schema

3. What do you mean by one to many relationships?

a. One class may have many teachers

b. One teacher can have many classes

c. Many classes may have many teachers

d. Many teachers may have many classes

4. A Database Management System is a type of _________software.

a. It is a type of system software

b. It is a kind of application software

c. It is a kind of general software

d. Both A and C

5. Which one of the following refers to the copies of the same data (or

information) occupying the memory space at multiple places.

a. Data Repository b. Data Inconsistency c. Data Mining d. Data Redundancy​

Answer 1

hi my dear friend

I want I needed the short question

Answer 2

Answer:

1 - DDL (Data definition language)

2 - DML (Data manipulation language)

3 - One class may have many teachers.

4 - it is a type of system software

5 - Data redundancy

Explanation:

1 - The Data Definition Language (DDL) is a set of commands that define the various database structures. Database objects such as tables, indexes, and users are created, modified, and removed using DDL statements. CREATE, ALTER, and DROP are common DDL statements.

2 - DML stands for Data Manipulation Language, and it is a set of operations for inserting, deleting, and updating data in a database. A DML is a sublanguage of a larger language, such as SQL, that contains some of the language's operators.

3 - A teacher may teach zero or more classes in a "class roster" database, whereas a class is taught by one (and only one) teacher. The term "one-to-many" refers to this type of relationship. A single table cannot describe a one-to-many relationship.

4 - The DBMS (Database Management System) is a type of system software that can be used to do a variety of tasks, including building tables and databases, storing data, and administering databases. It also allows you to make changes to the data in the database.

5 - When more than one copy of the same data exists in many locations, this is known as data redundancy.

#SPJ2