|
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 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 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 Statements Best Describes The Use Of Freestanding Macros?
|
They Are Best Used For Conditional Statements
|
They Are Best Used For Menu Items
|
They Are Best Used To Enter Temporary Values In A Form
|
Do Not Use Freestanding Macros
|
D
|
|
CS403
|
__________ User Interface Is Preferred Over __________ User Interface With Respect To User
|
Easy To Understand Efficient
|
Hard To Understand Efficient
|
Easy To Understand Effective
|
Hard To Understand Effective
|
A
|
|
CS403
|
Which Model Operates At The Lowest Level Of Abstraction?
|
Conceptual
|
Internal
|
External
|
Physical
|
D
|
|
CS403
|
Which Of The Following Justifies The Inclusion Of Derived Attributes In A Database?
|
Inclusion Of Derived Attributes Is A Standard Procedure And Does Not Require Justification
|
Derived Attributes Should Be Used When They Add To Design Elegance
|
Query Speed Is Enhanced By Not Computing Derived Attributes
|
Poor Design Is The Only Excuse For The Inclusion Of Derived Attributes
|
C
|
|
CS403
|
Select North Customer From Cust_Dtls Where Region = N Order By Customer Union Select East Customer From Cust_Dtls Where Region = E Order By Customer
|
Has An Error - The String Should Be In Double Quotes
|
Has An Error - Order By Clause
|
Does Not Have An Error
|
Has An Error - The String In Single Quotes North And south
|
A
|
|
CS403
|
Truncate Command Responses Time Is __________ As Compared To Delete Command
|
Poor
|
Same
|
Better
|
Worst
|
C
|
|
CS403
|
Dml Does Not Used To
|
Add New Rows To Tables
|
Retrieve Row From Tables
|
Modify The Rows Of Tables
|
Alter A Table Definition
|
D
|
|
CS403
|
What Does The Abbreviation Dbms Stand For?
|
Database Manipulation Software
|
Data Borrowing And Movement Software
|
Digital Base Mapping System
|
Database Management System
|
D
|
|
CS403
|
What Happens If The Where Clause Is Omitted From A Delete Statement?
|
All Records From The Table Are Deleted
|
No Record From The Table Will Be Deleted
|
First Record Of The Table Will Be Deleted
|
The Statement Will Not Be Executed And Will Give A Syntax Error
|
A
|
|
CS403
|
A Entity Has A Primary Key That Is Partially Or Totally Derived From The Parent Entity In The Relationship
|
Strong
|
Weak
|
Business
|
Relationship
|
B
|
|
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
|
Query Analyzer Is Used To Practice Sql In Ms-Access And Ms-Sql Server.
|
True
|
False
|
|
|
A
|
|
CS403
|
Which Of The Following Is Used To Filter Rows According To Some Condition(S)?
|
Select
|
From
|
Where
|
Update
|
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 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
|
Materialized Views And Indexes Are Not Similar By The Following Way(S)
|
They Consume Storage Space
|
They Must Be Refreshed When The Data In Their Master Tables Changes
|
They Can Be Accessed Directly Using A Select Statement
|
All Of The Given
|
C
|
|
CS403
|
Which Of The Following Statements Are Data Definition Language Commands?
|
Insert
|
Update
|
Grant
|
Truncate
|
D
|