Brainscape's Knowledge GenomeTM

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


See full index

CSC 555 > Final > Flashcards

Final Flashcards

1
Q

The time required to read or write the first byte of data is known as _____.
access time
transfer rate
random-access
volatility

A

access time

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

A magnetic disk groups data into _____.
blocks
sectors
kilobytes
pages

A

sectors

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

A relational database uses row-oriented storage to store an entire row
within one _____.
Table
block
page
sector

A

block

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

With column-oriented storage, a block stores values for _____.
a single column
non-key columns
key columns only
all table columns

A

a single column

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

Data was not saved before a system was accidentally powered off. This data was located in _____.
non-volatile memory
volatile memory
flash storage
magnetic storage media

A

volatile memory

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

The heap table structure is optimized for _____.
inserting new rows
deleting all rows with primary key between two fixed values
reading all rows with primary key between two fixed values
updating all occurrences of a specific value of a column, in all rows

A

inserting new rows

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

The sort column in a sorted table determines the _____ row order.
key
physical
dynamic
linked

A

physical

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

Which table structure might use the modulo function to locate rows?
Sorted
Hash
Heap
Cluster

A

Hash

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

In a multi-table, a _____ column is available in all interleaved tables.
sort
hash function
bucket
cluster key

A

cluster key

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

A _____ assigns each row to a group of linked blocks, called a bucket.
hash table
heap table
table cluster
sorted table

A

hash table

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

A single-level index is a file that contains column values and pointers to _____ containing the column _____.
tables, key
blocks, key
rows, value
tables, rows

A

rows, value

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

In order to locate rows selected by a query, an index scan reads index blocks _____.
in reverse order
randomly
sequentially
in order of key values

A

sequentially

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

When performing a search, which scan type is fastest?
Cluster
Row
Table
Index

A

Index

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

A _____ index is an index on a non-unique sort column.
clustering
primary
secondary
sorted

A

Clustering

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

When a table is updated and the index block has no free space for a new index entry, what happens?
An error results.
A new block is merged.
The block splits.
The entry is removed.

A

The block splits

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

The bottom level of a multi-level index is a _____index.
sorted single-level
unsorted single-level
bottom-level block
primary and clustering

A

sorted single-level

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

What is the fan-out for a multi-level index where index entries are 32 bytes and index blocks are 10 kilobytes?
Approximately 400
Approximately 300
Approximately 200
Approximately 500

A

Approximately 300

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

How are blocks read with a single-level index scan?
A scan is initiated to read all table blocks. Index blocks are then read.
The search reads one index block plus selected table blocks.
A scan reads all index blocks to find table blocks that contain selected rows. The table blocks are then read.
A scan is initiated to read all table blocks that contain index blocks with selected data.

A

A scan reads all index blocks to find table blocks that contain selected rows. The table blocks are then read.

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

Branches that are similar in length in an index hierarchy are _____.
sparse
primary
balanced
dense

A

balanced

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

Which of the following is a characteristic of a B-tree index, but not a B+tree index?
Pointers to table blocks appear only in the bottom level.
All column values appear in the bottom level.
Column values are occasionally repeated in the index.
Column values do not repeat at lower levels.

A

Column values do not repeat at lower levels.

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

Hash index entries are assigned to _____.
buckets
values
clusters
blocks

A

buckets

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

What are two characteristics of an efficient bitmap index?
The WHERE clause may specify any values in upper case. The column used in a WHERE clause may contain mixed upper and lower case characters.
The database can quickly determine the block containing a table row from the index row number. Any indexed column contains relatively few distinct values.
Each bucket initially has one block. Any additional blocks are allocated and linked to the initial block.
Indexes change only when primary key values are updated. Physical indexes change whenever a row moves to a new block.

A

The database can quickly determine the block containing a table row from the index row number. Any indexed column contains relatively few distinct values.

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

What is a characteristic of a logical index?
Each bucket initially has one block.
Any additional blocks are allocated and linked to the initial block.
The block containing a table row is determined from the index row number.
Index does not change when a row moves to a new block.

A

Index does not change when a row moves to a new block.

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

A column contains grades from 0 to 10, but a WHERE clause specifies values from 0 to 100. A _____ index can be used to modify the column values and process the queries.
logical
function
multi-level
single-level

A

function

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

In a logical index, pointers to table blocks are replaced with _____ values.
artificial key
primary key
foreign key
composite key

A

primary key

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

What object maps one or more tables to a single file?
Tablespace
Shard
Vertical partition
Horizontal partition

A

tablespace

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

A subset of table rows is called a _____.
horizontal partition
fragment
cluster
vertical partition

A

horizontal partition

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

How does a list partition assign rows to partition?
A value that is determined automatically by the database.
A return value from a partition expression that uses VALUES IN.
A return value from a partition expression that specifies MAXVALUE.
A specified number of partitions assigned with positive integer values.

A

A return value from a partition expression that uses VALUES IN.

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

When a table is assigned to a tablespace, where is the index stored?
In an adjacent tablespace.
Within the table.
In the same tablespace as the table.
In a separate tablespace file.

A

In the same tablespace as the table.

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

A _____ partition requires a partition expression with positive integer values.
vertical
list
hash
horizontal

A

hash

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

Which storage engine provides full support for transaction management and locking?
MEMORY
MySQL
MyISAM
InnoDB

A

InnoDB

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

In MySQL with InnoDB, how are primary and secondary indexes created?
Primary indexes are automatically created for each primary key. Secondary indexes are created manually for all foreign keys.
Primary indexes are manually created for each primary key. Secondary indexes are created manually for all foreign keys.
Primary indexes are automatically created for each primary key. Secondary indexes are created automatically for all foreign keys.
Primary indexes are manually created for each primary key. All secondary indexes are created automatically.

A

Primary indexes are automatically created for each primary key. Secondary indexes are created automatically for all foreign keys.

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

In MySQL with InnoDB, tables with a primary key have a _____ structure, while those without a primary key have a _____ structure.
cluster, heap
sorted, hash
sorted, heap
heap, sorted

A

sorted, heap

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

What approach can a database administrator use to assess the effectiveness of indexes when investigating slow queries?
Inspect query logs
Partition large tables
Change the primary key
Run EXPLAIN on queries

A

Run EXPLAIN on queries

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

A database _____ is a unit of work that is treated as a whole. It is either completed as a unit or failed as a unit.
commit
operation
rollback
transaction

A

transaction

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

In an online bank application that transfers funds from a checking account to a savings account, if a debit is made successfully from the checking account, the _____ property ensures that the corresponding credit is made to the savings account.
atomicity
isolation
consistency
durability

A

atomicity

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

In an online bank application that transfers funds from a checking account to a savings account, the _____ property ensures that another transaction sees the transferred funds in one account or the other, but not in both, nor in neither.
durability
atomicity
isolation
consistency

A

isolation

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

In an online bank application that transfers funds from a checking account to a savings account, the _____ property ensures that the changes made to each account will not be lost due to a computer failure.
durability
consistency
isolation
atomicity

A

durability

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

A ____ is a sequential order of database instructions for multiple transactions.
Query
Transaction
Schedule
Path

A

Schedule

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

Refer to the schedule below. The initial value of B is 7 and C is 3. What is the value of A after the schedule executes?

A schedule with two transactions. Line 1, T1: read B. Line 2, T1: A = B + 1. Line 3, T1: write A. Line 4, T1: commit. Line 5, T2: read C. Line 6, T2: B = C - 2. Line 7, T2: write B. Line 8, T2: commit.
4
7
8
2

A

8

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

Refer to the schedule below. The initial value of B is 7 and C is 3. What is the value of A after conflicting schedule executes?

A schedule with two transactions. Line 1, T2: read C. Line 2, T2: B = C - 2. Line 3, T2: write B. Line 4, T1: read B. Line 5, T1: A = B + 1. Line 6, T1: write A. Line 7, T1: commit. Line 8, T2: commit.
4
7
8
2

A

2

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

In which isolation level can dirty reads occur?
Repeatable read
Serializable
Read uncommitted
Read committed

A

Read uncommitted

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

Which isolation level prevents dirty, non-repeatable, and phantom reads?
Repeatable read
Serializable
Read committed
Read uncommitted

A

Serializable

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

A database administrator is updating one of the tables in the database. Which of the following techniques can prevent other database administrators from doing concurrent transactions to the same table?
Scoping
Logging
Mirroring
Locking

A

Locking

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

A _____ is a part of the concurrency system that monitors, grants, and releases locks.
Lock Optimizer
Lock Administrator
Lock System
Lock Manager

A

Lock Manager

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

In a _____, all transactions come to a halt and remain at a standstill until one of the transactions is aborted.
deadlock
locking
two-phase locking
timeout

A

deadlock

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

Which deadlock management technique automatically rolls back a transaction when a lock is not released in a fixed period of time?
Cycle detection
Timeout
Data ordering
Aggressive locking

A

Timeout

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

Refer to the table and schedule below. The UPDATE statement in transaction T1 holds an exclusive lock on the Class table. With strict two-phase locking, when does the SELECT statement in transaction T2 execute?

A schedule with two transactions. Line 1, T1: UPDATE Class. Line 2, T1: SET TeacherID = 32412. Line 3, T1: WHERE ClassID = 80;. Line 4, T2: SELECT CourseTitle. Line 5, T2: FROM Class WHERE ClassID = 80;. Line 6, T1: ROLLBACK;.
Immediately after the UPDATE statement in T1 executes
After the ROLLBACK statement in T1 executes
The SELECT statement in T2 will never execute
At the same time as the UPDATE statement in T1 executes

A

After the ROLLBACK statement in T1 executes

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

A document that sequentially writes all the database operations is known as a/an _____.
system log
task log
recovery log
application log

A

recovery log

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

A recovery system should manage which three failure scenarios?
Transaction failure, System failure, and Storage media failure
Transaction failure, Memory failure, and Storage media failure
Transaction failure, Program failure, and Storage media failure
Transaction failure, System failure, and Application failure

A

Transaction failure, System failure, and Storage media failure

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

The username and password for the database in the configuration file of a web application is incorrect, so the web application cannot connect to the database. Which failure scenario best describes this example?
System failure
Storage media failure
Transaction failure
Task failure

A

Transaction failure

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

Choose the recovery log that is generated by the schedule below.

A schedule with two transactions. Line 1, T1: read B. Line 2, T2: read C. Line 3, T1: A = B + 1. Line 4, T1: write A. Line 5, T1: commit. Line 6, T2: B = C - 2. Line 7, T2: write B. Line 8, T2: rollback.

  1. start T1
  2. start T2
  3. update T1, AID, Aoriginal, Anew
  4. update T2, BID, Boriginal, Bnew
  5. undo T2, BID, Boriginal
  6. commit T1
  7. rollback T2
  8. start T1
  9. start T2
  10. update T1, AID, Aoriginal, Anew
  11. commit T1
  12. update T2, BID, Boriginal, Bnew
  13. undo T2, BID, Boriginal
  14. rollback T2
  15. start T1
  16. update T1, AID, Aoriginal, Anew
  17. start T2
  18. update T2, BID, Boriginal, Bnew
  19. undo T2, BID, Boriginal
  20. commit T1
  21. rollback T2
  22. start T1
  23. update T1, AID, Aoriginal, Anew
  24. start T2
  25. commit T1
  26. update T2, BID, Boriginal, Bnew
  27. undo T2, BID, Boriginal
  28. rollback T2
A
  1. start T1
  2. start T2
  3. update T1, AID, Aoriginal, Anew
  4. commit T1
  5. update T2, BID, Boriginal, Bnew
  6. undo T2, BID, Boriginal
  7. rollback T2
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

In the recovery log below, line 6 is a/an _____.

  1. start T1
  2. start T2
  3. update T1, AID, Aoriginal, Anew
  4. commit T1
  5. update T2, BID, Boriginal, Bnew
  6. undo T2, BID, Boriginal
  7. rollback T2
    checkpoint record
    transaction record
    update record
    compensation record
A

compensation record

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

_____ is a recovery technique that creates a nearly synchronized backup of the primary database on another database server.
Data backup
Cold backup
Storage backup
Hot backup

A

Hot Backup

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

Refer to the sequence below. What is the isolation level of transaction E?

session begins
SET GLOBAL TRANSACTION
ISOLATION LEVEL SERIALIZABLE;
session ends

session begins
SET SESSION TRANSACTION
ISOLATION LEVEL REPEATABLE READ;
transaction A
transaction B
SET TRANSACTION
ISOLATION LEVEL READ UNCOMMITTED;
transaction C
SET TRANSACTION
ISOLATION LEVEL READ COMMITTED;
transaction D
transaction E
session ends
Read uncommitted
Read committed
Repeatable read
Serializable

A

Repeatable Read

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

A transaction _____ indicates the starting and ending statement of a database transaction.
boundary
scope
coverage
limit

A

boundary

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

Refer to the initial Class table, SQL transaction, and final Class table, below. Which SAVEPOINT identifier is used to produce the final Class table?

A table named INITIAL CLASS TABLE with 5 rows and 4 columns. The first row contains headers ClassId, CourseCode, CourseTitle, TeacherId. The second row contains entries 12, HTML1, Web Development, 32412. The third row contains entries 30, DB1, Databases, 11234. The fourth row contains entries 56, PROG1, Programming, 11234. The fifth row contains entries 80, MATH26, Algebra, NULL.

START TRANSACTION;
SELECT CourseTitle FROM Class;
SAVEPOINT S1;

UPDATE Class SET CourseTitle = “Programming in C” WHERE ClassID = 56;
SAVEPOINT S2;

UPDATE Class SET TeacherID = 32412 WHERE ClassID = 56;
SAVEPOINT S3;

DELETE FROM Class WHERE ClassID = 80;
SAVEPOINT S4;

ROLLBACK TO _____;

UPDATE Class SET TeacherID = 32412 WHERE ClassID = 80;
COMMIT;
A table named FINAL CLASS TABLE with 5 rows and 4 columns. The first row contains headers ClassId, CourseCode, CourseTitle, TeacherId. The second row contains entries 12, HTML1, Web Development, 32412. The third row contains entries 30, DB1, Databases, 11234. The fourth row contains entries 56, PROG1, Programming, 11234. The fifth row contains entries 80, MATH26, Algebra, 32412.
S3
S2
S4
S1

A

S2

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

_____ allows all executed database instructions to be rolled back and to be restored in a prior transaction state.
RELEASE SAVEPOINT
SET TRANSACTION
COMMIT
SAVEPOINT

A

SAVEPOINT

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

In MySQL, which of the following SQL operations always commits immediately?
DELETE
SELECT
CREATE
INSERT

A

CREATE

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

Which MySQL layer interacts directly with database users and administrators?
Query Processor
File system
Tools
Storage engine

A

Tools

60
Q

A developer wishes to link to a database with a utility created in C. Which MySQL component does the developer use for the link?
API
Command-Line
Connector
Workbench

A

API

61
Q

In the query processor layer, the query optimizer generates a/an _____.
connection
execution plan
data import
primary key

A

Execution plan

62
Q

Which MySQL component retains data blocks from storage in main memory for possible reuse?
Connection manager
Buffer manager
Storage manager
Cache manager

A

Buffer Manager

63
Q

A buffer manager retains _____ from the _____ to reduce data access time.
data blocks, cache
data blocks, file system
files, file system
free space, cache entries

A

data blocks, file system

64
Q

A database admin uses a SHOW statement to retrieve information about objects in a database. This information is contained in a _____.
data dictionary
file system
storage manager
index

A

data dictionary

65
Q

_____ architecture is an example of a modern multi-tier architecture.
Server
Desktop
Web
Browser

A

Web

66
Q

An organization uses a database and application development tools through a cloud provider’s _____ services.
SaaS
PaaS
IaaS
NaaS

A

PaaS

67
Q

Using a cloud-based database comes with risk. _____ is a regulatory risk.
Security
Reliability
Privacy
Elasticity

A

Privacy

68
Q

A retailer is using a cloud-based transaction database and is experiencing sales fluctuations through the year. The ability for cloud resources to adapt to such change in utilization is called _____.
privacy
reliability
security
elasticity

A

Elasticity

69
Q

An organization deploys computer processing power and storage through a cloud provider’s _____ services.
SaaS
PaaS
IaaS
NaaS

A

IaaS

69
Q

When concurrently processing instructions, a shared memory computer works well with a common data set in a _____ memory space.
parallel
single
cache
distributed

A

Single

70
Q

An organization has a main office and three satellite locations. Data specific to each location is stored locally in which configuration?
Distributed
Private
Shared
Parallel

A

Distributed

71
Q

For integrity purposes, a distributed transaction requires all or _____ nodes to be updated in order to complete the transaction.
no
shared
primary
connected

A

no

72
Q

What occurs when a distributed database experiences a network error and nodes cannot communicate?
Inconsistent transactions
Network partition
Database failure
Consistent records

A

Network partition

73
Q

Which of the following is NOT a replica type?
Database
Data
Table
Query

A

Query

74
Q

A replicated database maintains at least _____ or more replicas on _____ storage devices.
three, distributed
two, separate
three, parallel
two, propagated

A

two, separate

75
Q

A database admin configures replication for a distributed database. Which technique applies updates to any available node?
Parallel system
Group replication
Master/slave
Primary/secondary

A

Group replication

76
Q

Due to infrequent updates, many distributed databases use a _____ catalog.
replicated
parallel
primary
private

A

replicated

77
Q

In a primary/secondary replica update for a distributed database, secondary nodes are updated _____.
at the same time as the primary node replica
with independent local transactions
to any available single node
as a single distributed transaction

A

with independent local transactions

78
Q

Operational data changes _____, while analytic data is updated _____.
in real time, at fixed intervals
at fixed intervals, in real time
in real time, as it changes
at fixed intervals, per a schedule

A

in real time, at fixed intervals

79
Q

An operational database contains tables in third normal form. This design reduces _____.
interference
redundancy
reference time
normalization

A

redundancy

80
Q

Data warehouses should be refreshed periodically. To start, all data should be _____.
cleansed of any errors
restructured for optimization
extracted to a temporary database
integrated the data into a uniform structure

A

extracted to a temporary database

81
Q

For reporting purposes, an organization establishes a(n) _____, which is separate from the operational database.
autonomous database
data warehouse
embedded database
star schema

A

data warehouse

82
Q

During a data _____ phase, a database administrator refreshes a data warehouse and replaces incompatible keys with consistent values.
cleansing
integration
restructuring
extraction

A

integration

83
Q

In a data warehouse that uses a dimensional design, a StudentID column is found in which table?
Schema
Star
Dimension
Parallel

A

Dimension

84
Q

A hierarchy in a dimension table contains a series of _____ where each has a _____ relationship to the next.
columns, one-many
columns, many-many
indexes, one-many
rows, many-many

A

columns, one-many

85
Q

A date dimension table tracks data for two years. How many rows does the table contain?
365
730
24
12

A

730

86
Q

A primary key of a _____ is the composite of the foreign keys that reference a _____.
dimension hierarchy, dimension table
star schema, fact table
dimension table, fact table
fact table, dimension table

A

fact table, dimension table

87
Q

A time dimension table tracks throughout a day by minute. How many rows does the table contain?
60
24
1440
240

A

1440

88
Q

What is a concern with using an in-memory database?
Redundancy
Interference
Volatility
Privacy

A

Volatility

89
Q

A database designer suggests using a database that is packaged with a programming language. Which of the following databases is a good choice?
Autonomous database
Embedded database
Federated database
In-Memory database

A

Embedded database

90
Q

In a federated database, a(n) _____ database operates independently of other databases.
Embedded
In-memory
Heterogeneous
Autonomous

A

Autonomous

91
Q

Raw data that is copied from multiple data sources is called what?
Dimension hierarchy
Replicated catalog
Data lake
Federated database

A

Data Lake

92
Q

In a data lake, data is often loaded _____ rather than _____.
periodically, in parallel
periodically, continuously
continuously, in parallel
continuously, periodically

A

continuously, periodically

93
Q

MONEY is an example of a _____ type.
binary
integer
character
semantic

A

Semantic

94
Q

A complex type _____.
is defined by the user, not the database system
cannot be used in a join query
has multiple values per table cell, from the perspective of the database system
has a richer internal structure than a simple type

A

has a richer internal structure than a simple type

95
Q

Which type is complex?
TEXT
DATE
JSON
BLOB

A

JSON

96
Q

A user-defined type is defined in terms of a _____ type.
complex
base
simple
built-in

A

base

97
Q

In MySQL, a column has a SET type with 16 possible elements. How many bytes does each column value require?
1
2
8
4

A

2

98
Q

The PosgreSQL ARRAY type is an example of a _____ type.
simple
semantic
collection
object

A

Collection

99
Q

Elements of the _____ type can be repeated and are not ordered.
MULTISET
ARRAY
LIST
SET

A

MULTISET

100
Q

What is the difference between the ENUM type and the SET type?
ENUM and SET types are equivalent.
ENUM values are compressed, SET values are not.
ENUM has a character base type, SET has a numeric base type.
Each ENUM value has exactly one element, each SET value can have many elements.

A

Each ENUM value has exactly one element, each SET value can have many elements.

101
Q

In _____ data, each element is named, and element types are not explicitly declared.
semistructured
structured
unstructured
complex

A

semistructured

102
Q

What is wrong with the syntax of this XML?

<menu>
<Item>
<Name>Green salad</Name>
<Description>Lettuce, tomatoes, green peppers</Description>
<Price>7.00</Price>
</Item>
<Item>
<Name>Greek salad</Name>
<Description>Cucumbers, tomatoes, onions, feta cheese</Description>
<Price>8.50</Price>
</Item>
<Item>
<Name>Cobb salad</Name>
<Description>Eggs, bacon, lettuce, tomatoes, green onions</Description>
<Price>11.00</Price>
</Item>
</menu>

XML cannot contain multiple tags with the same name.
Tag names cannot be capitalized.
The XML syntax is correct.
Tags cannot be nested inside other tags.

A

The XML syntax is correct.

103
Q

How many types are possible for elements of a JSON document?
Zero - JSON elements do not have a type
Unlimited - JSON element types are user-defined
6
3

A

6

104
Q

MySQL stores JSON values as _____.
an internal binary format
XML values
a VARCHAR type
a TEXT type

A

an internal binary format

104
Q

Elements can be nested in _____.
neither XML nor JSON
XML but not JSON
both XML and JSON
JSON but not XML

A

both XML and JSON

105
Q

Select the correct WKT syntax for a polygon.
POLYGON(0 0; 20 10; 10 20; 0 0)
POLYGON( (0 0, 20 10, 10 20, 0 0) )
POLYGON(0 0, 20 10, 10 20, 0 0)
POLYGON( (0 0) (20 10) (10 20) (0 0) )

A

POLYGON( (0 0, 20 10, 10 20, 0 0) )

105
Q

Geographic data is _____.
not supported in MySQL
another name for geometric data
any two-dimensional spatial data
defined with reference to the surface of the earth

A

defined with reference to the surface of the earth

106
Q

A standardized spatial reference system is identified with a/an _____.
latitude and longitude
data type
standard coordinate system
SRID

A

SRID

107
Q

How many bytes does POINT(18.5 -20) require in internal MySQL format?
32
24
20
16

A

24

108
Q

In MySQL, spatial values _____ numeric values.
cannot be compared to
are the same as
can be compared directly with
must be converted to numeric values using spatial functions prior to comparing with

A

must be converted to numeric values using spatial functions prior to comparing with

109
Q

In two dimensions, a minimum bounding rectangle is the _____?
the minimum area of a polygon or multipolygon
the sum of the spatial values contained within a rectangle
the rectangular area aligned with the X- and Y-axes that contains all spatial values
the smallest rectangle aligned with the X- and Y-axes that contains a spatial value

A

the smallest rectangle aligned with the X- and Y-axes that contains a spatial value

110
Q

An R-tree has a ____ index with index entries containing ____.
multi-level, MBRs
multi-level, column values
single-level, MBRs
single-level, column values

A

multi-level, MBRs

111
Q

One goal of object-relational database technology is to _____.
simplify database programming
reduce data storage space
improve query response time
simplify database administration

A

Simplify database programming

112
Q

In an object-programming language, a class is like a _____, and an object is like a database _____.
composite type, row
table, column
object, query
schema, instance

A

composite type, row

113
Q

An object-relational database is _____.
an object-oriented programming language with database capabilities such as transaction management
a software layer between a relational database and an object-oriented programming language
a relational database that supports an object type
an object database that supports subtables and supertables

A

a relational database that supports an object type

114
Q

In Oracle Database, the object type _____.
can define either an individual column or an entire table
can define an entire table only
is not supported
can define an individual column only

A

Can define either an individual column or an entire table

115
Q

Which of the following does NOT appear in the Oracle Database’s CREATE TYPE statement below?

CREATE TYPE NameType AS OBJECT ( … )
Function names and return types
Function body
Property names and types
Procedure names and parameters

A

Function body

116
Q

Given the Oracle Database statement below, what is PlaceType?

CREATE TYPE HomeType UNDER PlaceType (
Bedrooms INT,
Bathrooms INT,
OVERRIDING MEMBER FUNCTION SquareFeet RETURN INT
);
Object that does not use NOT FINAL keywords
Table that implements the PlaceType object
Supertype
Subtype

A

Supertype

117
Q

A big data application generates 20,000 data entries per second. This rate is called what?
Variety
Veracity
Velocity
Volume

A

Velocity

118
Q

To fulfill data processing requirements in a growing transactional database, _____ scales up by increasing processing power of a limited number of systems.
table partitioning
extensive replication
horizontal scaling
vertical scaling

A

Vertical Scaling

119
Q

Which approach splits data sets across multiple systems?
Partitioning
Relaxing
Scaling
Sharding

A

Sharding

120
Q

A NoSQL database that represents data as a key with multiple values is called a _____ database.
document
key-value
graph
wide column

A

wide column

121
Q

A NoSQL database that represents data using XML or JSON is called a _____ database.
wide column
key-value
document
graph

A

document

122
Q

When a key-value database allows multiple values per key, how is each value identified?
By the use of a timestamp.
By using a name for each value.
By assigning a query to each key value.
By assigning more keys.

A

By using a name for each value.

123
Q

What is a characteristic of hash structure in a key-value database?
Databases can shard data across thousands of machines.
Replication for high availability in the event that storage devices fail.
Inconsistency across multiple replicas enables faster writes.
Buckets are stored on different machines, enabling horizontal scaling.

A

Buckets are stored on different machines, enabling horizontal scaling.

124
Q

Which NoSQL database uses tables that consist of a key and a group of items?
Oracle NoSQL
DynamoDB
Redis
SQL

A

DynamoDB

125
Q

Which information would be acceptable in a key-value database?
Key = badge number, value = office
Key = color, value = fruit
Key = car make, value = Ford
Key = part name, value = part number

A

Key = car make, value = Ford

125
Q

A _____ database stores related data as column families.
wide column
key-value
document
graph

A

wide column

126
Q

Which wide-column database has no single point of failure and is always available?
NoSQL
Cassandra
BiTable
HBase

A

Cassandra

127
Q

A wide column database is similar to a relational database except that it does not support _____.
third normal form
primary keys and joins
foreign keys and joins
primary keys and queries

A

foreign keys and joins

128
Q

Within each row of a wide column database, all columns of a family are stored ____ to optimize performance of read queries.
incrementally
decrementally
non-contiguously
contiguously

A

contiguously

129
Q

Strict consistency is enforced in some document databases by directing read queries to _____.
the primary replica
all replicas
the secondary replica
all subsequent replicas

A

the primary replica

129
Q

Which document type is commonly used by document databases?
XML
XLSX
DOCX
SQL

A

XML

130
Q

In a document database, a ________ assigns documents to shards.
replica
join function
range function
key-value

A

range function

131
Q

A document database stores data as _____, while a relational database stores data as _____.
collections, tables
collections, ranges
tables, collections
ranges, tables

A

collections, tables

132
Q

A primary replica has failed in a document database. What happens as a result?
A secondary replica becomes active
A secondary replica synchronizes
All subsequent replicas synchronize
All subsequent replicas become active

A

A secondary replica becomes active

133
Q

A database designer depicts a database as a graph with _____ representing entities.
vertices
properties
edges
links

A

vertices

134
Q

Vertices in a graph database are similar to _____ in a relational table.
keys
rows
columns
Relationships

A

rows

135
Q

Vertices in a graph database are similar to _____ in a relational table. Which language is created specifically for graph databases?
Python
SQL
GraphAccelerator
Gremlin

A

Gremlin

136
Q

Which graph database physical structure might combine a graph and a relational database?
Property
Native
Layered
Vertex

A

Layered

137
Q

________ means each vertex in a graph database contains a pointer to all connected vertices.
Hashing
Referential integrity
Index-free adjacency
Full connectivity

A

Index-free adjacency

138
Q

In the MongoDB query, how is every student EXCEPT Larry selected?

{ name: { _____: _____ } }
$ne, “Larry”
$eq, “Larry”
$!=, “Larry”
$==, “Larry”

A

$ne, “Larry”

138
Q

In a MongoDB shell, what happens when the following command executes?

db.movies.insert({ name: “What About Bob?”, year: 1991 })
The document is not added to the collection without an _id
The MongoDB shell prompts for an _id before adding the document
The document is added to the collection with no _id
The document is added to the collection with a generated _id

A

The document is added to the collection with a generated _id

139
Q

Given the autos collection, complete the statement to return all documents.

db.autos._____({ year: { _____ } })

[
{
“_id” : 100,
“make” : “Ford”,
“model” : “Fusion”,
“year” : 2014,
“price” : 13500
},
{
“_id” : 200,
“make” : “Honda”,
“model” : “Accord”,
“year” : 2013,
“price” : 16900
},
{
“_id” : 300,
“make” : “Dodge”,
“model” : “Avenger”,
“year” : 2012,
“price” : 10800
},
{
“_id” : 400,
“make” : “Toyota”,
“model” : “Corolla”,
“year” : 2013,
“price” : 13400
}
]
find, $gte: 2012
get, $lte: 2013
find, $lte: 2012
get, $gte: 2012

A

find, $gte: 2012

140
Q

What command results in an empty students collection?
db.students.remove({})
db.students.delete()
db.students.removeAll()
db.students.delete({})

A

db.students.remove({})

141
Q

Given the autos collection, what condition sets all sold fields to true?

db.autos.update({ price: {$gte 13500} },
{ _____ }, { multi: true })
$inc: { sold: true }
sold = true
sold: true
$set: { sold: true }

A

$set: { sold: true }

CSC 555 (1 decks)

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