7 - CSI 1306F HOMEWORK 07 From Lecture 12 The Structured...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CSI 1306F – HOMEWORK 07 From Lecture 12: “The Structured Query Language” 1. Label as either True (T) or False (F) each of the following statements. Justify your answer for the “False” cases. ____ Information stored on databases needs to be rapidly and efficiently retrieved. ____ By using SQL’s data manipulation language (DML), it is possible to alter the structure of the database, e.g. table and index creation. ____ When you run an SQL command, you will always get a subset of records that meet the stated criteria. ____ The use of aggregate functions in SQL queries will always return a singleton record set. ____ SQL is a very popular non-relational database language adopted by most of the database management systems. ____ Every SQL statement must include at least the SELECT and FROM clauses. ____ The SQL statement “ SELECT Course, Description FROM Course WHERE Hours = 3 ORDER BY 2 DESC ” will output all three-hour-long courses alphabetically sorted in descending order of
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/01/2010 for the course COMPUTER S CSI1306 taught by Professor Aziri during the Spring '10 term at University of Ottawa.

Page1 / 2

7 - CSI 1306F HOMEWORK 07 From Lecture 12 The Structured...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online