IDS410 - Chapter 7: Introduction to SQL (B) 1. What does...

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

View Full Document Right Arrow Icon
Chapter 7: Introduction to SQL (B) 1. What does SQL stand for? (A) Standard Query Language (B) Structured Query Language (C) Semantic Query Language (D) Syntax Query Language (D) 2. Which is not a category of SQL? (A) DDL (B) DML (C) DCL (D) DAL (C) 3. Which is not a SQL command? (A) delete (B) insert (C) search (D) update (D) 4. Which is not a DDL command? (A) alter table (B) create table (C) drop table (D) select table (B) 5. Which is not a DML command? (A) delete (B) drop table (C) insert (D) update (A) 6. Which of the following is to use alter a table? (A) DDL (B) DML (C) DCL (D) DAL (B) 7. Which of the following is to use update a table? (A) DDL (B) DML (C) DCL (D) DAL (B) 8. Which is a set of commands used to update and query a database? (A) DDL (B) DML (C) DCL (D) DAL (B) 9. Which of the following is not a DML command? (A) insert (B) create table (C) delete (D) select (C) 10. To delete a table, which SQL command can be used? (A) delete (B) unpack (C) drop (D) truncate (C) 11. How many attributes will be shown in the following query? select student_no, name, department, address, email (A) 3 (B) 4 (C) 5 (D) 6 (A) 12. In select student_no, score from the grade_report table where course_no = 'CS02208', what is course_no = 'CS02208'? (A) A condition (B) A list of attribute names (C) A list of the relation names (D) None of the above (B) 13. What result set will the following query return? select item_no from order where quantity > 20; (A) The order_id of all orders that had more than 20 items. (B) The item_no of all orders that had more than 20 items. (C) The order_id of all orders that had more than one item. (D) The item_no of all orders that had 20 or more items. (D) 14. Which can be used to select the student's number whose score is greater than or equal to 60 from the grade_report table? (A) select student_no from report where score <= 60. (B) select student_no from report where score > 60 (C) select student_name from grade_report where score >= 60. (D) select student_no from grade_report where score >= 60 (A) 15. To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command. (A) distinct (B) check (C) alter (D) specific (D) 16. The SQL command ________ adds one or more new columns to a table. (A) create relationship (B) create view (C) create table (D) alter table (D) 17. Indexes are created in most RDBMSs to: (A) provide a quicker way to store data. (B) decrease the amount of disk space utilized. (C) increase the cost of implementation. (D) provide rapid random and sequential access to base-table data. (B) 18. What result set will the following query return?
Background image of page 1

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

View Full DocumentRight Arrow Icon
select item_no, description from item where price >= 100 and price <= 200; (A) The item_no for all items costing between 100 and 200 (B) The item_no and description for all items costing between 100 and 200 (C) The item_no and description for all items costing less than 100 (D) The item_no and description for all items costing more than 200 (A) 19. In an SQL statement, which of the following parts states the conditions for row
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/02/2011 for the course IDS 410 taught by Professor Staff during the Spring '08 term at Ill. Chicago.

Page1 / 8

IDS410 - Chapter 7: Introduction to SQL (B) 1. What does...

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

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