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 |
Query Analyzer Is Used To Practice Sql In Ms-Access And Ms-Sql Server.
|
True
|
False
|
A | ||
| CS403 |
Reate Table And Create Index Belongs To Which Type Of Sql Commands
|
Dml
|
Ddl
|
Dcl
|
Dql
|
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 |
Removing The __________ Is Part Of The Database Design Process
|
Feiorgn Keys
|
Primary Key Dependencies
|
Recursive Relationships
|
Partial And Transitive Dependencies
|
D |
| CS403 |
Revoke Is A __________ Statement
|
Data Definition
|
Control Access
|
Data Manipulation
|
Data Description
|
B |
| 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
|
Does Not Have An Error
|
Has An Error - The String In Single Quotes North And south
|
A |
| 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 |
Select The Statement That Best Defines A Candidate Key
|
An Attribute Or Combination Of Attributes That Allows The User To Search For Non-Unique Data
|
An Attribute Or Combination Of Attributes That Is Calculated From Existing Data
|
An Attribute Or Combination Of Attributes That Establishes Relationships Between Tables
|
An Attribute Or Combination Of Attributes That Could Be But Is Not Used As A Pk
|
D |
| CS403 |
Small Organizations Usually Have Complex Management Structure
|
True
|
False
|
B | ||
| CS403 |
Sql Data Types Do Not Have Support For Storing Multi-Media Objects Directly
|
True
|
False
|
A | ||
| CS403 |
Sql Is Used For:
|
Creating Managing And Deleting Tables And Manage The Relationships Among The Stored Date
|
Generating Queries Organizing Managing And Retrieving Data Stored In A Database
|
Maintaining Data Integrity And Coordinate Data Sharing
|
All Of The Above
|
D |
| CS403 |
Sql Stands For __________. I – Structured Query Language Ii – Standard Query Language Lll- Status Query Language
|
Only I
|
Only Ii
|
Only Lll
|
Both I And Ii
|
A |
| CS403 |
Structural Constraints Of A Relationship Type Refer To
|
Identifying The Owner Entity Type Relevant To A Given Entity Type
|
Whether The Existence Of An Entity Depends On It Being Related To Another Entity Via The Relationship Type
|
The Role That A Participating Entity From The Entity Type Plays In Each Relationship Instance
|
The Constraints Applicable In Granting Access To Tables Columns And Views In A Database Schema
|
B |
| CS403 |
Suppose There Are 4 Fields In A Table Named Cust (Customer_Id First_Name Last_Name Phone). Which Of The Following Gives All The Information Of The Customers In The Table Whose Last Name Is Ali?
|
Select * From Cust Where Last_Name= Ali ;
|
Select * From Cust Where Last_Name=Ali;
|
Select * From Customer Where Name=Ali;
|
Select * From Customer Where Last_Name=Ali;
|
A |
| CS403 |
Suppose There Are 4 Rows And 3 Columns In Table1 And 6 Rows And 5 Coulmns In Table2; What Is The Size Of The Cartesian Product Incase Of Cross Join Between These Two Tables?
|
24
|
20
|
18
|
15
|
A |
| CS403 |
Suppose There Are 8 Rows And 4 Columns In Table1 And 3 Rows And 4 Coulmns In Table2; What Is The Size Of The Cartesian Product Incase Of Cross Join Between These Two Tables?
|
32
|
12
|
16
|
24
|
D |
| CS403 |
The __________ Operator Allows To Use Wild Cards In The Where Clause Of An Sql Statement
|
In
|
From
|
Like
|
None Of The Above
|
C |
| CS403 |
The __________ Operator Allows To Use Wild Cards In The Where Clause Of An Sql Statement
The __________ Operator Allows To Use Wild Cards In The Where Clause Of An Sql Statement
|
In
|
From
|
Like
|
None Of The Above
|
C |
| CS403 |
The ___________ Function Helps Reduce The Need To Use Mutiple Or Conditions
|
In
|
Like
|
And
|
Between
|
A |
| CS403 |
The Constraint Specifies Whether Each Entity Supertype Occurrence Must Also Be A Member Of At Least One Subtype
|
Specialization
|
Uniqueness
|
Inheritance
|
Completeness
|
D |