|
CS403
|
Emp_Dob Holds Employee Birth Dates. Which Format Will Display The Month In Number Format Such As 01 Or 11?
|
Month: Format([Emp_Dob] M)
|
Month: Format([Emp_Dob] Mm)
|
Month: Format([Emp_Dob] Mmm)
|
Month: Format([Emp_Dob] Mmmm)
|
B
|
|
CS403
|
Only One Type Of Constraint Can Be Enforced In Any Table By Create Command
|
True
|
False
|
|
|
A
|
|
CS403
|
Which Of The Following Is A String Function In Sql
|
Count
|
Len
|
Sqrt
|
Sin
|
B
|
|
CS403
|
Which Cannot Be Dragged To A Data Access Page Using The Controls Wizard?
|
Tables
|
Controls
|
Macros
|
Queries
|
C
|
|
CS403
|
Which Key Word Is Available In Sql To Enforce Referential Integrity?
|
Check
|
Primary Key
|
Set Default
|
Unique
|
B
|
|
CS403
|
In An Erd The Focus Is On The And The Relationships Between Them
|
Attributes
|
Entities
|
Keys
|
Indexes
|
B
|
|
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 Used With Insert Command To Insert Values In A Db Table?
|
Onto
|
Into
|
Upto
|
With
|
B
|
|
CS403
|
How Many Clustered Index(Es) Do Each Database Table Have?
|
2
|
3
|
5
|
1
|
D
|
|
CS403
|
Update Command Belongs To Which Type Of Classification
|
Dml
|
Ddl
|
Dcl
|
Dql
|
A
|
|
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
|
The ___________ Function Helps Reduce The Need To Use Mutiple Or Conditions
|
In
|
Like
|
And
|
Between
|
A
|
|
CS403
|
In “One To One Relationship” One Instance Of First Entity Type Is Mapped With Two Instances Of Second Entity Type
|
True
|
False
|
|
|
A
|
|
CS403
|
Identify The Language Which Is Used To Specify Database Schema
|
Dcl
|
Dml
|
Ddl
|
Non Of The Above
|
D
|
|
CS403
|
Which Of The Following Is Not True Regarding Clustering?
|
It Increases The Efficiency Since Related Records Are Placed Close To Each Other
|
Clustering Makes Records Difficult To Access
|
Suitable To Relatively Static Situations
|
It Is A Process Which Means To Place Records From Different Tables To Place In Adjacent Physical Locations
|
B
|
|
CS403
|
Objective Of An Order By Clause Is To Display Or Arrange Output Of A Select Statement In A Particular Order
|
True
|
False
|
|
|
A
|
|
CS403
|
What Does Access Use To Handle Sql Code Generation?
|
Sql For
|
Query Code Generator
|
Query By Example
|
Sql Compiler
|
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
|
A__________Is Used To Maintain A Connection Between The Users Of The Database System
|
Mail Server
|
File Server
|
Client-Server
|
None Of The Given
|
B
|
|
CS403
|
Which Of The Following Is Used To Add Or Drop Columns In An Existing Table?
|
Alter
|
Having
|
Select
|
Then
|
A
|