|
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
|
Which Of The Following Is True About Delete Command?
|
Is Ddl Command
|
Resets Identity Of The Table
|
Cannot Activate A Trigger
|
Can Be Rolled Back
|
A
|
|
CS403
|
While Recovering Data Which Of The Following Files Does A Recovery Manager Examines At First?
|
A System File
|
Log File
|
Data Dictionary
|
Metadata
|
B
|
|
CS403
|
Data Manipulation Language (Dml) Is The Set Of Commands Used To Maintain And Query A Database Including Updating Inserting Modifying And Retrieving Data
|
True
|
False
|
|
|
A
|
|
CS403
|
Which Of The Following Is The Correct Description Of Cache Hit?
|
When Data Is Found In The Cache
|
The Number Of Times The Cache Is Accessed Directly By The Processor
|
When Data Is Removed In The Cache
|
When Data Is Lost From The Cache
|
A
|
|
CS403
|
Revoke Is A __________ Statement
|
Data Definition
|
Control Access
|
Data Manipulation
|
Data Description
|
B
|
|
CS403
|
In Sql Which Command Is Used To Modify The Rows Of Tables
|
Update
|
Insert
|
Browse
|
Append
|
A
|
|
CS403
|
Which Of The Following Concepts Is Applicable With Respect To 2Nf?
|
Full Functional Dependency
|
Any Kind Of Dependency
|
Transitive Dependency
|
Non-Transitive Dependency
|
A
|
|
CS403
|
Consider The Following Statements. A. An Entity Integrity Constraint States That No Primary Key Value Can Be Null B. A Referential Integrity Constraint Is Specified Between Two Relations C. A Foreign Key Cannot Be Used To Refer To Its Own Relation.
|
Only A
|
Only B
|
Only B And C
|
Only A And B
|
A
|
|
CS403
|
Who Is Responsible For Authorizing Access To The Database For Coordinating And Monitoring Its Use?
|
Database Designer
|
Database Administrator
|
End User
|
Application Programmer
|
B
|
|
CS403
|
Which Of The Following Is An Advantage Of Having A Precisely Written Set Of Current Operations
|
It Clarifies The Assignment Of Data Types
|
It Highlights The Best Possible Way To Perform Each Task
|
It Forces Careful Assessment Of The Procedures
|
It Makes The Creation Of The Data Dictionary Much Easier
|
C
|
|
CS403
|
In Which Of The Following Situations Clustering Is Suitable:
|
Frequently Updating
|
Relatively Static
|
Relatively Deletion
|
Relatively Dynamic
|
B
|
|
CS403
|
An Entity Can Be Logically Connected To Another By Defining A .
|
Hyperlink
|
Common Attribute
|
Primary Key
|
Superkey
|
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
|
Which Of The Following Are Not Functions Of Forms?
|
Forms Are Used To Tie Together The Database Components Through Menu Structures
|
Forms Extend Data Validation Rules Through Queries Value Lists And Other Input Control Devices
|
Forms Are Used To Enter New Data And To Edit Existing Data
|
Forms Program And Control User Responses
|
D
|
|
CS403
|
Data Redundancies Produce Unusual And Undesirable Data Management Problems Caused By __________
|
Transitive Requirements
|
Dependencies
|
Normalization
|
Data Anomalies
|
D
|
|
CS403
|
A Superkey That Does Not Contain A Subset Of Attributes That Is Itself A Superkey Is Called A .
|
Candidate Key
|
Primary Key
|
Superkey
|
Secondary Key
|
A
|
|
CS403
|
Columns Used To Uniquely Identify Individual Rows Of A Given Table May Be Specified To Be Not Not Null
|
True
|
False
|
|
|
B
|
|
CS403
|
Identify The Basic Part(S) Of A Select Statement?
|
Select
|
From
|
Both Select And From
|
Distinct
|
C
|
|
CS403
|
Removing The __________ Is Part Of The Database Design Process
|
Feiorgn Keys
|
Primary Key Dependencies
|
Recursive Relationships
|
Partial And Transitive Dependencies
|
D
|