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 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 |