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 |
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 |
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 |
In A Three-Level Dbms Architecture The Level Interacts Directly With The Users
|
External
|
Conceptual
|
Internal
|
Physical
|
A |
| 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 |
In An Erd The Focus Is On The And The Relationships Between Them
|
Attributes
|
Entities
|
Keys
|
Indexes
|
B |
| CS403 |
In Sql Queries While Creating Tables Or Relations In Database Key Columns May Be Specified By
|
Bull
|
Not Null
|
Data Type
|
None Of The Above
|
B |
| CS403 |
In Sql Which Command Is Used To Delete Rows From Table
|
Delete
|
Remove
|
Truncate
|
Both I And Ii
|
A |
| CS403 |
In Sql Which Command Is Used To Modify The Rows Of Tables
|
Update
|
Insert
|
Browse
|
Append
|
A |
| CS403 |
In Which Of The Following Situations Clustering Is Suitable:
|
Frequently Updating
|
Relatively Static
|
Relatively Deletion
|
Relatively Dynamic
|
B |
| CS403 |
Incase Of Context-Level Diagram The System Is Represented By
|
One Process Atleast
|
Two Processes Atleast
|
One Process Only
|
Any Number Of Processes
|
C |
| CS403 |
Is A Control That Enables Users To Select One Option From An Associated List; Users Can Also Type An Option.
|
Combo Box
|
Button
|
Text Box
|
Static Area
|
B |
| CS403 |
Macros Are Best Placed In Logical Modules Known As
|
Macro Sets
|
Macro Groups
|
Code Sets
|
Modules
|
B |
| CS403 |
Making A Change To The Conceptual Schema Of A Database But Not Affecting The Existing External Schemas Is An Example Of
|
Physical Data Independence
|
Concurrency Control
|
Logical Data Independence
|
Functional Dependency
|
C |
| CS403 |
Making A Change To The Conceptual Schema Of A Database But Not Affecting The Existing
External Schemas Is An Example Of
|
Physical Data Independence
|
Concurrency Control
|
Logical Data Independence
|
Functional Dependency
|
C |
| CS403 |
Materialized Views And Indexes Are Not Similar By The Following Way(S)
|
They Consume Storage Space
|
They Must Be Refreshed When The Data In Their Master Tables Changes
|
They Can Be Accessed Directly Using A Select Statement
|
All Of The Given
|
C |
| CS403 |
Materialized Views And Indexes Are Not Similar By The Following Way(S).
|
They Must Be Refreshed When The Data In Their Master Tables Changes
|
They Can Be Accessed Directly Using A Select Statement
|
They Consume Storage Space
|
All Of The Given
|
C |
| 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 |
Objective Of An Order By Clause Is To Display Or Arrange Output Of A Select Statement In A Particular Order
|
True
|
False
|
A | ||
| CS403 |
Only One Type Of Constraint Can Be Enforced In Any Table By Create Command
|
True
|
False
|
A | ||
| CS403 |
Query Analyzer Is Used To Practice Sql In Ms-Access And Ms-Sql Server
|
True
|
False
|
A |