Code Question Option A Option B Option C Option D Answer
CS403 After Creating The Initial Erd Segments The Next Step Is To Define The Major Transaction Modules Perform The Appropriate Normalization Checks Based On The Data Dictionary Contents Create A Basic Data Dictionary For All The Components Found In Each Erd Segment Define The Entities Attributes Relationships Connectivities Cardinalities And Constraints. C
CS403 Alter Table Exams Rename Column Q_Description To Question_Descp Std_Id To Student_Id. Syntax Of Alter Table Is Not Correct. True False B
CS403 Alter Table Exams Rename Column Q_Description To Question_Descp Std_Id To Student_Id. Syntax Of Alter Table Is Not Correct. True False B
CS403 An Attribute Y May Be Functionally Dependent On (I) A Composite Attribute X Y (Ii) A Single Attribute X (Iii) No Attribute I And Ii I And Iii Ii And Iii Iii A
CS403 An Entity Can Be Logically Connected To Another By Defining A . Hyperlink Common Attribute Primary Key Superkey B
CS403 An Entity Type Is Defined When The Database Is Actually Constructed A Specific Type Such As An Integer Text Date Logical Etc A Coherent Set Of Similar Objects That We Want To Store Data On (E.G. Student Course Car) Defined By The Database Designer B
CS403 An Instance Is A Particular Occurance Of An Entity A Special Type Of Relation An Attribute Of An Entity Any Particular Entity A
CS403 Browser Based Forms Are Developed In The Following Tools Except Html Scripting Language Front Page Web-Based Forms D
CS403 Columns Used To Uniquely Identify Individual Rows Of A Given Table May Be Specified To Be Not Not Null True False B
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 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 Consider Two Sets A And B. A Contains 2 Elements And B Contains 3. How Many Elements Do Their Cartesian Product 6 9 5 4 A
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 Create Table And Create Index Belongs To Which Type Of Sql Commands Dml Ddl Dcl Dql B
CS403 Data About Data Is Database True False F
CS403 Data About Data Is Metadata True False A
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 Data Redundancies Produce Unusual And Undesirable Data Management Problems Caused By __________ Transitive Requirements Dependencies Normalization Data Anomalies D
CS403 Data Redundancy Means Security Of Data Duplication Of Data Management Of Data Recovery Of Data B
CS403 Database Management Systems Operating Systems Applications And Utilities Are All Examples Of __________ Hardware Software Computer Infrastructure Input And Output B