|
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
|
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
|
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
|
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
|
Which Of The Following Is Not An Aggregate Function
|
Avg
|
Sum
|
Upper
|
Max
|
C
|
|
CS403
|
Grant Is A __________ Command
|
Dcl
|
Dml
|
Ddl
|
None Of The Above
|
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
|
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
|
Which Of The Following Is One Of The Purposes Of Using Ddl Commands?
|
Creating And Destroying Databases
|
Manipulating Databases
|
Updating Records Into Databases
|
Inserting Records Into Databases
|
C
|
|
CS403
|
Consider A Table Named “Emp” Having Fields Empname Empid Age Salary. Which Of The Following Is True If The Following Sql Statement Tries To Execute? Select * From Emp Where Empname=’Ali’ Orderby Age; The Statement Has A Syntax Error
|
The Statement Displays The Entire Fields From Emp In Which The Empname Is Ali In Any Order
|
The Statement Displays The Entire Fields From Emp In Which The Empname Is Ali In Descending Order Of Their Age
|
The Statement Displays The Entire Fields From Emp In Which The Empname Is Ali In Ascending Order Of Their Age
|
None Of The Above
|
A
|
|
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
|
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
|
Small Organizations Usually Have Complex Management Structure
|
True
|
False
|
|
|
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
|
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 Is A Correct Way Of Selecting All The Columns From A Table Called Persons?
|
Select From * Persons
|
Select * From Persons
|
Select * Where Persons
|
Select Where * Persons
|
B
|
|
CS403
|
Controlling Redundancy In A Database Management System Does Not Help To
|
Avoid Duplication
|
Avoid Unnecessary Wastage Of Storage Space
|
Avoid Unauthorised Access To Data
|
Avoid Inconsistency Among Data
|
C
|
|
CS403
|
Which Of The Following Is A Service Provided By A Dbms?
|
It Ensures And Enforces Data Integrity At All Levels
|
It Maintains An Environment In Which Security Is Created And Enforced
|
It Manages The Metadata In The Data Dictionary
|
All Of The Above Are Services Of A Dbms
|
D
|
|
CS403
|
Which Of The Following Is Not True Regarding Clustering ?
|
It Increases The Efficiency Since Related Records Are Placed Close To Each Other
|
Clustering Makes Records Difficult To Access
|
Suitable To Relatively Static Situations
|
It Is A Process Which Means To Place Record From Different Tables To Places In Adjacent Physical Locations.
|
B
|
|
CS403
|
Data Redundancy Means
|
Security Of Data
|
Duplication Of Data
|
Management Of Data
|
Recovery Of Data
|
B
|