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 A Feature Of Check Constraint? Limit The Values That Can Be Placed In A Column Used To Enforce Referential Integrity Enforces The Uniqueness Of The Values In A Set Of Columns Is A Unique Identifier For A Row Within A Database Table D
CS403 Which Of The Following Is A Service Provided By A Dbms? It Ensures And Enforces Data Integrity At All Levels It Maintains An Environment In Which Security Is Created And Enforced It Manages The Metadata In The Data Dictionary All Of The Above Are Services Of A Dbms D
CS403 Which Of The Following Is A String Function In Sql Count Len Sqrt Sin B
CS403 Which Of The Following Is A String Function In Sql Count Len Sqrt Sin B
CS403 Which Of The Following Is Advantage Of Re-Hashing Technique To Handle The Collisions? Collisions Don’T Use Primary Table Space Unlimited Number Of Elements Fast Access Through Use Of Main Table Space Overhead Of Multiple Linked Lists C
CS403 Which Of The Following Is An Advantage Of Having A Precisely Written Set Of Current Operations It Clarifies The Assignment Of Data Types It Highlights The Best Possible Way To Perform Each Task It Forces Careful Assessment Of The Procedures It Makes The Creation Of The Data Dictionary Much Easier C
CS403 Which Of The Following Is An Example Of Volatile Memory? Ram Rom Flash Memory Cpu A
CS403 Which Of The Following Is Correct Regarding Dataflow Diagram? Single Dfd Is Required To Represent A System Created At Increasing Levels Of Detail The Dataflow Must Be Bidirectional Used To Represent The Relationships Among The External Entities A
CS403 Which Of The Following Is Incorrect About Alter Table Statement? Cannot Be Used To Modify Type Or Size Of An Existing Column Can Be Used To Delete A Column Can Not Be Used To Create A New Table Can Be Used To Add Column In The Existing Table A
CS403 Which Of The Following Is Incorrect About Views? It Is Not Possible To Left Out The Data Which Is Not Required For A Specific View A Database View Displays One Or More Database Records On The Same Page Views Can Be Used As Security Mechanisms Views Are Generally Used To Focus The Perception Each User Has Of The Database A
CS403 Which Of The Following Is Incorrect Statement Concerning The Database Design Process? During Requirements Collection And Analysis Phase One Can Gather The Data Requirements Of Database Users By Referring To A High Level Data Model It Is Possible To Understand The Data Requirements Of The Users Entity Types Relationships And Constraints Transformation Of The High Level Data Model Into The Implementation Data Model Is Called Logical Design Or Data Model Mapping During The Logical Design Phase Of Internal Storage Structures Access Paths And File Organization For The Database Files Are Specified D
CS403 Which Of The Following Is Incorrect With Respect To Indexed Sequential Files? New Records Are Added To An Overflow File Record In Main File That Precedes It Is Updated To Contain A Pointer To The New Record The Overflow Is Merged With The Main File During A Batch Update Multiple Indexes For The Same Key Field Cannot Be Setup D
CS403 Which Of The Following Is Not A Component Of A Dfd? Dataflow Datastore External Entities Relationship Between External Entities D
CS403 Which Of The Following Is Not A Ddl Command? Create Db Create Table Delete Drop C
CS403 Which Of The Following Is Not A Feature Of Context Dfd? One Process (Which Represents The Entire System) All Sources/Sinks (External Entities) Data Flows Linking The Process To The Sources And Sinks (External Entities) Sub-Processes (Which Explain And Decomposed The Major Process Into Small Processes) D
CS403 Which Of The Following Is Not A Feature Of Indexed Sequential Files? Records Are Stored In Sequence And Index Is Maintained Dense And Nondense Types Of Indexes Are Maintained Track Overflows And File Overflow Areas Can Not Be Ensured Cylinder Index Increases The Efficiency C
CS403 Which Of The Following Is Not A Feature Of Transaction? Users Should Be Able To Regard The Execution Of Each Transaction As Atomic Each Transaction Run By Itself Must Preserve The Consistency Of The Database Dependant On Other Concurrent Transactions D
CS403 Which Of The Following Is Not A Form Of Optical Disk? Cd Rom Worm Erasable Optical Eeprom D
CS403 Which Of The Following Is Not A Part Of An Insert Statement? Into Value Insert Modify D
CS403 Which Of The Following Is Not An Advantage Of A Menu Driven Database System? Help Make The Database Applications System User-Friendly By Eliminating The Need To Remember Command Languages Provide Security Though User-Level Logins Control Access By Providing Only Those Options That Allow People To Do Their Jobs Create An Environment That Is Tailored To Specific Types Of Applications And End Users B