MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 72
sec(s)
Question # 1 of 10 ( Start time: 08:00:51 PM ) Total Marks: 1
The STAR schema used for data design is a __________ consisting of fact and dimension tables.
Select correct option:
Network model
Relational model
Hierarchical data model
None of the given
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 55
sec(s)
Question # 2 of 10 ( Start time: 08:01:22 PM ) Total Marks: 1
The input to the data warehouse can come from OLTP or transactional system but not from other third party database.
Select correct option:
True
False
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 56
sec(s)
Question # 3 of 10 ( Start time: 08:02:04 PM ) Total Marks: 1
A single database, couldn’t serve both operational high performance transaction processing and DSS, analytical
processing, all at the same time.
Select correct option:
True
False
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 81
sec(s)
Question # 4 of 10 ( Start time: 08:02:43 PM ) Total Marks: 1
The users of data warehouse are knowledge workers in other words they are _________ in the organization.
Select correct option:
DWH Analyst
Decision maker
Database Administrator
Manager
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 76
sec(s)
Question # 5 of 10 ( Start time: 08:03:01 PM ) Total Marks: 1
In _________ system, the contents change with time.
Select correct option:
OLTP
OLTP
ATM
DSS
OLAP
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 72
sec(s)
Question # 6 of 10 ( Start time: 08:03:19 PM ) Total Marks: 1
Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign
key structure within the data model.
Select correct option:
Only One Direction
Any Direction
Two Direction
None of these
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 44
sec(s)
Question # 7 of 10 ( Start time: 08:03:46 PM ) Total Marks: 1
The need to synchronize data upon update is called
Select correct option:
Data Imitation
Data Manipulation
Data Replication
Data Coherency
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 76
sec(s)
Question # 8 of 10 ( Start time: 08:04:40 PM ) Total Marks: 1
Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as
Select correct option:
Distributed Systems Architecture
Legacy Systems Architecture
Online Systems Architecture
Intranet Systems Architecture
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 83
sec(s)
Question # 9 of 10 ( Start time: 08:05:02 PM ) Total Marks: 1
_______ is an application of information and data.
Select correct option:
Knowledge
Intelligence
Power
Education
Click here to Save Answer & Move to Next Question
MC090406557 : Nadia Parveen
Quiz Start Time: 08:00 PM
Time Left 79
sec(s)
Question # 10 of 10 ( Start time: 08:05:19 PM ) Total Marks: 1
It is observed that every year the amount of data recorded in an organization
Select correct option:
Doubles
Remains same as previous year
Triples
Quartiles
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 54
sec(s)
Question # 1 of 10 ( Start time: 08:13:03 PM ) Total Marks: 1
________ gives total view of an organization
Select correct option:
OLAP
OLTP
Data Warehouse
Database
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 79
sec(s)
Question # 2 of 10 ( Start time: 08:14:11 PM ) Total Marks: 1
Ad-hoc access means to run such queries which are known already.
Select correct option:
True
False
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 82
sec(s)
Question # 3 of 10 ( Start time: 08:14:32 PM ) Total Marks: 1
It is observed that every year the amount of data recorded in an organization
Select correct option:
Doubles
Remains same as previous year
Triples
Quartiles
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 76
sec(s)
Question # 4 of 10 ( Start time: 08:14:57 PM ) Total Marks: 1
The input to the data warehouse can come from OLTP or transactional system but not from other third party database.
Select correct option:
True
False
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 83
sec(s)
Question # 5 of 10 ( Start time: 08:15:17 PM ) Total Marks: 1
A single database, couldn’t serve both operational high performance transaction processing and DSS, analytical
processing, all at the same time.
Select correct option:
True
False
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 56
sec(s)
Question # 6 of 10 ( Start time: 08:15:31 PM ) Total Marks: 1
Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .
Select correct option:
Linear
Quadratic
Exponential
Logarithmic
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Time Left 75
sec(s)
Quiz Start Time: 08:12 PM
Question # 7 of 10 ( Start time: 08:16:09 PM ) Total Marks: 1
Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as
Select correct option:
Distributed Systems Architecture
Legacy Systems Architecture
Online Systems Architecture
Intranet Systems Architecture
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 82
sec(s)
Question # 8 of 10 ( Start time: 08:16:33 PM ) Total Marks: 1
Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign
key structure within the data model.
Select correct option:
Only One Direction
Any Direction
Two Direction
None of these
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 60
sec(s)
Question # 9 of 10 ( Start time: 08:16:45 PM ) Total Marks: 1
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole
process of hardware and software architecture.
Select correct option:
Relaxed
Good
Not Relaxed
None
Click here to Save Answer & Move to Next Question
MC090406319 : Tayyaba Hameed
Quiz Start Time: 08:12 PM
Time Left 76
sec(s)
Question # 10 of 10 ( Start time: 08:17:20 PM ) Total Marks: 1
The STAR schema used for data design is a __________ consisting of fact and dimension tables.
Select correct option:
Network model
Relational model
Hierarchical data model
None of the given
Click here to Save Answer & Move to Next Question

Sponsored Links