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 |
Dml Commands Are Used For:
|
Inserting Data Into Databases
|
Creating Databases
|
Destroying Databases
|
Creating Db Objects
|
A |
| CS403 |
Dml Does Not Used To
|
Add New Rows To Tables
|
Retrieve Row From Tables
|
Modify The Rows Of Tables
|
Alter A Table Definition
|
D |
| CS403 |
Each Table Must Have A Key
|
Primary
|
Secondary
|
Logical
|
Foreign
|
A |
| CS403 |
Emp_Dob Holds Employee Birth Dates. Which Format Will Display The Month In Number Format Such As 01 Or 11?
|
Month: Format([Emp_Dob] M)
|
Month: Format([Emp_Dob] Mm)
|
Month: Format([Emp_Dob] Mmm)
|
Month: Format([Emp_Dob] Mmmm)
|
B |
| CS403 |
Given Are The Relations Of Student And Instructor Which Relational Algebra Operation Could Have Been Applied On The Pair Of Relations Student And Instructor To Obtain The Above Data?
|
Instructor – Student
|
Student n Instructor
|
Instructor ÷ Student
|
Student – Instructor
|
B |
| CS403 |
Grant Belong To Which Types Of Sql Command Classification
|
Dml
|
Ddl
|
Dcl
|
Dql
|
C |
| CS403 |
Grant Belongs To Which Type Of Sql Commands Classification
|
Dml
|
Ddl
|
Dcl
|
Dql
|
C |
| CS403 |
Grant Is A __________ Command
|
Dcl
|
Dml
|
Ddl
|
None Of The Above
|
A |
| CS403 |
Grant Select Update(Designation) On Employee To Amali Hiruni With Grant
Option; What Does This Sql Statement Do?
|
Grant Permission To Amali Only To Retrieve Data From Employee Table And Grant Permission To Hiruni Only To Update The Designation From Employee Table
|
Grant Permission To Hiruni In Order To Grant Select And Update Permission To Amali
|
Grant Permission To Amali & Hiruni To Update Designation Of Employees In The Employee Table
|
Grant Permission To Amali And Hiruni To Update All Data Except Designation In Employee Table
|
C |
| CS403 |
How Many Clustered Index(Es) Do Each Database Table Have?
|
2
|
3
|
5
|
1
|
D |
| CS403 |
Identify The Basic Part(S) Of A Select Statement?
|
Select
|
From
|
Both Select And From
|
Distinct
|
C |
| CS403 |
Identify The Constraint That Limits The Values That Can Be Placed In A Column
|
Not Null
|
Check
|
Foreign Key
|
Unique
|
A |
| 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
|
B |
| 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 |
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 |
Identify The Incorrect Statement Among The Given
|
An Entity May Be An Object With A Physical Existence Like A Car A House Or An Employee
|
One Cannot Consider Something Which Has Conceptual Existence Like A Course In A Degree Program As An Entity
|
Age Can Be Considered As A Single Value Attribute Of A Person
|
An Entity Type Describes The Schema Or Intension For A Set Of Entities Which Share The Same Structure
|
B |
| CS403 |
Identify The Language Which Is Used To Specify Database Schema
|
Dcl
|
Dml
|
Ddl
|
Non Of The Above
|
D |
| CS403 |
Identify The Operation Which Is Not One Of The Parts Of The Five Basic Set Operations In Relational Algebra?
|
Join
|
Union
|
Cartesian Product
|
Set Difference
|
A |
| CS403 |
In “One To Many” Cardinality One Instance Of A Relation Is Mapped With
|
Many Instances Of Second Entity Type
|
One Instance Of Second Entity Type
|
Primary Key Of 2 Relations
|
None Of Above
|
A |
| CS403 |
In “One To One Relationship” One Instance Of First Entity Type Is Mapped With Two Instances Of Second Entity Type
|
True
|
False
|
A |