|
CS403
|
In Sql Which Command Is Used To Delete Rows From Table
|
Delete
|
Remove
|
Truncate
|
Both I And Ii
|
A
|
|
CS403
|
You Want Month Names To Be Sorted In Order (Jan Feb Mar Etc.) When They Appear On A Report. What Do You Need To Do?
|
Sort By Month Name
|
Sort By Month Number
|
Define The Field With The Data Type Month And Sort Ascending
|
Define The Field With The Data Type Month And Sort Descending
|
B
|
|
CS403
|
What Is The Difference Between A Dbms And An Rdbms?
|
A Rdbms Uses Metadata While A Dbms Does Not
|
A Dbms Is Used For Data Warehousing
|
Because A Relational Database Is More Complicated Than A Conventional Database The Rdbms Requires Much More Computing Power Than The Conventional Dbms Requires
|
Because A Conventional Database Is Less Complicated Than A Relational Database The Dbms Is Used More Often For Transactional Databases
|
C
|
|
CS403
|
In “One To Many” Cardinality One Instance Of A Relation Is Mapped With
|
Many Instances Of Second Entity Type
|
One Instance Of Second Entity Type
|
Primary Key Of 2 Relations
|
None Of Above
|
A
|
|
CS403
|
Which Of The Following Is Not A Part Of An Insert Statement?
|
Into
|
Value
|
Insert
|
Modify
|
D
|
|
CS403
|
Sql Data Types Do Not Have Support For Storing Multi-Media Objects Directly
|
True
|
False
|
|
|
A
|
|
CS403
|
Macros Are Best Placed In Logical Modules Known As
|
Macro Sets
|
Macro Groups
|
Code Sets
|
Modules
|
B
|
|
CS403
|
Which Of The Fllowing Clauses Allows To Sort The Records In Result Set?
|
Where
|
Order By
|
From
|
Having
|
B
|
|
CS403
|
A Table Can Be Logically Connected To Another Table By Defining A __________
|
Hyperlink
|
Common Attribute
|
Primary Key
|
Superkey
|
B
|
|
CS403
|
Which Of The Following Statements Creates A Database Named Company
|
Create Database Company
|
Create Db Company
|
Add Database Copmany
|
Create Company Database
|
A
|
|
CS403
|
What Standard Must A Basic Html-Based Web Page Conform To?
|
Tcp/Ip
|
Ascii
|
Xml
|
Sql
|
B
|
|
CS403
|
You Have Created A Table In Access But Not Yet Designated A Pk. What Happens If You Save The Table Now?
|
The Save Fails Because No Pk Is Defined
|
The Save Works As Usual
|
Access Warns You That No Primary Key Is Defined And Forces You To Define A Pk Before Saving
|
Access Warns You That No Primary Key Is Defined But Lets You Save The Table If You Want To
|
D
|
|
CS403
|
User Rights Information Is Stored In
|
Physical Database
|
Catalog
|
Logical Database
|
Buffer
|
A
|
|
CS403
|
Which Of The Following Is Not True Regarding Indexes?
|
Index Can Be Defined Even When There Is No Data In The Table
|
It Can Be Created Using ‘Create Index’ Statement
|
It Support Range Selections
|
It Can Not Be Created On Composite Attributes
|
D
|
|
CS403
|
Which Feature Of Database Provides Conversion From Inconsistent State Of Db To A Consistent State Ensuring Minimum Data Loss?
|
User Accessible Catalog
|
Data Processing
|
Authorization Service
|
Recovery Service
|
D
|
|
CS403
|
Which Of The Following Might Be Represented With A Single-Valued Attribute?
|
Persons Phone Number
|
Cars Color
|
Employees Educational Background
|
Computers Processor Speed
|
D
|
|
CS403
|
Whats The Maximum Number Of Different Fields That Can You Sort In The Page Wizard?
|
1
|
2
|
3
|
4
|
D
|
|
CS403
|
Which Of The Following Is Not True With Respect To Denormalization?
|
A Denormalized Data Model Is Not The Same As A Data Model That Has Not Been Normalized
|
Denormalization Takes Place Before The Normalization Process
|
It Is An Attempt To Optimize The Performance Of Database
|
Denormalization Process Can Not Be Initiated Before The Database Design
|
C
|
|
CS403
|
Update Command Belong To Which Type Of Classification
|
Dml
|
Ddl
|
Dcl
|
Dql
|
A
|
|
CS403
|
What Macro Will Be Executed Automatically When You Open The Database?
|
Autoexec
|
Autostart
|
Startup
|
Autorun
|
A
|