CS403
|
What Is Required To Establish A 1:1 Relationship Between Two Tables That Do Not Contain A Supertype And Subtype?
|
:1 Relationships Are Only Possible If The Tables Contain A Supertype And Subtype
|
Make Sure That The Pk In The Related Table Has Unique Values
|
Make Sure That The Fk In The Related Table Has An Index Property That Specifies Unique Values
|
Nothing Special Is Required
|
C
|
CS403
|
What Does The Wildcard ? Match?
|
Zero Or More Of The Preceding Character
|
Any One Character In The Position Held By The ?
|
Multiple Characters In The Position Held By The ?
|
Any Letter In The Position Held By The ?
|
B
|
CS403
|
You Want To Create A Composite Pk Using The First And Third Fields In The Table. How Is This Done?
|
Hold Down The Shift Key And Click The First And Third Fields. Click The Key Icon On The Toolbar.
|
Hold Down The Ctrl Key And Click The First And Third Fields. Click The Key Icon On The Toolbar
|
Hold Down The Shift Key And Click The First And Third Fields. Select Primary Key Under The Table
|
Hold Down The Ctrl Key And Click The First And Third Fields. Select Primary Key Under The Table
|
B
|
CS403
|
A Relation (From The Relational Database Model) Consists Of A Set Of Tuples Which Implies That
|
All Tuples In A Relation Must Be Distinct
|
Relational Model Supports Multi-Valued Attributes Whose Values Can Be Represented In Sets
|
For Any Two Tuples The Values Associated With All Of Their Attributes May Be The Same
|
All Tuples In A Particular Relation May Have Different Attributes
|
A
|
CS403
|
Which Of The Following Can Not Be Included Into Create Table Statement?
|
Data Types
|
Constraints
|
Attributes
|
Cardinalities
|
D
|
CS403
|
What Kind Of Query Works Best With The Chart Wizard?
|
Append
|
Update
|
Action
|
Select
|
D
|
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
|
A Second Normal Form (2 Nf) Relation Should
|
Be In 1 Nf
|
Not Have A Composite Key
|
Not Have Attributes Dependent On Key Attribute
|
Not Have Attributes Dependent On One Another
|
A
|