Questions on Database System Concepts and Design - Quiz 1 | CS 6400, Quizzes of Computer Science

Material Type: Quiz; Class: DB Sys Concepts& Design; Subject: Computer Science; University: Georgia Institute of Technology-Main Campus; Term: Spring 2006;

Typology: Quizzes

Pre 2010

Uploaded on 08/05/2009

koofers-user-xf4-2
koofers-user-xf4-2 🇺🇸

8 documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
QUIZ 1 (Feb 16th 2006) NOTES
Quiz in class Thursday Feb 16th:
The quiz will cover Chapters 1-6 and Chapter 29. (some parts of Ch 6 will be omitted
based on how far we get in class by Feb 14th).
- Chapters 1,2,5 will be mostly covered by multiple choice objective questions (see
old quizzes on the webpage).
- Chapter 29 will have a broad essay question (see below for samples)
- Chapter 3-4 will have some multiple choice plus a takehome
question that will be given by Wed noon. You will bring the answer to
class hardcopy when you take the exam.
- Chapter 5 will have some general questions (see below for samples)
- Chapter 6 will have actual queries to answer (see below)
SAMPLE QUIZ QUESTIONS:
Chapter 29
1) Compare and contrast the OLTP and OLAP environment on any four criteria you
consider important.
2) In what sense is data becoming non-standard or un-structured? What are its
implications on the design of database languages?
pf3
pf4

Partial preview of the text

Download Questions on Database System Concepts and Design - Quiz 1 | CS 6400 and more Quizzes Computer Science in PDF only on Docsity!

QUIZ 1 (Feb 16th^ 2006) NOTES Quiz in class Thursday Feb 16th: The quiz will cover Chapters 1-6 and Chapter 29. (some parts of Ch 6 will be omitted based on how far we get in class by Feb 14th).

  • Chapters 1,2,5 will be mostly covered by multiple choice objective questions (see old quizzes on the webpage).
  • Chapter 29 will have a broad essay question (see below for samples)
  • Chapter 3-4 will have some multiple choice plus a takehome question that will be given by Wed noon. You will bring the answer to class hardcopy when you take the exam.
  • Chapter 5 will have some general questions (see below for samples)
  • Chapter 6 will have actual queries to answer (see below) **SAMPLE QUIZ QUESTIONS: Chapter 29
  1. Compare and contrast the OLTP and OLAP environment on any four criteria you consider important.
  2. In what sense is data becoming non-standard or un-structured? What are its implications on the design of database languages?**

Chapters 5, Q. Relational Model and Algebra A. Give a formal definition of the terms: Superkey and Key (minimal) of a Relation. B. Consider the following two tables: Relation T1 Relation T P Q R A B C 10 b 5 10 b 6 15 b 8 25 c 3 25 a 6 10 b 5 Show the results of the following operations:

  1. T1 Equijoin T2 where T1.P = T2.A (Show either P or A in the result, not both)
  2. T1 Join (non-equijoin) T2 where T1.Q < T2.B (The inequality is based on character comparison; Show both Q or B in the result)
  3. T1 Union T
  4. T1 Intersect T
  1. List authors of books that have been adopted (in some course).
  2. List name and phone number of Profs who are teaching courses with Section numbers above 7000.