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

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 t...
Post a Comment
Read more

GE5093 Design Thinking All Quizzes

  GE---5093-1D2-FA-2021 - Design Thinking Home My courses 2021-FA GE---5093-1D2-FA-2021 Week 1 Reading Quiz 1 Started on Sunday, October 31, 2021, 2:04 PM State Finished Completed on Sunday, October 31, 2021, 2:30 PM Time taken 25 mins 58 secs Grade 8.00  out of 10.00 ( 80 %) Top of Form Question  1 Correct 1.00 points out of 1.00 Flag question Question text A critical finding of Edward Lorenz related to Design Thinking was: Select one: a. An application of the caterpillar effect b. The idea of deterministic chaos or the "Butterfly Effect" c. Business leaders enjoy chaos d. Statistical modeling of weather was fairly accurate in the long term Feedback Your answer is correct. The correct answer is: The idea of deterministic chaos or the "Butterfly Effect" Question  2 Incorrect 0.00 point...
Post a Comment
Read more

IS5213 Data Science and Big Data Solutions

WEEK- 2 code  install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf)                        str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>%    summarise(total_count=n(),             .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1.  In the Insurance data set, how many Lawyers are there? A).  1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A).  204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7   1. What...
Post a Comment
Read more