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 | Which Of The Following Is Used To Retrieve And Insert Information From Database? | Dml | Ddl | Dcl | Both Dml And Ddl | A | |
CS403 | Which Of The Following Is Used With Insert Command To Insert Values In A Db Table? | Onto | Into | Upto | With | B | |
CS403 | Which Of The Following Justifies The Inclusion Of Derived Attributes In A Database? | Inclusion Of Derived Attributes Is A Standard Procedure And Does Not Require Justification | Derived Attributes Should Be Used When They Add To Design Elegance | Query Speed Is Enhanced By Not Computing Derived Attributes | Poor Design Is The Only Excuse For The Inclusion Of Derived Attributes | C | |
CS403 | Which Of The Following Might Be Represented With A Multivalued Attribute? | Persons Name | Class Location | Bank Account Balance | Book Title | B | |
CS403 | Which Of The Following Might Be Represented With A Single-Valued Attribute? | Persons Phone Number | Cars Color | Employees Educational Background | Computers Processor Speed | D | |
CS403 | Which Of The Following Serves As A Milestone Or Reference Point In The Log File? | Constraints | Relations | Check Points | Transactions Identities | C | |
CS403 | Which Of The Following Sql Statements Used To Control Access To The Data And To The Database? | Grant | Revoke | Both Grant And Revoke | Select | C | |
CS403 | Which Of The Following Statements Are Data Definition Language Command? | Insert | Update | Grant | Truncate | D | |
CS403 | Which Of The Following Statements Are Data Definition Language Commands? | Insert | Update | Grant | Truncate | D | |
CS403 | Which Of The Following Statements Best Describes A Data Warehouse? | A Data Storage Facility Dedicated To Using The Existing Data To Generate Information | Frequent And Complex Transactions Characterize Its Use | The Most Common Type Of Database In Use Today | Generally Used In Environments With Large Inventories Thus The Term Warehouse | A | |
CS403 | Which Of The Following Statements Best Describes The Use Of Freestanding Macros? | They Are Best Used For Conditional Statements | They Are Best Used For Menu Items | They Are Best Used To Enter Temporary Values In A Form | Do Not Use Freestanding Macros | D | |
CS403 | Which Of The Following Statements Creates A Database Named Company | Create Database Company | Create Db Company | Add Database Copmany | Create Company Database | A | |
CS403 | Which Of The Following Statements Creates A Database Named Company. | Create Database Company | Create Db Company | Add Database Company | Create Company Database | A | |
CS403 | Which Of The Following Statements Creates A Database Named Imdb | Create Database Imdb; | Create Db Imdb; | Add Database Named Imdb; | Create Imdb Database; | A | |
CS403 | Which Of The Following Statements Is True About The Views? | View Is Always A Complete Set Of All The Tables In A Database | View Can Not Be Used For Retrieving Data | The Results Of Using A View Are Not Permanently Stored In The Database | Rows Can Not Be Updated Or Deleted In The View | D | |
CS403 | Which Of The Following Types Of Partitioning Reduces The Chances Of Unbalanced Partitions? | Vertical | List | Hash | Range | C | |
CS403 | Which Of The Following Will Be Deleted Relating To A Table If You Use Truncate Command? | All Rows In A Table | Indexes | Table Structure And Its Columns | Constraints | A | |
CS403 | Which One Is The Corrected Way To Implement M To M Relation Which Designing Data Base | Using Junction Table With Keys | By Splitting Data Into Tables With Pk And Fk | As A Single Table Rarly As To Tables With Pk And Fk | By Creating Three Tables And Linking Them Through Pk And Fk | A | |
CS403 | Which One Of The Following Is Not A Characteristic Of Meta Data? | Data About Data | Describes A Data Dictionary | Self-Describing | Includes User Data | D | |
CS403 | Which Syntax Will Concatenate Employee First And Last Names With A Space In Between The Names? | ([Emp_Fname] & [Emp_Fname]) | ([Emp_Fname] & & [Emp_Fname]) | ([Emp_Fname] & [Emp_Fname]) | ([Emp_Fname] [Emp_Fname]) | B |