Online Exam Preparation
MCQs Library
Browse subject-wise multiple choice questions, review answers quickly, and start a test from the same section.
Questions
| Code | Question | Option A | Option B | Option C | Option D | Answer |
|---|---|---|---|---|---|---|
| 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 |
The Entity Relation Model Models
|
Entities Relationships And Processes
|
Entities And Relationships
|
Relationships
|
Entities
|
C |
| CS403 |
The Er Model Is Meant To
|
Replace Relational Design
|
Be Close To A Users Perception Of The Data
|
Enable Low Level Descriptions Of Data
|
Enable Detailed Descriptions Of Data Query Processing
|
D |
| CS403 |
The Main Memory Of A Computer System Is Also Known As
|
Rom
|
Ram
|
Prom
|
Hard Disk
|
B |
| CS403 |
The Main Software Package That Supports A Database Management Approach Is Called
|
Data Dictionary
|
Report Generator
|
Database Management System
|
Distributed Database
|
C |
| CS403 |
The Relationship Between Store And Employee Is Defaulted To Mandatory That Is The Fk Value In Employee Is Required. How Do You Eliminate A Record From Store?
|
Delete The Employees From The Store To Be Deleted
|
Permanently Remove The Referential Integrity Enforcement
|
Open The Employee Table In The Design Format; Then Change The Required Property Of The Employees Fk To No And Make Sure That Its Default Value Is Set To Null
|
Delete All Relationships Between Store And Employee. Redesign The Database To Work Without Them
|
C |
| CS403 |
The Room Id + Building Id Determines The Room Schedule. This Is Written
|
Room_Id Build_Id ? Room_Sch
|
Room_Id + Build_Id ? Room_Sch
|
Room_Id Room_Sch ? Build_Id
|
Room_Id Build_Id ? Room_Sch
|
A |
| CS403 |
Truncate Command Responses Time Is __________ As Compared To Delete Command
|
Poor
|
Same
|
Better
|
Worst
|
C |
| CS403 |
Truncate Is An Alternative Of Delete Command
|
True
|
False
|
A | ||
| CS403 |
Two Basic Query Types Exist. They Are
|
Static And Change Queries
|
Static And Action Queries
|
Select And Action Queries
|
Select And Change Queries
|
C |
| CS403 |
Update Command Belong To Which Type Of Classification
|
Dml
|
Ddl
|
Dcl
|
Dql
|
A |
| CS403 |
Update Command Belongs To Which Type Of Classification
|
Dml
|
Ddl
|
Dcl
|
Dql
|
A |
| CS403 |
User Rights Information Is Stored In
|
Physical Database
|
Catalog
|
Logical Database
|
Buffer
|
A |
| CS403 |
Value Of A Function In Sql Is Always Determined By The Input Parameters
|
True
|
False
|
A | ||
| CS403 |
What Action Hides Or Shows The Results Of A Macro While It Runs
|
Reveal
|
Echo
|
Hide
|
Show
|
B |
| 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 |
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 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 Does Access Use To Handle Sql Code Generation?
|
Sql For
|
Query Code Generator
|
Query By Example
|
Sql Compiler
|
C |
| CS403 |
What Does Access Use To Manage Database Locking In A Multiuser Database Environment?
|
Jet Database Engine
|
Pid Files
|
Mdw Files
|
Access Lockout Protocol (Alp)
|
A |