CS101
532
CS201
225
CS301
232
CS302
174
CS304
192
CS401
224
CS402
258
CS403
228
CS408
113
CS411
121
CS502
249
CS504
268
CS601
679
CS604
381
CS605
261
CS607
184
CS609
230
CS610
300
CS614
100
CS703
65
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 |