Question

Which of the following is correct .
A. SQL query automatically eliminates duplicates .

b. SQL permits attribute names to be repeated in the same relation .

C.A SQL query will not work if there are no indexes on the relations

d. SQL query does not allow from and where is any order . The full form of DDL is Detailed Data​

Answer 1

Answer:D (none)

Explanation:

An SQL does not remove duplicates like relational algebra projection, we have to remove it using distinct.

An SQL will work slowly but surely if there are no indexes.

An SQL does not permit 2 attributes of same name in a relation.

So, none of the options (a), (b) and (c) are correct. Hence, option (d) is Answer.

Answer 2

Answer:

Answer: D SQL query does not allow from and where is any order . The full form of DDL is Detailed Data​

Explanation:

The computer language SQL, or Structured Query Language, is used to store, manipulate, and retrieve data from relational databases.

The preferred language for Relational Database Systems is SQL. SQL is the common database language used by all Relational Database Management Systems (RDMS), including MySQL, MS Access, Oracle, Sybase, Informix, Postgres, and SQL Server.

Additionally, they speak in various dialects, including

Oracle uses PL/SQL, MS Access uses JET SQL (native format), MS SQL Server uses T-SQL, etc.

Similar to relational algebra projection, a SQL does not automatically delete duplicates; we must do so using distinct.

If there are no indexes, a SQL will operate slowly but surely.

Two characteristics with the same name cannot be in the same relation in a SQL.

The choices (a), (b), and (c) are all incorrect.

Therefore, the answer is (d).

For more details on Essay Writing, https://brainly.in/question/28301617

#SPJ2