T490 Spring 2007 Final

Part I, True/False Questions :

1. A columnar Form presents the data in a form similar to a spreadsheet.

True. False.

2. The UNION command combines rows of data from two tables.he basic version of the command will not automatically eliminate duplicate rows of data.

True. False.

3. In composition, a part can have a maximum of one whole.

True. False.

4. All views can be used exactly like tables in any retrieval or update query.

True. False.

5. Page headers can be defined for both reports and forms.

True. False.

6. A table alias is a way to change table names for presentation purposes in reports only but is not essential to answer any type of query.

True. False.

7. When two or more columns need to be matched, simply expand the ON statement by listing all column connections and connecting the statements with an AND.

True. False.

8. Abstract data types and sub-tables are relational features that are related to the object-oriented approach.

True. False.

9. Indexes improve the performance for both retrieval and update queries.

True. False.

10. A relation that has a composite primary key cannot be in 2NF.

True. False.

11. The SQL CASE function is used to create output categories based on certain criteria.

True. False.

12. A Column alias is a way to control the naming of columns in query results.

True. False.

13. A class will participate in a reflexive relationship using two different roles.

True. False.

14. The ASC and DESC keywords control the sort order of SQL query results.

True. False.

15. The primary key can have any value including a null value.

True. False.

16. A columnar Form presents a single record at a time.

True. False.

17. Data triggers only activate after a value in a row is changed.

True. False.

18. A form is a Modal Form if it incorporates subforms.

True. False.

19. Normalization normally results is faster query performance.

True. False.

20. A relation that has a simple primary key (non-composite) must be in 2NF.

True. False.

21. Hierarchical database systems are less navigational than relational database systems.

True. False.

22. The execution of one trigger can cause a different trigger to be executed.

True. False.

23. A transaction always involves at least two operations on the database.

True. False.

24. Ideally, a DBMS will guarantee the properties of Atomicity, Consistency, Isolation and Durability for each transaction, but this may be relaxed for better performance.

True. False.

25. The most common database event types are business events, data events and user events.

True. False.

Part II, Multiple Choice Questions:

26. The _______________ controls how the user moves through the different controls using the tab key.

A) Tab order
B) Name assigned to control objects
C) Control order
D) Location on the form

27. Which of the following statements apply to foreign keys?

A) A Foreign key cannot consist of a composite attribute
B) Foreign keys cannot have null values
C) A table may contain only a single foreign key
D) None of the above

28. To which normal form(s) does the following Fathers relation comply? Fathers(PersonID, PersonName, FatherID, FatherName)

A) 1NF, 2NF
B) 1NF
C) 1NF, 2NF, 3NF, BCNF, 4NF
D) 1NF, 2NF, 3NF

29. The following query is supposed to list the animals that have sold for a price higher than the average for animals in that Category in Sally’s Pet store database that you have studied in the course:
SELECT A1.AnimalID, A1.Name, A1.Category, SaleAnimal.SalePrice FROM Animal As A1 INNER JOIN SaleAnimal ON A1.AnimalID = SaleAnimal.AnimalID WHERE (SaleAnimal.SalePrice >
Which of the following correctly completes this query?

A) (SELECT Avg(SaleAnimal.SalePrice)FROM Animal AS A2 INNER JOIN SaleAnimal ON Animal.AnimalID = SaleAnimal.AnimalID WHERE (Animal.Category = Animal.Category) ) );
B) (SELECT Avg(SaleAnimal.SalePrice) FROM Animal As A2 INNER JOIN SaleAnimal ON A2.AnimalID = SaleAnimal.AnimalID WHERE (A2.Category = A1.Category) ) );
C) (SELECT Avg(SaleAnimal.SalePrice)FROM Animal INNER JOIN SaleAnimal ON Animal.AnimalID = SaleAnimal.AnimalID WHERE (Animal.Category = Animal.Category) ) );
D) (SELECT Avg(SaleAnimal.SalePrice) FROM Animal AS A1 INNER JOIN SaleAnimal ON A1.AnimalID = SaleAnimal.AnimalID WHERE (A2.Category = A1.Category) ) );

30. A difference between a list box and a combo box is:

A) The user can not select an entry from a list box (it is only for informational purposes) but can with a combo box
B) A list box can be bound to a property in a table, whereas a combo box can not
C) A combo box allows the user to enter a value that is not in the list, which is not allowed in a list box
D) A combo box can be bound to a property in a table, whereas a list box can not

31. According to DeMorgan's Law, the Boolean expression NOT (A AND B) is equivalent to:

A) NOT (A AND NOT B)
B) (NOT A) OR (NOT B)
C) (NOT A) AND (NOT B)
D) NOT(A OR B)

32. To which normal form(s) does the following marriage relation comply?
Marriage(BrideID, GroomID, BrideName, BrideBirthDate, GroomName, GroomBirthdate)

A) BCNF
B) 1NF
C) 1NF and 2NF
D) 3NF

33. Which SQL keyword is used to eliminate duplicates in query results?

A) GROUP BY
B) SELECT
C) ORDER BY
D) DISTINCT

34. Which of the following best describes a correlated subquery?

A) A select query that contains the correlation function Corr()
B) Is a subquery that refers to data rows in the main query.
C) Is inefficient because the subquery must be re-evaluated for each row in the main query.
D) Both B and C above

35. The type of form that displays data from two tables that have a one-to-many relationship is called a _______________.

A) Relational form
B) Crosstab form
C) Subform
D) Referential form

36. Cascade delete in referential integrity means that:

A) If a record is deleted in the referenced relation, then all matching records in the referring table will be deleted also
B) If a record having a foreign key is deleted, then all matching records in referenced relation are deleted also
C) A delete in the referring relation results in other deletes in the same table
D) None of the above

37. If you want to include a page number at the bottom of each page, this would be specified in the _____________________.

A) Report gutter
B) Gutter
C) Page footer
D) Page setup

38. If a table had multiple identical records, then this table would be said to:

A) Have no primary key
B) Have no foreign key
C) Have multiple foreign keys
D) Have multiple primary keys

39. Database application developers should maximize the time spent on which of the following activities

A) Design
B) Programming
C) SQL
D) Both A and C above?

40. A table that is in ith normal form is:

A) Also in i-1 (or the next lower) normal form
B) Not necessarily in any other normal form
C) Also in i+1 (or the next higher) normal form
D) None of the above

41. An empty triangle is used to signify which construct in a class diagram?

A) Composition
B) Reflexive association
C) Aggregation
D) Generalization

42. A simple class diagram for a university database has only three classes: Teachers, Students and Courses.
How many binary associations will be sufficient to establish whether Teacher X is teaching Course Y to student Z?

A) 3
B) 1
C) 2
D) None of the above

43. What will the following query produce if it is run against the Employee table shown?
SELECT * FROM Employee WHERE EmpCity = "Muscat" GROUP BY DepartmentID; Employee(EmployeeID, EmpName, EmpAddress, EmpCity, EmpTel, DepartmentID)

A) Will return the details of every employee is Muscat, grouped by DepartmentID
B) Will provide all details of all employees in Muscat
C) Will not run
D) Will run correctly but will return nothing

44. Which type of query combines every row from the left table with every row from the right table and inserts a NULL value into columns of rows that do not match?

A) OUTER JOIN
B) FULL JOIN
C) INNER JOIN
D) THETA JOIN

45. Which of the following are not SQL DDL commands?

A) CREATE VIEW
B) CREATE SCHEMA, CREATE TABLE, ALTER TABLE
C) UNION, INTERSECT and EXCEPT
D) DROP TABLE, CREATE INDEX, DROP INDEX

46. Suppose that passports could only be issued from within the country issuing the passport, and assuming that passport numbers are not unique across countries.
To which normal form would the following passports relation comply?
Passports(Country, PassportNumber, DateOfIssue, ExpirationDate, AddressOfPlaceOfIssue)

A) 1NF, 3NF
B) 1NF
C) 1NF, 2NF, 3NF
D) None of the above.

47. New database application development should proceed in what order?

A) Feasibility study, Analysis, Design, Development and Implementation
B) Design, Development and Implementation
C) Feasibility study, Design and Implementation
D) Feasibility study, Design. Analysis, Development and Implementation

48. Which DBMS component is responsible for data storage, retrieval and update?

A) The application generator
B) The query processor
C) The security subsystem
D) The database engine

49. Compared to the old file approach, the DBMS offers these unique advantages:

A) Access to data through application programs
B) The ability to store and retrieve data
C) Minimal data redundancy and ease of application development
D) Fastest response time

50. The type of form that acts like a menu and directs the user to other forms and reports is called a _______________.

A) Menu form
B) Switchboard form
C) Dropdown form
D) Popup form

Quiz script provided by
JavaScriptKit.com