CS101 532 CS201 225 CS301 232 CS302 174 CS304 192 CS401 224 CS402 258 CS403 228 CS408 113 CS411 121 CS502 249 CS504 268 CS601 679 CS604 381 CS605 261 CS607 184 CS609 230 CS610 300 CS614 100 CS703 65
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