IST331Exam1
Fall 2005
V. Matos
True-False Questions
1.The purpose of a database is to help people keep track of things.
Answer: TrueLevel: easy
Page: 4
2.In a database, each table stores data about a different type of thing.
Answer: TrueLevel: easy
Page: 4
3.In a database, each row in a spreadsheet has data about a particular instance.
Answer: FalseLevel: moderate
Page: 4
4.In every database, not just the databases discussed in this book, table names are capitalized.
Answer: FalseLevel: moderate
Page: 4
5.A database shows data in tables and the relationships among the rows those tables.
Answer: TrueLevel: easy
Page: 4
6.Data is recorded facts and figure; information is knowledge derived from data.
Answer: TrueLevel: easy
Page: 5
7.Databases record data in such a way that they can produce information.
Answer: TrueLevel: moderate
Page: 5
8.Enterprise Resource Planning (ERP) is an example of a data mining application.
Answer: FalseLevel: moderate
Page: 7
9.Small databases typically have simple structures.
Answer: FalseLevel: hard
Page: 7
10.Microsoft Access is a low-end product intended for individuals and small workgroups.
Answer: TrueLevel: moderate
Page: 8
11.Applications are computer programs used directly by users.
Answer: TrueLevel: easy
Page: 8
12.Sequenced Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.
Answer: FalseLevel: moderate
Page: 8
13.A database management system (DBMS) creates, processes and administers databases.
Answer: TrueLevel: easy
Page: 9
14.Microsoft Access is just a DBMS.
Answer: FalseLevel: moderate
Page: 9
15.The DBMS engine in Microsoft Access is called Jet.
Answer: TrueLevel: moderate
Page: 9
16.In Microsoft Access, you can use the Oracle DBMS in place of the Jet DBMS by using the appropriate "File" command.
Answer: FalseLevel: moderate
Page: 10
17.In an Enterprise-class database system, a database application interacts with the DBMS.
Answer: TrueLevel: moderate
Page: 10-11 [And see Figure 1-7]
18.In an Enterprise-class database system, a database application accesses the database data.
Answer: FalseLevel: moderate
Page: 10-11 [And see Figure 1-7]
19.In an Enterprise-class database system, business users interact directly with the DBMS, which directly accesses the database data.
Answer: FalseLevel: moderate
Page: 10-11 [And see Figure 1-7]
20.A database is called "self-describing" because it reduces data duplication.
Answer: FalseLevel: moderate
Page: 11
21.The description of a database's structure that is stored within the database itself is called the "metadata."
Answer: TrueLevel: easy
Page: 11-13 [And see Figure 1-10]
22.In a database processing system, stored procedures are held by the database management system (DBMS).
Answer: FalseLevel: hard
Page: 13 [And see Figure 1-10]
23.Information systems that stored groups of records in separate files were called file processing systems.
Answer: TrueLevel: moderate
Page: 18-19 [And see Figure 1-18]
24.The relational model was first proposed in 1970 by E. F. Codd at IBM.
Answer: TrueLevel: moderate
Page: 20
25.Business organizations have resisted adopting object-oriented database systems because the cost of purchasing OODBMS packages is prohibitively high.
Answer: FalseLevel: hard
Page: 21
Part 2. Phrasing queries with SQL.
In this example we assume familiarity with the COMPANY database, sketched below:
EMPLOYEE (fname, minit, lname, ssn, bdate, address, sex, salary, superssn, dno) KEY: ssn
DEPARTMENT (dname, dnumber, mgrssn, mgrstartdate)KEY: dnumber.
PROJECT (pname, pnumber, plocation, dnum) KEY: pnumber.
WORKS_ON (essn, pno, hours) KEY: (essn, pno)
DEPENDENT (essn, dependent-name, sex, bdate, relationship)KEY: (essn, dependent-name)
Write a SQL query to answer the following two requests.
1. Give the SSN of each female employee working for dept 4 whose salary is no less than $50,000.00
2. Give the Fisrt Name, Last Name, and SSN of each female manager