|
CS403
|
After Creating The Initial Erd Segments The Next Step Is To
|
Define The Major Transaction Modules
|
Perform The Appropriate Normalization Checks Based On The Data Dictionary Contents
|
Create A Basic Data Dictionary For All The Components Found In Each Erd Segment
|
Define The Entities Attributes Relationships Connectivities Cardinalities And Constraints.
|
C
|
|
CS403
|
Which Of The Following Is Incorrect About Alter Table Statement?
|
Cannot Be Used To Modify Type Or Size Of An Existing Column
|
Can Be Used To Delete A Column
|
Can Not Be Used To Create A New Table
|
Can Be Used To Add Column In The Existing Table
|
A
|
|
CS403
|
A Foreign Key Is
|
A Field In A Table That Matches A Key Field In Another Table
|
A Field In A Table That Contains Data That Is Also Contained Elsewhere In Another Table
|
A Field In A Table That Has The Same Name As A Key Field In Another Table
|
A Field In A Table That Has The Same Name As A Key Field In Another Table
|
A
|
|
CS403
|
Create Table And Create Index Belongs To Which Type Of Sql Commands
|
Dml
|
Ddl
|
Dcl
|
Dql
|
B
|
|
CS403
|
Which Of The Following Is Incorrect Statement Concerning The Database Design Process?
|
During Requirements Collection And Analysis Phase One Can Gather The Data Requirements Of Database Users
|
By Referring To A High Level Data Model It Is Possible To Understand The Data Requirements Of The Users Entity Types Relationships And Constraints
|
Transformation Of The High Level Data Model Into The Implementation Data Model Is Called Logical Design Or Data Model Mapping
|
During The Logical Design Phase Of Internal Storage Structures Access Paths And File Organization For The Database Files Are Specified
|
D
|
|
CS403
|
Reate Table And Create Index Belongs To Which Type Of Sql Commands
|
Dml
|
Ddl
|
Dcl
|
Dql
|
C
|
|
CS403
|
Identify The Factor Which Enforces A Relation In 3Nf?
|
Every Non-Key Attribute Is Fully Functionally Dependent On Primary Key
|
Every Non-Key Attribute Is Partially Dependent On Super Key
|
The Domain Of Attribute Must Include Only Atomic Values
|
Every Non-Key Attribute Is Non-Transitively Dependent On Primary Key
|
D
|
|
CS403
|
Data About Data Is Metadata
|
True
|
False
|
|
|
A
|
|
CS403
|
What Are The Advantages Of Form-Based Dialog Boxes?
|
They Have More Prompting Options Than Dialog Boxes Generated By Access
|
They Allow The Use Of Combo Boxes
|
Access-Generated Dialog Boxes Are Likely To Disrupt Interface Layout Schemes While Form-Based Dialog Boxes Are Not
|
All Of The Above
|
D
|
|
CS403
|
Truncate Is An Alternative Of Delete Command
|
True
|
False
|
|
|
A
|
|
CS403
|
What Is The Impact Of Setting Multiple Indexes For The Same Key In Index Sequential Files?
|
Multiple Indexes For The Same Key Can Not Be Set
|
It Will Increase Complexity As The Access Time Will Be Increased
|
It Increases Efficiency
|
It Decreases Efficiency
|
C
|
|
CS403
|
Records Data By Burning Microscopic Holes In The Surface Of The Disk With A Laser.
|
Hard Disk
|
Ram
|
Optical Disk
|
Floppy Disk
|
C
|
|
CS403
|
Which One Of The Following Is Not A Characteristic Of Meta Data?
|
Data About Data
|
Describes A Data Dictionary
|
Self-Describing
|
Includes User Data
|
D
|
|
CS403
|
Identify The Correct Statement With Respect To Normalization.
|
Normalization Is A Formal Technique That Can Be Used Only At The Starting Phase Of The Database Design.
|
Normalization Can Be Used As A Top-Down Standalone Database Design Technique.
|
The Process Of Normalization Through Decomposition Must Achieve The Lossless Join Property At Any Cost Whereas The Dependency Reservation Property Is Sometimes Sacrificed.
|
The Process Of Normalization Through Decomposition Must Achieve The Dependency Reservation Property At Any Cost Whereas The Lossless Join Property Is Sometimes Sacrificed.
|
D
|
|
CS403
|
The Main Memory Of A Computer System Is Also Known As
|
Rom
|
Ram
|
Prom
|
Hard Disk
|
B
|
|
CS403
|
The Constraint Specifies Whether Each Entity Supertype Occurrence Must Also Be A Member Of At Least One Subtype
|
Specialization
|
Uniqueness
|
Inheritance
|
Completeness
|
D
|
|
CS403
|
Which Of The Following Functions Are Not Performed By A Database Administrator?
|
Planning Designing And Implementing Database Systems
|
Establishing Standards And Procedures For Database Systems
|
Communicating With Database Users
|
Allocation Of Storage Locations And Data Structures
|
A
|
|
CS403
|
What Permission Allows The User To Open A Database Form Or Report Or Run A Macro?
|
Open
|
Open/Run
|
Administer
|
Run
|
B
|
|
CS403
|
Which Of The Following Describes The Job Of A Database Administrator?
|
Development Implementation Operation Of The Physical Database
|
Creation Of The System Catalog
|
Monitoring And Controlling Database Security And Authorization: Setting Up Controls To Ensure The Quality And Integrity Of Data
|
All Of The Above
|
C
|
|
CS403
|
Which Of The Following Is True About Truncate?
|
Can Be Rolled Back
|
Activates Triggers
|
Is Dml Command
|
Resets Identity Of The Table
|
D
|