Online Exam Preparation
MCQs Library
Browse subject-wise multiple choice questions, review answers quickly, and start a test from the same section.
Questions
| Code | Question | Option A | Option B | Option C | Option D | Answer |
|---|---|---|---|---|---|---|
| CS403 |
Which Of The Following Is Not An Aggregate Function
|
Avg
|
Sum
|
Upper
|
Max
|
C |
| CS403 |
Which Of The Following Is Not One Of The Properties Of Transaction?
|
Atomicity
|
Consistency
|
Redundancy
|
Durability
|
C |
| CS403 |
Which Of The Following Is Not True About De-Normalization?
|
It Is The Process Of Attempting To Optimize The Performance Of A Database
|
De-Normalization Is A Technique To Move From Lower To Higher Normal Forms Of Database Modeling
|
In De-Normalization It Is Required To Add Redundant Data.
|
It Enhances The Performance Of Db
|
B |
| CS403 |
Which Of The Following Is Not True About Input Forms?
|
Provide An Easy Effective Efficient Way To Enter Data Into A Table
|
Especially Useful When The Person Entering The Data Is Not Familiar With The Inner Workings
|
Provide Different Controls To Add Data Into The Table
|
One Input Forms Can Populate One Table At A Time
|
D |
| CS403 |
Which Of The Following Is Not True Regarding Clustering ?
|
It Increases The Efficiency Since Related Records Are Placed Close To Each Other
|
Clustering Makes Records Difficult To Access
|
Suitable To Relatively Static Situations
|
It Is A Process Which Means To Place Record From Different Tables To Places In Adjacent Physical Locations.
|
B |
| CS403 |
Which Of The Following Is Not True Regarding Clustering?
|
It Increases The Efficiency Since Related Records Are Placed Close To Each Other
|
Clustering Makes Records Difficult To Access
|
Suitable To Relatively Static Situations
|
It Is A Process Which Means To Place Records From Different Tables To Place In Adjacent Physical Locations
|
B |
| CS403 |
Which Of The Following Is Not True Regarding Db Transactions?
|
A Set Of Database Operations That Are Processed Partly
|
A Database Transaction Is A Logical Unit Of Database Operations
|
A Database Transaction Must Be Atomic
|
A Database Transaction Must Contains The Acid Property
|
B |
| CS403 |
Which Of The Following Is Not True Regarding Indexes?
|
Index Can Be Defined Even When There Is No Data In The Table
|
It Can Be Created Using ‘Create Index’ Statement
|
It Support Range Selections
|
It Can Not Be Created On Composite Attributes
|
D |
| CS403 |
Which Of The Following Is Not True With Respect To Denormalization?
|
A Denormalized Data Model Is Not The Same As A Data Model That Has Not Been Normalized
|
Denormalization Takes Place Before The Normalization Process
|
It Is An Attempt To Optimize The Performance Of Database
|
Denormalization Process Can Not Be Initiated Before The Database Design
|
C |
| CS403 |
Which Of The Following Is One Of The Purposes Of Using Ddl Commands?
|
Creating And Destroying Databases
|
Manipulating Databases
|
Updating Records Into Databases
|
Inserting Records Into Databases
|
C |
| CS403 |
Which Of The Following Is One Of The Purposes Of Using Dml Commands?
|
Creating Databases
|
Destroying Databases
|
Inserting Data In Tables
|
Non Of The Above
|
C |
| CS403 |
Which Of The Following Is The Correct Description Of Cache Hit?
|
When Data Is Found In The Cache
|
The Number Of Times The Cache Is Accessed Directly By The Processor
|
When Data Is Removed In The Cache
|
When Data Is Lost From The Cache
|
A |
| CS403 |
Which Of The Following Is The Correct Syntax For Adding A New Column Into An Existing Table
|
Alter Table Table_Name { Alter [Column] Column Type [(Size)] [Default Default] }
|
Alter Table Table_Name { Add [Column] Column Type [(Size)] [Default Default] }
|
Both I And Ii
|
None Of The Above
|
B |
| CS403 |
Which Of The Following Is The Correct Syntax For Adding A New Column Into An Existing Table
|
Alter Table Table_Name { Alter [Column] Column Type [(Size)] [Default Default] }
|
Alter Table Table_Name { Add [Column] Column Type [(Size)] [Default Default] }
|
Both I And Ii
|
None Of The Above
|
C |
| CS403 |
Which Of The Following Is The Correct Syntax For Adding A New Column Into An Existing Table?
|
Alter Table Table_Name { Alter [Column] Column Type [(Size)] [Default Default] }
|
Alter Table Table_Name { Add [Column] Column Type [(Size)] [Default Default] }
|
Both I And Ii
|
None Of The Above
|
B |
| CS403 |
Which Of The Following Is The Correct Way To Find Out The Size Of Cartesian Product Incase Of Cross Join?
|
The Number Of Columns In The First Table Multiplied By The Number Of Columns In The Second Table
|
The Number Of Columns In The First Table Multiplied By The Number Of Rows In The Second Table
|
The Number Of Rows In The First Table Multiplied By The Number Of Columns In The First Table
|
The Number Of Rows In The First Table Multiplied By The Number Of Rows In The Second Table
|
D |
| CS403 |
Which Of The Following Is True About Delete Command?
|
Is Ddl Command
|
Resets Identity Of The Table
|
Cannot Activate A Trigger
|
Can Be Rolled Back
|
A |
| CS403 |
Which Of The Following Is True About Truncate?
|
Can Be Rolled Back
|
Activates Triggers
|
Is Dml Command
|
Resets Identity Of The Table
|
D |
| CS403 |
Which Of The Following Is Used To Add Or Drop Columns In An Existing Table?
|
Alter
|
Having
|
Select
|
Then
|
A |
| CS403 |
Which Of The Following Is Used To Filter Rows According To Some Condition(S)?
|
Select
|
From
|
Where
|
Update
|
C |