|
CS403
|
What Criteria Matches Dates From January 1 1996 To The Present?
|
>= 01/01/1996
|
>= 01/01/1996
|
>= #01/01/1996#
|
>= 01/01/1996
|
C
|
|
CS403
|
What Action Hides Or Shows The Results Of A Macro While It Runs
|
Reveal
|
Echo
|
Hide
|
Show
|
B
|
|
CS403
|
Which Of The Following Statements Are Data Definition Language Command?
|
Insert
|
Update
|
Grant
|
Truncate
|
D
|
|
CS403
|
Which Of The Following Is Not True About Input Forms?
|
Provide An Easy Effective Efficient Way To Enter Data Into A Table
|
Especially Useful When The Person Entering The Data Is Not Familiar With The Inner Workings
|
Provide Different Controls To Add Data Into The Table
|
One Input Forms Can Populate One Table At A Time
|
D
|
|
CS403
|
Sql Is Used For:
|
Creating Managing And Deleting Tables And Manage The Relationships Among The Stored Date
|
Generating Queries Organizing Managing And Retrieving Data Stored In A Database
|
Maintaining Data Integrity And Coordinate Data Sharing
|
All Of The Above
|
D
|
|
CS403
|
Which One Is The Corrected Way To Implement M To M Relation Which Designing Data Base
|
Using Junction Table With Keys
|
By Splitting Data Into Tables With Pk And Fk
|
As A Single Table Rarly As To Tables With Pk And Fk
|
By Creating Three Tables And Linking Them Through Pk And Fk
|
A
|
|
CS403
|
Normalization Of Database Is Essential To
|
(I) Avoid Accidental Deletion Of Required Data When Some Data Is Deleted Ii) Eliminate Inconsistencies When A Data Item Is Modified In The Database
|
(I) Avoid Accidental Deletion Of Required Data When Some Data Is Deleted (Iii) Allows Storage Of Data In A Computer’S Disk
|
(I) Avoid Accidental Deletion Of Required Data When Some Data Is Deleted (Iv) Use A Database Management System
|
(Ii) Eliminate Inconsistencies When A Data Item Is Modified In The Database (Iv) Use A Database Management System
|
A
|
|
CS403
|
Within A Table Each Primary Key Value
|
Is A Minimal Superkey
|
Is Always The First Field In Each Table
|
Must Be Numeric
|
Must Be Unique
|
D
|
|
CS403
|
Identify The Constraint That Limits The Values That Can Be Placed In A Column
|
Not Null
|
Check
|
Foreign Key
|
Unique
|
A
|
|
CS403
|
A Collection Of Concepts That Can Be Used To Describe The Structure Of A Database
|
Database
|
Dbms
|
Data Model
|
Data
|
B
|
|
CS403
|
Which Of The Following Is Used To Retrieve And Insert Information From Database?
|
Dml
|
Ddl
|
Dcl
|
Both Dml And Ddl
|
A
|
|
CS403
|
Sql Stands For __________. I – Structured Query Language Ii – Standard Query Language Lll- Status Query Language
|
Only I
|
Only Ii
|
Only Lll
|
Both I And Ii
|
A
|
|
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
|
The Main Software Package That Supports A Database Management Approach Is Called
|
Data Dictionary
|
Report Generator
|
Database Management System
|
Distributed Database
|
C
|
|
CS403
|
Which Of The Following Types Of Partitioning Reduces The Chances Of Unbalanced Partitions?
|
Vertical
|
List
|
Hash
|
Range
|
C
|
|
CS403
|
In A Database Security Environment A Form Table Query Report Macro Or Module In The Database Is A(N)
|
Object
|
Permission
|
Operation
|
Group
|
A
|
|
CS403
|
A Software Package Designed To Store And Manage Databases
|
Database
|
Dbms
|
Data Model
|
Data
|
B
|
|
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
|
The Entity Relation Model Models
|
Entities Relationships And Processes
|
Entities And Relationships
|
Relationships
|
Entities
|
C
|
|
CS403
|
Suppose There Are 8 Rows And 4 Columns In Table1 And 3 Rows And 4 Coulmns In Table2; What Is The Size Of The Cartesian Product Incase Of Cross Join Between These Two Tables?
|
32
|
12
|
16
|
24
|
D
|