|
CS403
|
Which Of The Following Function Falls In The Category Of Aggregate Functions
|
Sum
|
Min
|
Max
|
All Of The Above
|
D
|
|
CS403
|
Which Of The Following Is Incorrect About Views?
|
It Is Not Possible To Left Out The Data Which Is Not Required For A Specific View
|
A Database View Displays One Or More Database Records On The Same Page
|
Views Can Be Used As Security Mechanisms
|
Views Are Generally Used To Focus The Perception Each User Has Of The Database
|
A
|
|
CS403
|
Which Of The Following Is The Correct Syntax For Adding A New Column Into An Existing Table
|
Alter Table Table_Name { Alter [Column] Column Type [(Size)] [Default Default] }
|
Alter Table Table_Name { Add [Column] Column Type [(Size)] [Default Default] }
|
Both I And Ii
|
None Of The Above
|
B
|
|
CS403
|
Which Model Operates At The Lowest Level Of Abstraction?
|
Conceptual
|
Internal
|
External
|
Physical
|
D
|
|
CS403
|
Which Of The Following Describes A Database System?
|
A Collection Of Stored Operational Data Used By The Application System Of Some Particular Enterprise
|
A Shared Collection Of Logically Related Data (And A Description Of This Data) Designed To Meet The Information Needs Of An Organisation
|
A Collection Of Stored Data Organised In Such A Way That All User Requirements Are Satisfied By The Database. In General There Is Only One Copy Of Each Item Of Data Although There May Be Controlled Repetition Of Some Data
|
All Of The Above
|
C
|
|
CS403
|
A Relational Database Is
|
One That Consists Of Two Or More Tables
|
A Database That Is Able To Process Tables Queries Forms Reports And Macros
|
One That Consists Of Two Or More Tables That Are Joined In Some Way
|
The Same As A Flat File Database
|
C
|
|
CS403
|
A Primary Key Is An Attribute (Or Set Of Attributes) That Has Been Chosen For An Entity Whose Values Are Used To Uniquely Identify A Particular Instance Of An Entity
|
True
|
False
|
Partially True
|
None Of The Given
|
A
|
|
CS403
|
Grant Belongs To Which Type Of Sql Commands Classification
|
Dml
|
Ddl
|
Dcl
|
Dql
|
C
|
|
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
|
A Relational Database System Is Based On The Concept(S) Of
|
A Network Of Data Records
|
Nested Tables
|
Tables Rows And Columns
|
A Tree-Like Structure Of Data
|
A
|
|
CS403
|
Which Of The Following Is Not An Advantage Of A Menu Driven Database System?
|
Help Make The Database Applications System User-Friendly By Eliminating The Need To Remember Command Languages
|
Provide Security Though User-Level Logins
|
Control Access By Providing Only Those Options That Allow People To Do Their Jobs
|
Create An Environment That Is Tailored To Specific Types Of Applications And End Users
|
B
|
|
CS403
|
A Relationship Exists When An Association Is Maintained Within A Single Entity
|
Unary
|
Binary
|
Ternary
|
Weak
|
A
|
|
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
|
Dml Commands Are Used For:
|
Inserting Data Into Databases
|
Creating Databases
|
Destroying Databases
|
Creating Db Objects
|
A
|
|
CS403
|
A Collection Of Concepts That Can Be Used To Describe The Structure Of A Database
|
Database
|
Dbms
|
Data Model
|
Data
|
C
|
|
CS403
|
Which Of The Following Constraints Enforces Entity Integrity?
|
Primary Key
|
Foreign Key
|
Check
|
Not Null
|
A
|
|
CS403
|
Who Is Responsible For Authorizing Access To The Database For Coordinating And Monitoring Its Use ?
|
Database Designers
|
Database Administrators
|
End Users
|
Application Programmers
|
B
|
|
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
|
The __________ Operator Allows To Use Wild Cards In The Where Clause Of An Sql Statement
|
In
|
From
|
Like
|
None Of The Above
|
C
|
|
CS403
|
Which Of The Following Is Not True Regarding Db Transactions?
|
A Set Of Database Operations That Are Processed Partly
|
A Database Transaction Is A Logical Unit Of Database Operations
|
A Database Transaction Must Be Atomic
|
A Database Transaction Must Contains The Acid Property
|
B
|