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 Levels Are Mostly Used For Detailed Dfd? Level-0 Level-1 Level-1 Level-2 Level-2 Level-3 Level-3 Level-4 A
CS403 Which Model Operates At The Lowest Level Of Abstraction? Conceptual Internal External Physical D
CS403 Which Model Operates At The Lowest Level Of Abstraction? Conceptual Internal External Physical D
CS403 Which Of Following Is Not Generally The Aim Of Data Partitioning And Placement Of Data? Reduce Workload Balance Workload Merging Different Relations Speed Up Rate Of Useful Works C
CS403 Which Of The Fllowing Clauses Allows To Sort The Records In Result Set? Where Order By From Having B
CS403 Which Of The Following Accurately Describes A Crosstab Query? Crosstab Queries Have Very Limited Summary Capabilities Crosstab Queries Are Seldom Used To Generate Reports If You Select Row Totals In The Crosstab Query You Cannot Also Select Column Totals You Can Select Row Totals And Also Column Totals C
CS403 Which Of The Following Accurately Describes Workgroup Files? You Can Only Create One Workgroup File Per Computer You Can Create Many Workgroup Files But You Can Use Only One Workgroup File At A Time You Can Create Many Workgroup Files And You Can Use More Than One Workgroup File At A Time You Can Create Many Workgroup Files But Are Limited To Using Two At A Time B
CS403 Which Of The Following Are Not Functions Of Forms? Forms Are Used To Tie Together The Database Components Through Menu Structures Forms Extend Data Validation Rules Through Queries Value Lists And Other Input Control Devices Forms Are Used To Enter New Data And To Edit Existing Data Forms Program And Control User Responses D
CS403 Which Of The Following Are The General Activities Which Are Performed During The Development Of Application Programs? Data Input Programs Editing Display All Of Given D
CS403 Which Of The Following Best Describes A Macro? An Sql Script An Instruction Or A Set Of Instructions That Triggers One Or More Actions A Vba Program A Detailed Set Of Actions That Access Will Invoke Whenever A Mouse Click Occurs B
CS403 Which Of The Following Can Not Be Included Into Create Table Statement? Data Types Constraints Attributes Cardinalities D
CS403 Which Of The Following Concepts Is Applicable With Respect To 2Nf? Full Functional Dependency Any Kind Of Dependency Transitive Dependency Non-Transitive Dependency A
CS403 Which Of The Following Constraints Enforces Entity Integrity? Primary Key Foreign Key Check Not Null A
CS403 Which Of The Following Correctly Describes The Relationship Between Forms And Tables? A Form Is Based On Exactly One Table. The Table Must Exist Before The Form Is Created A Form Is Based On Exactly One Table. The Table May Be Created Before Or After The Form Is Created A Form May Be Based On One Or More Tables. The Table(S) Must Exist Before The Form Is Created A Form May Be Based On One Or More Tables. The Table(S) May Be Created Before Or After The Form Is Created C
CS403 Which Of The Following Describes A Database System? A Collection Of Stored Operational Data Used By The Application System Of Some Particular Enterprise A Shared Collection Of Logically Related Data (And A Description Of This Data) Designed To Meet The Information Needs Of An Organisation A Collection Of Stored Data Organised In Such A Way That All User Requirements Are Satisfied By The Database. In General There Is Only One Copy Of Each Item Of Data Although There May Be Controlled Repetition Of Some Data All Of The Above C
CS403 Which Of The Following Describes The Job Of A Database Administrator? Development Implementation Operation Of The Physical Database Creation Of The System Catalog Monitoring And Controlling Database Security And Authorization: Setting Up Controls To Ensure The Quality And Integrity Of Data All Of The Above C
CS403 Which Of The Following Function Falls In The Category Of Aggregate Functions Sum Min Max All Of The Above D
CS403 Which Of The Following Functions Are Not Performed By A Database Administrator? Planning Designing And Implementing Database Systems Establishing Standards And Procedures For Database Systems Communicating With Database Users Allocation Of Storage Locations And Data Structures A
CS403 Which Of The Following Gives All The Fields From Employee Table Named As Emp? Select * From Emp; Select Emp* From Emp Select Emp_Id Where Emp; Select * Where Emp; A
CS403 Which Of The Following Is A Correct Way Of Selecting All The Columns From A Table Called Persons? Select From * Persons Select * From Persons Select * Where Persons Select Where * Persons B