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 | Query Analyzer Is Used To Practice Sql In Ms-Access And Ms-Sql Server. | True | False | A | |||
| CS403 | Reate Table And Create Index Belongs To Which Type Of Sql Commands | Dml | Ddl | Dcl | Dql | C | |
| CS403 | Records Data By Burning Microscopic Holes In The Surface Of The Disk With A Laser. | Hard Disk | Ram | Optical Disk | Floppy Disk | C | |
| CS403 | Removing The __________ Is Part Of The Database Design Process | Feiorgn Keys | Primary Key Dependencies | Recursive Relationships | Partial And Transitive Dependencies | D | |
| CS403 | Revoke Is A __________ Statement | Data Definition | Control Access | Data Manipulation | Data Description | B | |
| CS403 | Select North Customer From Cust_Dtls Where Region = N Order By Customer Union Select East Customer From Cust_Dtls Where Region = E Order By Customer | Has An Error - The String Should Be In Double Quotes | Has An Error - Order By Clause | Does Not Have An Error | Has An Error - The String In Single Quotes North And south | A | |
| CS403 | Select North Customer From Cust_Dtls Where Region = N Order By Customer Union Select East Customer From Cust_Dtls Where Region = E Order By Customer | Has An Error - The String Should Be In Double Quotes | Has An Error - Order By Clause | Has An Error - The String In Single Quotes North And south | Does Not Have An Error | A | |
| 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 | Small Organizations Usually Have Complex Management Structure | True | False | B | |||
| CS403 | Sql Data Types Do Not Have Support For Storing Multi-Media Objects Directly | True | False | A | |||
| CS403 | Sql Is Used For: | Creating Managing And Deleting Tables And Manage The Relationships Among The Stored Date | Generating Queries Organizing Managing And Retrieving Data Stored In A Database | Maintaining Data Integrity And Coordinate Data Sharing | All Of The Above | D | |
| CS403 | Sql Stands For __________. I – Structured Query Language Ii – Standard Query Language Lll- Status Query Language | Only I | Only Ii | Only Lll | Both I And Ii | A | |
| CS403 | Structural Constraints Of A Relationship Type Refer To | Identifying The Owner Entity Type Relevant To A Given Entity Type | Whether The Existence Of An Entity Depends On It Being Related To Another Entity Via The Relationship Type | The Role That A Participating Entity From The Entity Type Plays In Each Relationship Instance | The Constraints Applicable In Granting Access To Tables Columns And Views In A Database Schema | 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 | 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 | Suppose There Are 8 Rows And 4 Columns In Table1 And 3 Rows And 4 Coulmns In Table2; What Is The Size Of The Cartesian Product Incase Of Cross Join Between These Two Tables? | 32 | 12 | 16 | 24 | 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 | The __________ Operator Allows To Use Wild Cards In The Where Clause Of An Sql Statement The __________ Operator Allows To Use Wild Cards In The Where Clause Of An Sql Statement | In | From | Like | None Of The Above | C | |
| CS403 | The ___________ Function Helps Reduce The Need To Use Mutiple Or Conditions | In | Like | And | Between | A | |
| CS403 | The Constraint Specifies Whether Each Entity Supertype Occurrence Must Also Be A Member Of At Least One Subtype | Specialization | Uniqueness | Inheritance | Completeness | D |