What are the advantages and disadvantages of SQL?

Answer 1

ADV

1. View the data without storing the data into the object.

2. Restrict the view of a table i.e. Can hide some of columns in the tables.

3. Join two or more tables and show it as one object to user.

4. Restrict the access of a table so that nobody can insert the rows into the table.

DISADV

1. Can not use DML operations on this.

2. When table is dropped view becomes inactive.. It depends on the table objects.

3. It is an object so it occupies space

Answer 2

Advantages of SQL include its flexibility to handle diverse data types, its ability to retrieve and manipulate large amounts of data efficiently, and its widespread industry use. Disadvantages may include its complex syntax, the potential for security vulnerabilities if used incorrectly, and the need for a deep understanding of database structures to optimize queries.

Answer 3

4 What restrictions apply to the use of the aggregate functions within the SELECT statement? H