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 |
Which Of The Following Is Used To Retrieve And Insert Information From Database?
|
Dml
|
Ddl
|
Dcl
|
Both Dml And Ddl
|
A |
| CS403 |
Which Of The Following Is Used With Insert Command To Insert Values In A Db Table?
|
Onto
|
Into
|
Upto
|
With
|
B |
| CS403 |
Which Of The Following Justifies The Inclusion Of Derived Attributes In A Database?
|
Inclusion Of Derived Attributes Is A Standard Procedure And Does Not Require Justification
|
Derived Attributes Should Be Used When They Add To Design Elegance
|
Query Speed Is Enhanced By Not Computing Derived Attributes
|
Poor Design Is The Only Excuse For The Inclusion Of Derived Attributes
|
C |
| CS403 |
Which Of The Following Might Be Represented With A Multivalued Attribute?
|
Persons Name
|
Class Location
|
Bank Account Balance
|
Book Title
|
B |
| CS403 |
Which Of The Following Might Be Represented With A Single-Valued Attribute?
|
Persons Phone Number
|
Cars Color
|
Employees Educational Background
|
Computers Processor Speed
|
D |
| CS403 |
Which Of The Following Serves As A Milestone Or Reference Point In The Log File?
|
Constraints
|
Relations
|
Check Points
|
Transactions Identities
|
C |
| CS403 |
Which Of The Following Sql Statements Used To Control Access To The Data And To The Database?
|
Grant
|
Revoke
|
Both Grant And Revoke
|
Select
|
C |
| CS403 |
Which Of The Following Statements Are Data Definition Language Command?
|
Insert
|
Update
|
Grant
|
Truncate
|
D |
| CS403 |
Which Of The Following Statements Are Data Definition Language Commands?
|
Insert
|
Update
|
Grant
|
Truncate
|
D |
| CS403 |
Which Of The Following Statements Best Describes A Data Warehouse?
|
A Data Storage Facility Dedicated To Using The Existing Data To Generate Information
|
Frequent And Complex Transactions Characterize Its Use
|
The Most Common Type Of Database In Use Today
|
Generally Used In Environments With Large Inventories Thus The Term Warehouse
|
A |
| CS403 |
Which Of The Following Statements Best Describes The Use Of Freestanding Macros?
|
They Are Best Used For Conditional Statements
|
They Are Best Used For Menu Items
|
They Are Best Used To Enter Temporary Values In A Form
|
Do Not Use Freestanding Macros
|
D |
| CS403 |
Which Of The Following Statements Creates A Database Named Company
|
Create Database Company
|
Create Db Company
|
Add Database Copmany
|
Create Company Database
|
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 Statements Creates A Database Named Imdb
|
Create Database Imdb;
|
Create Db Imdb;
|
Add Database Named Imdb;
|
Create Imdb Database;
|
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 |
Which Of The Following Types Of Partitioning Reduces The Chances Of Unbalanced Partitions?
|
Vertical
|
List
|
Hash
|
Range
|
C |
| CS403 |
Which Of The Following Will Be Deleted Relating To A Table If You Use Truncate Command?
|
All Rows In A Table
|
Indexes
|
Table Structure And Its Columns
|
Constraints
|
A |
| CS403 |
Which One Is The Corrected Way To Implement M To M Relation Which Designing Data Base
|
Using Junction Table With Keys
|
By Splitting Data Into Tables With Pk And Fk
|
As A Single Table Rarly As To Tables With Pk And Fk
|
By Creating Three Tables And Linking Them Through Pk And Fk
|
A |
| 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 |
Which Syntax Will Concatenate Employee First And Last Names With A Space In Between The Names?
|
([Emp_Fname] & [Emp_Fname])
|
([Emp_Fname] & & [Emp_Fname])
|
([Emp_Fname] & [Emp_Fname])
|
([Emp_Fname] [Emp_Fname])
|
B |