Skip to main content

INF503 Week 6 Quize's

 Skip to main content

INF--503-1D1-SP-2021 - Advanced Database

Started onSunday, February 20, 2022, 11:05 PM
StateFinished
Completed onSunday, February 20, 2022, 11:14 PM
Time taken9 mins 2 secs
Grade19.00 out of 20.00 (95%)

Question 1

Correct
1.00 points out of 1.00
Flag question

Question text

_____ is the central activity during the parsing phase in query processing.
Select one:
a.
Partitioning
b.
Clustering
c.
Query optimization
Correct
d.
Query validation

Feedback

Question 2

Correct
1.00 points out of 1.00
Flag question

Question text

_____ distributed database management systems (DDBMS) integrate multiple instances of the same DBMS over a network.
Select one:
a.
Combination
b.
Homogeneous
Correct
c.
Heterogeneous
d.
Fully heterogeneous

Feedback

Question 3

Correct
1.00 points out of 1.00
Flag question

Question text

_____ fragmentation allows a user to break a single object into two or more segments, or fragments.
Select one:
a.
Horizontal
b.
Request
c.
Data
Correct
d.
Vertical

Feedback

Question 4

Correct
1.00 points out of 1.00
Flag question

Question text

_____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.
Select one:
a.
Data distribution
b.
Network partitioning
c.
Network latency
Correct
d.
Replica transparency

Feedback

Question 5

Correct
1.00 points out of 1.00
Flag question

Question text

_____ transparency allows a physically dispersed database to be managed as though it were centralized.
Select one:
a.
Transaction
b.
Performance
c.
Distribution
Correct
d.
Failure

Feedback

Question 6

Correct
1.00 points out of 1.00
Flag question

Question text

_____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.
Select one:
a.
Local mapping
b.
Fragmentation
c.
Transaction
d.
Location
Correct

Feedback

Question 7

Correct
1.00 points out of 1.00
Flag question

Question text

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.
Select one:
a.
fully homogeneous
b.
homogeneous
c.
fully heterogeneous
Correct
d.
heterogeneous

Feedback

Question 8

Correct
1.00 points out of 1.00
Flag question

Question text

A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.
Select one:
a.
remote transaction
b.
remote request
Correct
c.
distributed request
d.
distributed transaction

Feedback

Question 9

Correct
1.00 points out of 1.00
Flag question

Question text

A _____ request lets a single SQL statement reference data located at several different local or remote DP sites.
Select one:
a.
fragmented
b.
distributed
Correct
c.
transaction
d.
remote

Feedback

Question 10

Correct
1.00 points out of 1.00
Flag question

Question text

A centralized database management is subject to a problem such as _____.
Select one:
a.
dependence on multiple sites
b.
growing numbers of remote locations
Correct
c.
organizational flexibility of the database
d.
maintaining and operating small database systems

Feedback

Question 11

Correct
1.00 points out of 1.00
Flag question

Question text

A database management system needs _____ to prepare the data for presentation to the end user or to an application program.
Select one:
a.
concurrency control
b.
I/O interface
c.
security
d.
formatting
Correct

Feedback

Question 12

Incorrect
0.00 points out of 1.00
Flag question

Question text

_____ refers to the number of different values a column could possibly have.
Select one:
a.
Clustering
b.
Database statistics
Incorrect
c.
Bitmap index
d.
Data sparsity

Feedback

Question 13

Correct
1.00 points out of 1.00
Flag question

Question text

A DBA determines the initial size of the data files that make up the database; however, as required, the data files can automatically expand in predefined increments known as _____.
Select one:
a.
procedure cache
b.
buffer cache
c.
extents
Correct
d.
supplements

Feedback

Question 14

Correct
1.00 points out of 1.00
Flag question

Question text

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.
Select one:
a.
data caches
b.
operation modes
c.
file groups
Correct
d.
procedure caches

Feedback

Question 15

Correct
1.00 points out of 1.00
Flag question

Question text

A(n) _____ is a logical grouping of several data files that store data with similar characteristics.
Select one:
a.
procedure cache
b.
table space
Correct
c.
data cache
d.
listener

Feedback

Question 16

Correct
1.00 points out of 1.00
Flag question

Question text

Automatic query optimization means that the:
Select one:
a.
optimization process is scheduled and selected by the end user or programmer.
b.
database access strategy is defined when the program is executed.
c.
DBMS finds the most cost-effective access path without user intervention.
Correct
d.
optimization takes place at compilation time by the programmer.

Feedback

Question 17

Correct
1.00 points out of 1.00
Flag question

Question text

Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data.
Select one:
a.
reverse index
b.
hash index
c.
sparse index
d.
B-tree index
Correct

Feedback

Question 18

Correct
1.00 points out of 1.00
Flag question

Question text

During the ____ phase, the DBMS retrieves the data and sends the result set back to the client.
Select one:
a.
parse
b.
execute
c.
fetch
Correct
d.
process

Feedback

Question 19

Correct
1.00 points out of 1.00
Flag question

Question text

From the performance point of view, _____ databases eliminate disk access bottlenecks.
Select one:
a.
distributed
b.
index-organized
c.
RAID
d.
in-memory
Correct

Feedback

Question 20

Correct
1.00 points out of 1.00
Flag question

Question text

If there is no index, the DBMS will perform a _____ scan.
Select one:
a.
range
b.
full table
Correct
c.
row ID table access
d.
loop

Feedback

Finish review














































Comments

Post a Comment

Popular posts from this blog

IS5203 Type 2 Post Assessment and Final Quiz

  Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh
Post a Comment
Read more

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand
Post a Comment
Read more

GE5163 Week8 ( Final Exam ) Quize's

  A process or product that is insensitive to normal variation is referred to as being Select one: a. in specification b. capable c. robust d. out of control Feedback Your answer is correct. A completed failure mode and effects analysis (FMEA) results in the following assessment rating.      Occurrence = 4      Severity = 8      Detection = 10 What is the risk priority number (RPN) for this FMEA? Select one: a. 42 b. 22 c. 320 d. 120 Feedback Your answer is correct. In a visual inspection situation, one of the best ways to minimize deterioration of the quality level is to: Select one: a. have a program of frequent eye exams. b. retrain the inspector frequently. c. add variety to the task. d. have a standard to compare against as an element of the operation. Feedback Your answer is correct. Which of the following elements is least necessary to a good corrective action feedback report? Select one: a. What caused the failure b. Who caused the failure c. What correction has been made d. Wh
Post a Comment
Read more