IDS410_MoreSampleQuestions

IDS410_MoreSampleQuestions - Questions from Companion...

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

View Full Document Right Arrow Icon
Questions from Companion Website Multiple Choice 1. A(n) ____ database is one where data are stored in a collection of tables. Correct answer : relational All data relationships are represented by common values in related tables. 2. Which is NOT an advantage of a standardized relational language like SQL? Correct answer : Fixing deficiencies is relatively easy The considerable effort required to fix deficiencies is not an advantage of a standardized language such as SQL. 3. A ____ is a structure that contains descriptions of objects created by a user. Correct answer : schema A schema contains these descriptions and may include base tables, views, and constraints. 4. SQL commands can be classified into three types. Which is NOT an SQL command type? Correct answer : DGL The command types are DDL (data definition language), DML (data manipulation language), and DCL (data control language). 5. Three SQL DDL CREATE commands are Correct answer : Schema, Table, and View. SQL DDL CREATE commands include Schema, Table, and View. 6. Which is NOT an advantage of using a view? Correct answer : Decrease system overhead Decreased system overhead is not an advantage, as additional processing time is needed to recreate a view each time it is accessed. 7. A ___ view constructed automatically, not maintained as real data, is costly since it must be recalculated each time it is requested. Correct answer : dynamic A dynamic view is a virtual table, created each time it is requested. 8. A ____ view can improve the performance of distributed queries, especially if the view is relatively static and does not have to be refreshed often. Correct answer : materialized A material view can improve performance of distributed queries. 9. Data integrity can be ensured through which updates? Correct answer : Cascading, set null, and restricted updates Data integrity can be ensured through cascading, set null, set default, and restricted updates. 10. Which keyword is NOT included in most data retrieval statements? Correct answer : AS Most SQL data retrieval statements include the clauses SELECT, FROM, and WHERE. 11. Functions include Correct answer : COUNT, SUM, and AVG. Functions include COUNT, MIN, MAX, SUM and AVG. 12. In a basic SELECT statement, ____ determines which tables or views will be used in the query. Correct answer : FROM FROM determines which tables or views will be used.
Background image of page 1

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

View Full DocumentRight Arrow Icon
13. In a basic SELECT statement, ____ sets the criteria of the query. Correct answer : WHERE WHERE sets the criteria. 14. In a basic SELECT statement, ____ is used to categorize results.
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 / 6

IDS410_MoreSampleQuestions - Questions from Companion...

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