Database Final

Front 1

Easier for beginners to use than SQL

Back 1

Query By Example (QBE)

Front 2

Delete, insert, and modify data in existing tables commands fall under what?

Back 2

Data manipulation language (DML)

Front 3

What basic question is addressed with the SQL keyword “SELECT”?

Back 3

What output do you want to see?

Front 4

Which SQL command is used to specify the tables used in query?

Back 4

FROM

Front 5

Which SQL command is used to indicate how tables are linked together?

Back 5

JOIN

Front 6

If you want to get a list of your customers that have purchased from you in the last year, but you only want to list each customer once, how can you prevent multiple listings of the same customer?

Back 6

SEQUENCE

Front 7

Which SQL command is used to control the order that records are displayed in a query?

Back 7

LIKE

Front 8

Which SQL command is used to control the order that records are displayed in a query?

Back 8

ORDER BY

Front 9

To aggregated data so you can use set-based operations (I.e COUNT, AVERAGE, MAX, etc.) you would use which SQL command?

Back 9

GROUP BY

Front 10

What is the question you want to answer from the SQL command FROM?

Back 10

What tables are involved?

Front 11

What is the question you want to answer from the SQL command JOIN?

Back 11

How are the tables joined?

Front 12

What is the question you want to answer from the SQL command WHERE?

Back 12

What are the constraints?

Front 13

The option for ascending or descending order is what SQL command?

Back 13

ORDER BY

Front 14

Using the command AND and OR, this comes from the SQL function..

Back 14

WHERE

Front 15

Operators <,=,>,<>, BETWEEN, LIKE, IN come from what SQL command?

Back 15

WHERE

Front 16

What is the order of the SQL commands (7) (Someone From Ireland Will Grow Horseradish and Onions

Back 16

SELECT, FROM, INNER JOIN, WHERE, GROUP BY, HAVING, ORDER BY

Hint 16

Someone From Ireland Will Grow Horseradish and Onions

Front 17

SQL clause that imposes a query constraint covering a range of values

Back 17

BETWEEN

Front 18

This SQL command restricts the output to a limited number of record

Back 18

TOP

Front 19

Simplified complex Boolean expressions

Back 19

DeMorgans Law

Front 20

Command used to place a constraint on non-aggregate properties

Back 20

WHERE

Front 21

Permits a table to be used more than once in a query

Back 21

SQL

Front 22

To use the SQL HAVING keyword, you must also use what other keyword?

Back 22

GROUP BY

Front 23

Provides visually oriented tools for developing queries

Back 23

Query-by-Example

Front 24

You cannot use which command to see a non aggregated data in the same query?

Back 24

GROUP BY

Front 25

You can use the command WHERE if the query contains GROUP BY. True or false?

Back 25

True

Front 26

To build and manage a database, you need what? (3)

Back 26

1. Data definition language

2. Data manipulation language

3. Data Query Language

Front 27

Using this operator will always result it less than it equal to the number of records returned when the same operator is not used

Back 27

DISTINCT

Front 28

Smaller queries that are integrated together to build a final query

Back 28

Subquery

Front 29

What SQL operator is used to test if one value appears in a set of values?

Back 29

IN

Front 30

Combines all rows of data from similar structures tables or queries (I.e. combining results of similar queries run on the same distributed databases of an international bank)

Back 30

UNION

Front 31

What SQL operator would you use for this subquery?

WHERE salesdate> .........

Back 31

ALL

Front 32

The SQL operator that tests for an exact match

Back 32

IN

Front 33

The SQL operator that works with inequality comparisons

Back 33

ANY

Front 34

To implement a join where records in two tables are linked based on one value falling within a range of values rather than exactly matches between the two tables, you would use an ...

Back 34

Inequality Join

Front 35

Only connects records that have matching values in each table

Back 35

Inner Join

Front 36

Includes records without a match in the other table

Back 36

Outer Join

Front 37

If you want to determine which customers have not bought anything from you in the last month, you could do what kind of join?

Back 37

Right Join

Front 38

Join that merges all the data in records where the join properties match

Back 38

Left Join

Front 39

Query that is used to change existing value within a table

Back 39

UPDATE

Front 40

True or false: a subquery and a view are two terms for the same concept

Back 40

False

Front 41

Only changes one column at the same time

Back 41

QUERY

Front 42

True or False: using an IN operator is an alternative it using a group of OR clauses in a WHERE statement

Back 42

True

Front 43

True or false: All queries can be designed to avoid subqueries

Back 43

False

Front 44

Allows you to use the same table in a subquery as is being used in the outer query (I.e. the query that includes the subquery)

Back 44

SQL

Front 45

Queries that can be split into separate parts and then combined to get the final result

Back 45

Nested Queries

Front 46

2 operators used to compare tables having similar structure (i.e. having common field names and data types)

Back 46

UNION AND INTERSECT

Front 47

True or false: inequality Joins are used to link tables based on a not equal to constraint rather than an equal constaint

Back 47

False

Front 48

Uses the same syntax as a regular query

Back 48

Subquery

Front 49

True or False: using ALL operator is an alternative it using a group of OR clauses in a WHERE statement

Back 49

False

Front 50

Human factors design research has found that these three important factors are considered when building forms and reports (3)

Back 50

1. Clarity or purpose and terminology

2. Layout consistency

3. Presentation Aesthetics

Front 51

Standard user controls on a Control Menu Box allows the user to move the scroll horizontally and vertically within the displayed window?

Back 51

Scroll Bars

Front 52

The type of form that displays multiple records at a time in rows and columns

Back 52

Tabular form

Front 53

When the clicks a ......., a predefined event is triggered, and some action will be performed

Back 53

Command button

Front 54

Allows the user to enter a value that is not in the list

Back 54

Combo box

Front 55

Does not allow the user to enter a value that is not in the list

Back 55

List Box

Front 56

Direct manipulation of objects is a consequence of what advancement in computer systems?

Back 56

Increase emphasis of graphical user interfaces

Front 57

If you want to include some introductory material for your report which is only printed once at the front of the document, it would be placed in the .........

Back 57

Report Header

Front 58

If you wanted to ensure that the title and project name is printed on top of every page, this information would be placed in .........

Back 58

Page header

Front 59

What is the benefit of using style sheets when developing and working with web pages

Back 59

All the layout options are defined in one place

Front 60

Each table property must have a name and a .....

Back 60

Data type

Front 61

From a Human Design perspective, it is good practice for forms to provide Feedback through either what three option (3)

Back 61

1. Visual

2. Text

3. Sound

Front 62

True or False: From a Human Factors Design perspective, issues surrounding aesthetics involves support for physically handicapped users

Back 62

True

Front 63

What form would be appropriate for a banking application where you only want to display a single users record at one time?

Back 63

A single-row form

Front 64

To include a title at the top of each page in a report, the required text would be placed in the .....

Back 64

Page header

Front 65

Linked to the contents of a specific table property, allowing the contents to be displayed and changed

Back 65

Bound Control

Front 66

True or False: a form is a Modal Forms if it incorporates subforms

Back 66

False

Front 67

Form that presents the data in a form similar to a spread sheet

Back 67

Tabular Form

Front 68

Form that is designed to provide the user interface to your database application

Back 68

Switchboard form

Front 69

Form that presents a single record at a time

Back 69

Columnar Form

Front 70

Impacts user performance

Back 70

Form design

Front 71

True or False: form design can impact user performance

Back 71

True

Front 72

What are the 6 Human Factor Designs (FUcC FAC)

Back 72

1. Feedback

2. User Control

3. Consistency

4. Forgiveness

5.Aesthetics

6. Clarity

Front 73

What are the 4 types of forms?

Back 73

1. Tabular

2. Single-Row

3. Sub-forms (one-to-many)

4. Switchboard

Front 74

Form that works best for single forma

Back 74

Tabular Form

Front 75

Form where designer can control data entry sequence

Back 75

Tabular Form

Front 76

Designer can set optimal layout

Back 76

Single-row Form

Front 77

What is another name for single-row form?

Back 77

Columnar Form

Front 78

What are the 3 report types?

Back 78

1. Tabular

2. Labels

3. Columns

Front 79

What 6 items go into a report?

Back 79

1. Report Header

2. Page Header

3. Group Header

4. Group Footer

5. Page Footer

6. Report Footer

Front 80

Title pages that are printed one time for entire report

Back 80

Report Header

Front 81

Title lines or page notes that are printed at the top of every page

Back 81

Page Header

Front 82

Data for a group and headings for the detail section

Back 82

Group Header

Front 83

Sub totals for the group

Back 83

Group Footer

Front 84

Printed at the bottom of every page, page totals or page numbers and notes

Back 84

Page Footer

Front 85

Printed one time at the end of the report. Summary notes, overall totals and graphs for entire data set.

Back 85

Report Footer

Front 86

Innermost data

Back 86

Detail