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 |
After Creating The Initial Erd Segments The Next Step Is To
|
Define The Major Transaction Modules
|
Perform The Appropriate Normalization Checks Based On The Data Dictionary Contents
|
Create A Basic Data Dictionary For All The Components Found In Each Erd Segment
|
Define The Entities Attributes Relationships Connectivities Cardinalities And Constraints.
|
C |
| CS403 |
Alter Table Exams Rename Column Q_Description To Question_Descp Std_Id To Student_Id. Syntax Of Alter Table Is Not Correct.
|
True
|
False
|
B | ||
| CS403 |
Alter Table Exams Rename Column Q_Description To Question_Descp Std_Id To Student_Id. Syntax Of Alter Table Is Not Correct.
|
True
|
False
|
B | ||
| CS403 |
An Attribute Y May Be Functionally Dependent On (I) A Composite Attribute X Y (Ii) A Single Attribute X (Iii) No Attribute
|
I And Ii
|
I And Iii
|
Ii And Iii
|
Iii
|
A |
| CS403 |
An Entity Can Be Logically Connected To Another By Defining A .
|
Hyperlink
|
Common Attribute
|
Primary Key
|
Superkey
|
B |
| CS403 |
An Entity Type Is
|
Defined When The Database Is Actually Constructed
|
A Specific Type Such As An Integer Text Date Logical Etc
|
A Coherent Set Of Similar Objects That We Want To Store Data On (E.G. Student Course Car)
|
Defined By The Database Designer
|
B |
| CS403 |
An Instance Is
|
A Particular Occurance Of An Entity
|
A Special Type Of Relation
|
An Attribute Of An Entity
|
Any Particular Entity
|
A |
| CS403 |
Browser Based Forms Are Developed In The Following Tools Except
|
Html
|
Scripting Language
|
Front Page
|
Web-Based Forms
|
D |
| CS403 |
Columns Used To Uniquely Identify Individual Rows Of A Given Table May Be Specified To Be Not Not Null
|
True
|
False
|
B | ||
| CS403 |
Consider A Table Named “Emp” Having Fields Empname Empid Age Salary. Which Of The Following Is True If The Following Sql Statement Tries To Execute? Select * From Emp Where Empname=’Ali’ Orderby Age; The Statement Has A Syntax Error
|
The Statement Displays The Entire Fields From Emp In Which The Empname Is Ali In Any Order
|
The Statement Displays The Entire Fields From Emp In Which The Empname Is Ali In Descending Order Of Their Age
|
The Statement Displays The Entire Fields From Emp In Which The Empname Is Ali In Ascending Order Of Their Age
|
None Of The Above
|
A |
| CS403 |
Consider The Following Statements. A. An Entity Integrity Constraint States That No Primary Key Value Can Be Null B. A Referential Integrity Constraint Is Specified Between Two Relations C. A Foreign Key Cannot Be Used To Refer To Its Own Relation.
|
Only A
|
Only B
|
Only B And C
|
Only A And B
|
A |
| CS403 |
Consider Two Sets A And B. A Contains 2 Elements And B Contains 3. How Many Elements Do Their Cartesian Product
|
6
|
9
|
5
|
4
|
A |
| CS403 |
Controlling Redundancy In A Database Management System Does Not Help To
|
Avoid Duplication
|
Avoid Unnecessary Wastage Of Storage Space
|
Avoid Unauthorised Access To Data
|
Avoid Inconsistency Among Data
|
C |
| CS403 |
Create Table And Create Index Belongs To Which Type Of Sql Commands
|
Dml
|
Ddl
|
Dcl
|
Dql
|
B |
| CS403 |
Data About Data Is Database
|
True
|
False
|
F | ||
| CS403 |
Data About Data Is Metadata
|
True
|
False
|
A | ||
| CS403 |
Data Manipulation Language (Dml) Is The Set Of Commands Used To Maintain And Query A Database Including Updating Inserting Modifying And Retrieving Data
|
True
|
False
|
A | ||
| CS403 |
Data Redundancies Produce Unusual And Undesirable Data Management Problems Caused By __________
|
Transitive Requirements
|
Dependencies
|
Normalization
|
Data Anomalies
|
D |
| CS403 |
Data Redundancy Means
|
Security Of Data
|
Duplication Of Data
|
Management Of Data
|
Recovery Of Data
|
B |
| CS403 |
Database Management Systems Operating Systems Applications And Utilities Are All Examples Of __________
|
Hardware
|
Software
|
Computer Infrastructure
|
Input And Output
|
B |