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