Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

314 DATA > MIDTERM QUESTIONS > Flashcards

MIDTERM QUESTIONS Flashcards

1
Q

Which of the following is used to uniquely identify each record?

A

Primary Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A file is composed of a group of related ____________________.

A

Records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Analyzing historical sales data stored in a database is commonly referred to as ____.

A

data mining

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which of the following can be used to link the data in two or more tables together?

A

Common Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What represents a characteristic or attribute that is being collected about an entity?

A

Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A(n)________________ relationship cannot exist in a physical relational database.

A

many to many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

(T/F) A bridging table can be used to eliminate a many-to-many relationship in a relational database.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A field is referred to as a(n) ____________________ in the physical database.

A

Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

If uncontrolled, what can lead to data anomalies?

A

Data redundancy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which of the following terms best describes where a group of characters that represents a customer’s address would be stored in the logical design?

A

Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

(T/F) According to the Oracle Naming Standard, ‘-‘ (hyphen) is a legal character.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A DATE column consists of ____________________ bytes.

A

7

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A column’s ____________________ identifies the type of data that can be stored in a column.

A

Data type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

(T/F) A table name can consist of numbers, letters, and blank spaces.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A table name can contain the number sign and ____________________ symbols.

A

Underscore

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

(T/F) When declaring a NUMBER data type, scale is the total number of digits both to the left and to the right of the decimal point.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

(T/F) The scale of a NUMBER column indicates the total number of digits that can be stored in the column.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

____ commands are used to add new database objects.

A

DDL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

(T/F) A column name can consist of up to 225 characters.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is the default format for a DATE value?

A

DD-MON-YY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

The ____________________ command can be used to modify the structure of a table.

A

ALTER TABLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

The ____ TABLE command is used to modify an existing column’s data declaration.

A

ALTER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

When using the ALTER TABLE…DROP COLUMN command, which of the following is not correct?

A

The command can be used to delete multiple columns from a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

The ____________________ clause of the ALTER TABLE command can be used to delete a column from an existing table.

A

DROP COLUMN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

(T/F) DML commands are used to create or modify database tables.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

Which of the following keywords can be used to change the size, datatype, and/or default value of an existing column?

A

MODIFY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

(T/F) The MODIFY TABLE command can be used to change the size of a table.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

A(n) ____________________ enables you to specify that a column value must be a specific value or fall within a range of values.

A

Check Constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

A(n) ____________________ constraint is a table constraint that specifies that a column must have a unique value for every table row.

A

Unique

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

(T/F) A composite key is created using a value constraint.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Which of the following is a table constraint?

A

Unique Constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

A(n) ____________________ constraint limits the value that can be placed in a specific column, irrespective of values that exist in other table rows.

A

Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Which command would be used to delete table x and all foreign key constraints to x?

A

Drop x Cascade Constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

Adding a check condition constraint to a table is a(n) ____________________ action.

A

Restricted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

(T/F) A NOT NULL constraint is an example of a table constraint.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Which command is used to disable the constraint named faculty_loc_id_fk in the faculty table?

A

ALTER TABLE faculty
DISABLE CONSTRAINT faculty_loc_id_fk;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

(T/F) A primary key is defined using an integrity constraint.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

(T/F) The DROP command can be used to remove rows from an existing table.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

The ____________________ command is used to change data stored in a table.

A

UPDATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

(T/F) If more than one data value is being added to a table, the values must be separated by parentheses.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

(T/F) Only one search condition may be listed in a WHERE clause.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

(T/F) If non-numeric data is being added to a column, the data must be enclosed in double quotation marks.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

(T/F) Data that is being added to a table is specified in the VALUES clause of the INSERT command.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

When the INSERT command is being used to enter data into a non-numeric column, the data must be enclosed in ____.

A

Single quotation marks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

(T/F) A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

If the ____ clause of the UPDATE command is omitted, then all the rows in the specified table will be changed.

A

WHERE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

When sorting the results in ascending order, which of the following values will be presented first in the output?

A

Numeric

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

(T/F) When sorted in descending order, NULL values will be listed first in the results, unless the user specifies otherwise.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

(T/F) Oracle11 g is case sensitive when comparing data to a search condition.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

(T/F) To find rows containing a NULL value in a specified column, you must use the search condition of = NULL.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

(T/F) When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as FALSE to be included in the query results.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

(T/F) The default sort order for the ORDER BY clause is ascending.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

When using the LIKE operator, the ____________________ wildcard represents multiple characters.

A

%

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

The maximum number of columns that can be specified for sorting data is ____.

A

255

55
Q

What operator can be used to combine search conditions?

A

AND

56
Q

(T/F) A COMMIT is explicitly issued when the user exits SQL*Plus.

A

False

57
Q

When does a COMMIT command implicitly occur?

A

When the user issues a DDL command such as CREATE or ALTER TABLE

58
Q

(T/F) The COMMIT command is used to add new rows to a table.

A

False

59
Q

(T/F) After a COMMIT command is executed, the ROLLBACK command will have no affect on the changed data.

A

True

60
Q

Use ____ to save a transaction.

A

COMMIT

61
Q

Which of the following commands allows a user to “undo” uncommitted changes to data?

A

ROLLBACK

62
Q

(T/F) A transaction is defined as the set of statements that are committed at one time.

A

True

63
Q

A user who is issuing DML commands can save modified data or undo uncommitted changes by issuing ____ statements.

A

Transaction Control

64
Q

Which keyword permanently saves changed data in a table?

A

COMMIT

65
Q

(T/F) A(n) non-equality join is also known as an equijoin, inner join, or simple join.

A

False

66
Q

(T/F) When a self-join is created, each copy of the table must be assigned a table alias.

A

True

67
Q

Data stored in separate tables can be reconstructed through the use of ____________________.

A

JOINS

68
Q

(T/F) When using the JOIN…ON keywords to join four tables, both keywords must be repeated four times.

A

False

69
Q

(T/F) The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.

A

False

70
Q

(T/F) The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column.

A

True

71
Q

(T/F) A column qualifier is separated from the column name with a colon.

A

False

72
Q

(T/F) A column qualifier indicates the column containing the data being referenced.

A

False

73
Q

A column ____________________ indicates the table containing the column being referenced.

A

Qualifier

74
Q

Tables can be joined in the FROM clause or the WHERE clause of a SELECT statement.

A

True

75
Q

(T/F) The outer join operator is used to combine the results of multiple SELECT statements.

A

False

76
Q

(T/F) Data stored in multiple tables can be combined through the use of an ORDER BY clause.

A

False

77
Q

(T/F) If you are joining five tables in a SELECT statement, five joining conditions will be required.

A

False

78
Q

A full outer join cannot be created in the ____________________ clause.

A

WHERE

79
Q

(T/F) The JOIN keyword is used in the WHERE clause to indicate the tables that should be joined or linked.

A

False

80
Q

(T/F) A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.

A

False

81
Q

(T/F) A(n) outer join can be created by not including a joining condition in a SELECT statement.

A

False

82
Q

(T/F) If you are joining two tables in a SELECT statement, three joining conditions will be required.

A

False

83
Q

(T/F) An outer join only lists rows that contain a match in both tables.

A

False

84
Q

(T/F) Set operators are used to combine the results of multiple queries.

A

True

85
Q

____________________ operators are used to combine the results of multiple queries.

A

Set

86
Q

The ____________________ set operator is used to display the combined results returned by multiple SELECT statements.

A

UNION ALL

87
Q

(T/F) The INTERSECT set operator only displays the rows returned by both queries.

A

True

88
Q

The ____________________ set operator is used to display the rows returned by both SELECT statements.

A

INTERSECT

89
Q

(T/F) When combining the results of two SELECT statements with the MINUS keyword, duplicate rows are suppressed in the results.

A

False

90
Q

(T/F) If you are joining four tables in a SELECT statement, three joining conditions will be required.

A

True

91
Q

A(n) ____ is used to combine the results of two queries.

A

Set operator

92
Q

A(n) ____________________ is a predefined block of code that accepts one or more arguments and returns a single value as output.

A

Function

93
Q

Although the ____________________ table is rarely used in the industry, it can be valuable for someone learning how to work with functions or testing new functions.

A

DUAL

94
Q

(T/F) The NVL function can be used to include records containing null values in calculations.

A

True

95
Q

(T/F) The REPLACE function is used to substitute one character string for another character string in a set of data.

A

True

96
Q

(T/F) The NULLIF function is often combined with the NVL2 function to display a descriptive status.

A

True

97
Q

The ____________________ function is used to determine the number of months between two dates.

A

MONTHS_BETWEEN

98
Q

(T/F) The CONCAT function is used to store the contents of two columns into one column.

A

False

99
Q

Which of the following functions can be used to convert a character string to upper-case letters?

A

UPPER

100
Q

To indicate that minutes should be displayed, include ____________________ in the time element format argument.

A

MI

101
Q

If the data returned by the GROUP BY clause needs to be sorted in descending order, you must include a(n) ____________________ clause in the SELECT statement.

A

ORDER BY

102
Q

The ____________________ clause is used to group data based upon a specified column or columns.

A

GROUP BY

103
Q

The ____ function is used to determine how widely data are spread out within a group.

A

VARIANCE

104
Q

If a SELECT statement contains a GROUP BY clause, but no ORDER BY clause, the results will be presented in ____________________ order based on the column(s) listed in the GROUP BY clause.

A

Ascending

105
Q

The ____________________ function is used to determine the largest value stored in a specified column.

A

MAX

106
Q

The ____ function is based upon the concept of a normal distribution.

A

STDDEV

107
Q

(T/F) A SELECT statement cannot include both a GROUP BY and an ORDER BY clause.

A

False

108
Q

(T/F) The AVG function only includes non-NULL values in its calculations.

A

True

109
Q

(T/F) The COUNT function can be used to count NULL, as well as, non-NULL values.

A

True

110
Q

Which operator will instruct Oracle10 g to list all records with a value that is less than the highest value returned by the subquery?

A

<ANY

111
Q

Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?

A

Correlated subquery

112
Q

(T/F) When the subquery is executed first and the value is passed back as input to the outer query, the subquery is known as an uncorrelated subquery.

A

True

113
Q

(T/F) A correlated subquery is one in which the inner query is executed first, and then the outer query is executed.

A

False

114
Q

(T/F) The EXISTS operator can be used with multiple-row subqueries.

A

True

115
Q

The operators =, <, >, <=, >=, and <> are referred to as ____ operators.

A

Single-row

116
Q

(T/F) If the value of the EXISTS operator is ____________________, then the rows meeting the condition are displayed.

A

TRUE

117
Q

The <> operator is referred to as a(n) ____ operator.

A

Single-row

118
Q

(T/F) A subquery, except one in the FROM clause, can’t have an ORDER BY clause.

A

True

119
Q

(T/F) The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.

A

True

120
Q

The ____________________ pseudocolumn is used to generate the next sequence value.

A

NEXTVAL

121
Q

(T/F) To change the starting value for a sequence, the sequence must be dropped and then re-created.

A

True

122
Q

Which of the following keywords is used to actually generate a sequence value?

A

NEXTVAL

123
Q

SKIP

A
124
Q

What can be created so other users will not need to prefix a table owned by user Jeff with his schema name?

A

Synonym

125
Q

(T/F) A sequence serves as a nickname for a database object.

A

False

126
Q

If a column contains a large number of NULL values, a(n) ____________________ can quickly help determine the rows that contain NULL values and those that do not.

A

Index

127
Q

(T/F) An index is implicitly created when a NOT NULL constraint is added to a table.

A

False

128
Q

Which of the following is defined in Oracle11 g as simply anything that has a name and a defined structure?

A

Object

129
Q

The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

A

Bitmap

130
Q

An index can be created with the ____________________ INDEX command.

A

CREATE

131
Q

The ____________________ view can be used to verify the existence of an index owned by a user.

A

USER_INDEXES

132
Q

A(n) ____________________ can be used to quickly locate specific records in a large table.

A

Index

133
Q

(T/F) A basic CREATE INDEX command will create a B-Tree index.

A

True

134
Q

(T/F) The USER_SEQ data dictionary view can be used to verify sequence settings.

A

False

314 DATA (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions