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.
You might also like to view...
Most large organizations, including businesses and universities, have an intranet that looks and acts like the Internet, but can only be accessed with a password
Indicate whether the statement is true or false
To enable Find My Mac, start iCloud
Indicate whether the statement is true or false
Which of the following printer issues is most likely resolved by performing a calibrate function on a laser or inkjet printer?
A. Misaligned colors on printed page. B. Voids in one or more colors on a printed page. C. Misfeeds (no paper being pulled from the paper tray)Â D. Multiple sheets pulled from the paper tray at one time. E. Gradual fading over time as the pages are printed.
______ checking is an audit process to review the organization’s security processes.
Fill in the blank(s) with the appropriate word(s).