|
CS403
|
In Access How Do You Tell If Referential Integrity Is Enforced For A Relationship?
|
The Relationship Lines Are Thick And Dark And The Nature Of The Relationships Is Labeled
|
The Relationship Lines Are Thin And The Nature Of The Relationships Is Labeled
|
Right-Click The Relationship Line To See If Enforce Referential Integrity Is Checked
|
Right-Click The Relationship Line Select Referential Integrity And Look At The Relationships Properties
|
A
|
|
CS403
|
What Are The Fourth And Fifth Steps In Developing A Pos?
|
Define The Entities Attributes Relationships Connectivities Cardinalities And Constraints. Create The Initial Erd Segments
|
Develop Business Rules. Create The Initial Erd Segments
|
Develop Business Rules. Define The Entities Attributes Relationships Connectivities Cardinalities And Constraints
|
Define The Major Transaction Modules. Create The Initial Erd Segments
|
A
|
|
CS403
|
What File Does Access Use To Lock A Database In A Shared Environment?
|
The Ldb File
|
The Pid File
|
The Mde File
|
The Mdb File
|
A
|
|
CS403
|
Which Of The Following Best Describes A Macro?
|
An Sql Script
|
An Instruction Or A Set Of Instructions That Triggers One Or More Actions
|
A Vba Program
|
A Detailed Set Of Actions That Access Will Invoke Whenever A Mouse Click Occurs
|
B
|
|
CS403
|
Query Analyzer Is Used To Practice Sql In Ms-Access And Ms-Sql Server
|
True
|
False
|
|
|
A
|
|
CS403
|
Which Of The Following Is An Example Of Volatile Memory?
|
Ram
|
Rom
|
Flash Memory
|
Cpu
|
A
|
|
CS403
|
Which Of The Following Statements Is True About The Views?
|
View Is Always A Complete Set Of All The Tables In A Database
|
View Can Not Be Used For Retrieving Data
|
The Results Of Using A View Are Not Permanently Stored In The Database
|
Rows Can Not Be Updated Or Deleted In The View
|
D
|
|
CS403
|
A __________ Is Established When The Value Of One Attribute Is Dependent On The Value Of Another Attribute
|
Primary Key
|
Data Anomaly
|
Dependency
|
Transitive Relationship
|
C
|
|
CS403
|
An Attribute Y May Be Functionally Dependent On (I) A Composite Attribute X Y (Ii) A Single Attribute X (Iii) No Attribute
|
I And Ii
|
I And Iii
|
Ii And Iii
|
Iii
|
A
|
|
CS403
|
Which Of The Following Statements Creates A Database Named Company.
|
Create Database Company
|
Create Db Company
|
Add Database Company
|
Create Company Database
|
A
|
|
CS403
|
Which Of The Following Is Not A Feature Of Transaction?
|
Users Should Be Able To Regard The Execution Of Each Transaction As Atomic
|
Each Transaction Run By Itself
|
Must Preserve The Consistency Of The Database
|
Dependant On Other Concurrent Transactions
|
D
|
|
CS403
|
Consider Two Sets A And B. A Contains 2 Elements And B Contains 3. How Many Elements Do Their Cartesian Product
|
6
|
9
|
5
|
4
|
A
|
|
CS403
|
The Database Data Storage Standard Requires That With Some Exceptions Data Must Occur In Only One Place At One Time. What Are The Exceptions?
|
Foreign Key And Replicated Data Requirements
|
Transitive Dependencies And Foreign Keys
|
Replicated Data And Primary Keys
|
Transitive Dependencies And Primary Keys
|
A
|
|
CS403
|
When Inserting A Field In The Footer What Is The Default Prefix Is
|
Totalof <Fieldname>
|
Sumof <Fieldname>
|
Maximumof <Fieldname>
|
Minimumof <Fieldname>
|
B
|
|
CS403
|
What Will The Following Questions Help You Define? What Types Of Transactions Take Place? How Many Different Types Of Transactions Are There?
|
Available Resources
|
Data Environment
|
Current Operations
|
Business Objectives
|
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
|
Has An Error - The String In Single Quotes North And south
|
Does Not Have An Error
|
A
|
|
CS403
|
In A Pos System What Do The Major Transaction Modules Define?
|
Inventory Management Shipping Invoice Calculations And Product Returns
|
Sales Inventory Management Shipping Back Ordering And Product Returns
|
Sales Invoice Calculations Back Ordering And Product Returns
|
Inventory Management Shipping Invoice Calculations Back Ordering And Product Returns
|
B
|
|
CS403
|
Which Of The Following Is The Correct Syntax For Adding A New Column Into An Existing Table
|
Alter Table Table_Name { Alter [Column] Column Type [(Size)] [Default Default] }
|
Alter Table Table_Name { Add [Column] Column Type [(Size)] [Default Default] }
|
Both I And Ii
|
None Of The Above
|
C
|
|
CS403
|
Which Language Is Used To Permit Or Prohibit Access To A Table?
|
Dcl
|
Ddl
|
Dml
|
All Of The Above
|
A
|
|
CS403
|
Which Of The Following Is Not A Component Of A Dfd?
|
Dataflow
|
Datastore
|
External Entities
|
Relationship Between External Entities
|
D
|