Skip to main content

CS614 Quiz No.1 Shared by Manzar (UnSolved)



Question # 1 of 10 ( Start time: 03:35:24 PM )  Total Marks: 1
MDX by Microsoft is an example of _______
Select correct option:
HOLAP
DOLAP
ROLAP
None of the given options


Question # 2 of 10 ( Start time: 03:36:40 PM )  Total Marks: 1
In decision support system ease of use is achieved by:
Select correct option:
Normalization
Denormalization
Drill up
Drill down


Question # 3 of 10 ( Start time: 03:38:07 PM )  Total Marks: 1
Which of the denormalization technique squeezes master table into detail?
Select correct option:
Pre-joining
Horizontal splitting
Vertical splitting
Adding redundant column


Question # 4 of 10 ( Start time: 03:38:28 PM )  Total Marks: 1
The trade-offs of denormalization is/are:
Select correct option:
Storage
Performance
Ease-of-use
All of the given options


Question # 5 of 10 ( Start time: 03:38:46 PM )  Total Marks: 1
________is usually deployed when expressions can be used to group data together in such a way that access can be targeted to a small set of partitions for a significant portion of the DW workload.
Select correct option:
Expression elimination
Expression partitioning
Expression indexing
None of the given option


Question # 6 of 10 ( Start time: 03:39:49 PM )  Total Marks: 1
Which of the following is NOT an example of derived attribute?
Select correct option:
Age
CGPA
Area of rectangle
Height


Question # 7 of 10 ( Start time: 03:41:00 PM )  Total Marks: 1
Increasing level of normalization _______ number of tables.
Select correct option:
Increases
Decreases
Does not effect
None of the given options


Question # 9 of 10 ( Start time: 03:42:10 PM )  Total Marks: 1
De-normalization affects:
Select correct option:
Database size and query performance
Database Usability and query reliability
Database availability and query success
None of the given options


Question # 10 of 10 ( Start time: 03:43:17 PM )  Total Marks: 1
Table collapsing technique is applied in case of:
Select correct option:
One-to-one relation or many-to-many relation
One-to-many relation
many to many relateion
None of the given options

Comments

Popular posts from this blog

CS504 Quiz No.3 Shared by Angel

Question # 1 of 10 ( Start time: 09:08:01 PM ) Total Marks: 1 Defining the services of an object means: Select correct option: What it does?        ok What it knows? Who knows it? Whome it knows? Question # 2 of 10 ( Start time: 09:08:27 PM ) Total Marks: 1 Which one of these represents the Krutchen’s 4+1 architectural view model? Select correct option: Logical view, Process view, Physical view, Development view, Use case view Logical view, Dynamic view, Physical view, Development view, Use case view Logical view, Process view, Physical view, Development view, Sequence view Dynamic view, Process view, Physical view, Development view, Use case view Question # 3 of 10 ( Start time: 09:09:50 PM ) Total Marks: 1 Return values in Synchronous messages are represented by: Select correct option: A solid line A dotted line with label        ok A solid line with label Double line Question # 4 of 10 ( Start tim...

CS302 Quiz No. 3 File 3

In a 4-bit binary counter, the next state after the terminal count in the DOWN mode is __________ 0000 1111 0001 10000 If S=1 and R=0, then for positive edge triggered flip-flop Q(t+1) = _______ 0 1 invalid Input is invalid In Master-Slave flip-flop setup, the master flip flop operates at ________ Positive half cycle of pulse Negative half cycle of pulse Both Master-Slave operate simultaneously Master-Slave flip-flop does not operate on pulses, rather it is edge triggered. If the S and R inputs of the gated S-R latch are connected together using a ____ gate then there is only a single input to the latch. The input is represented by D instead of S or R (A gated D-Latch) AND OR NOT XOR The minimum time required for the input logic levels to remain stable before the clock transition occurs is known as the _________ Set-up time Hold time Pulse Interval time Pulse Stability time (PST) The 74HC163 is a 4-bit Synchron...