What are the main 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 (SQL2 is 6 times larger than predecessor; SQL3 is even larger again)
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...
The ____ is an executive-level document, usually drafted by or at least in cooperation with the organization's chief information officer.
A. EISP B. ISSP C. managerial guidance SysSP D. technical specification SysSP
Smurf and Fraggle are examples of what type of attack?
a. Gaining access b. Bandwidth consumption c. SYN Flood attack d. Program and application attacks
The word shown in bold is spelled correctly in the following sentence.The team scored early goals in both halfs of the game.?
Answer the following statement true (T) or false (F)
You are using VMware Workstation 12 Pro and are currently on the "Select I/O Controller Types" window. What are your choices for configuration of the adapter in this window?
What will be an ideal response?