What are the advantages and disadvantages of SQL?

What will be an ideal response?

Advantages
? Satisfies ideals for database language
? (Relatively) Easy to learn
? Portability
? SQL standard exists
? Both interactive and embedded access
? Can be used by specialist and non-specialist.
Disadvantages
? Impedance mismatch - mixing programming paradigms with embedded access
? Lack of orthogonality - many different ways to express some queries
? Language is becoming enormous (SQL-92 is 6 times larger than predecessor)
? Handling of nulls in aggregate functions
? Result tables are not strictly relational - can contain duplicate tuples, imposes an ordering on
both columns and rows.

Computer Science & Information Technology

You might also like to view...

What is the default blending mode for a layer?

What will be an ideal response?

Computer Science & Information Technology

Describe the responsibilities of the procurement specialist.

What will be an ideal response?

Computer Science & Information Technology