MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 1294 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science Engineering (CSE) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In an Entity-Relationship Diagram “Diamonds” represents |
| A. | attributes |
| B. | multi-valued attributes |
| C. | weak entity set |
| D. | relationship sets |
| Answer» E. | |
| 2. |
In an Entity-Relationship Diagram “Ellipses” represents |
| A. | attributes |
| B. | weak entity set |
| C. | relationship sets |
| D. | multi-valued attributes |
| Answer» B. weak entity set | |
| 3. |
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here theonly functional dependencies are from dept name to the other attributes. This relation is in |
| A. | Fourth NF |
| B. | BCNF |
| C. | Third NF |
| D. | Second NF |
| Answer» C. Third NF | |
| 4. |
is a special type of integrity constraint that relates two relations & maintains consistency across the relations. |
| A. | entity integrity constraints |
| B. | referential integrity constraints |
| C. | domain integrity constraints |
| D. | domain constraints |
| Answer» C. domain integrity constraints | |
| 5. |
A functional dependency is a relationship between |
| A. | Tables |
| B. | Columns |
| C. | Attributes |
| D. | Rows |
| Answer» D. Rows | |
| 6. |
If the complete execution of the transaction(s) takes the database from one consistentstate to the other then that property of transaction is called: |
| A. | Isolation |
| B. | Durability |
| C. | Consistency preservation |
| D. | None of the above |
| Answer» D. None of the above | |
| 7. |
Problems occurs if we don’t implement a proper locking strategy |
| A. | dirty reads |
| B. | phantom reads |
| C. | lost updates |
| D. | unrepeatable reads |
| Answer» C. lost updates | |
| 8. |
DFD stands for |
| A. | Data Flow Document |
| B. | Data File Diagram |
| C. | Data Flow Diagram |
| D. | Non of the above |
| Answer» D. Non of the above | |
| 9. |
We use name PL/SQL program objects and units. |
| A. | lexical units |
| B. | literals |
| C. | delimiters |
| D. | identifiers |
| Answer» E. | |
| 10. |
Insertion of a large number of entries at a time into an index is referred to as__________ of the index. |
| A. | Loading |
| B. | Bulk insertion |
| C. | Bulk loading |
| D. | Increase insertion |
| Answer» D. Increase insertion | |
| 11. |
The main task carried out in the __________ is to remove repeating attributes toseparate tables. |
| A. | First Normal Form |
| B. | Second Normal Form |
| C. | Third Normal Form |
| D. | Fourth Normal Form |
| Answer» B. Second Normal Form | |
| 12. |
Consequently R.Boyce-Codd jointly launched powerful definition for the third normalform called______: |
| A. | Boyce-Codd normal form |
| B. | First normal form |
| C. | Second normal form |
| D. | All of these |
| Answer» B. First normal form | |
| 13. |
A relation is in if an attribute of a composite key is dependent on an attribute of other composite key. |
| A. | 2nf |
| B. | 3nf |
| C. | bcnf |
| D. | 1nf |
| Answer» C. bcnf | |
| 14. |
A typical tape drive is a typical disk drive. |
| A. | more expensive than |
| B. | cheaper than |
| C. | of the same cost as |
| D. | none of the mentioned |
| Answer» B. cheaper than | |
| 15. |
A .................. normal form, normalization will be needed where all attributes in a relationare not functionally dependent only on the key attribute. |
| A. | First |
| B. | Second |
| C. | Third |
| D. | Fourth |
| Answer» D. Fourth | |
| 16. |
……………..specifies a search condition for a group or an aggregate. |
| A. | GROUP BY Clause |
| B. | HAVING Clause |
| C. | FROM Clause |
| D. | WHERE Clause |
| Answer» C. FROM Clause | |
| 17. |
A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are |
| A. | Prof_Project (professor, st_name, dept) Proj_stud (project, student no.) |
| B. | Prof_stud (professor, student no) Proj_stud (project, student no) |
| C. | Student (student no, st_name, dept) Student (student no, st_name, dept) |
| D. | Professor(professor, project) Professor( professor, project, dept) Student (student no, st_name, dept) |
| Answer» C. Student (student no, st_name, dept) Student (student no, st_name, dept) | |
| 18. |
BCNF is needed because |
| A. | otherwise tuples may be duplicated |
| B. | when a data is deleted tuples may be lost |
| C. | updating is otherwise difficult |
| D. | when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples |
| Answer» E. | |
| 19. |
The clause allows us to select only those rows in the result relation of the clause that satisfy a specified predicate. |
| A. | where, from |
| B. | from, select |
| C. | select, from |
| D. | from, where |
| Answer» B. from, select | |
| 20. |
Transaction is an action used to perform some manipulation on data stored in the____: |
| A. | Memory |
| B. | Record |
| C. | Database |
| D. | All of these |
| Answer» D. All of these | |
| 21. |
The three basic techniques to control deadlocks are: deadlock ____, deadlockdetection, and deadlock avoidance. |
| A. | prevention |
| B. | prohibition |
| C. | rollback |
| D. | Commits |
| Answer» B. prohibition | |
| 22. |
PJNF stands form: |
| A. | Practically –join normal form |
| B. | Project –join normal form |
| C. | Pages –join normal form |
| D. | programming –join normal form |
| Answer» C. Pages –join normal form | |
| 23. |
We can use the following three rules to find logically implied functional dependencies.This collection of rules is called |
| A. | Axioms |
| B. | Armstrong’s axioms |
| C. | Armstrong |
| D. | Closure |
| Answer» C. Armstrong | |
| 24. |
A domain is if elements of the domain are considered to be indivisible units. |
| A. | atomic |
| B. | subatomic |
| C. | substructure |
| D. | subset |
| Answer» B. subatomic | |
| 25. |
What type of join is needed when you wish to include rows that do not have matchingvalues? |
| A. | Equi-join |
| B. | Natural join |
| C. | Outer join |
| D. | All of the Mentioned |
| Answer» D. All of the Mentioned | |
| 26. |
The result of unknown is unknown. |
| A. | xor |
| B. | or |
| C. | and |
| D. | not |
| Answer» E. | |
| 27. |
A indicates an absent value that may exist but be unknown or that may not exist at all. |
| A. | empty tuple |
| B. | new value |
| C. | null value |
| D. | old value |
| Answer» D. old value | |
| 28. |
express the number of entities to which another entity can be associated via a relationship set. |
| A. | mapping cardinality |
| B. | relational cardinality |
| C. | participation constraints |
| D. | none of the mentioned |
| Answer» B. relational cardinality | |
| 29. |
clause is an additional filter that is applied to the result. |
| A. | select |
| B. | group-by |
| C. | having |
| D. | order by |
| Answer» D. order by | |
| 30. |
The Java specification defines an application programming interface for communication between the Web server and the application program. |
| A. | servlet |
| B. | server |
| C. | program |
| D. | randomize |
| Answer» B. server | |
| 31. |
Find all the cities with temperature, condition and humidity whose humidity is in the rangeof 63 to 79. |
| A. | SELECT * FROM weather WHERE humidity IN (63 to 79) |
| B. | SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) |
| C. | SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 |
| D. | SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 |
| Answer» D. SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 | |
| 32. |
In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Whichdependency have lead to this relation ? |
| A. | Dept name, year->size |
| B. | Year->size |
| C. | Dept name->size |
| D. | Size->year |
| Answer» B. Year->size | |
| 33. |
A dump of the database contents is also referred to as an dump. |
| A. | archival |
| B. | fuzzy |
| C. | sql |
| D. | all of the mentioned |
| Answer» B. fuzzy | |
| 34. |
A Stored Procedure is a |
| A. | Sequence of SQL or PL/SQL statements to perform specific function |
| B. | Stored in compiled form in the database |
| C. | Can be called from all client environments |
| D. | All of the above |
| Answer» E. | |
| 35. |
An attribute in a relation is a foreign key if the _______ key from one relation is used as anattribute in that relation. |
| A. | Candidate |
| B. | Primary |
| C. | Super |
| D. | Sub |
| Answer» C. Super | |
| 36. |
If we want to retain all duplicates, we must write in place of union. |
| A. | union all |
| B. | union some |
| C. | intersect all |
| D. | intersect some |
| Answer» B. union some | |
| 37. |
Representations such as the in the dept year relation, with one column for each value of an attribute, are called they are widely used in spreadsheets and reports and in data analysis tools. |
| A. | cross-tabs |
| B. | snapshot |
| C. | both cross-tabs and snapshot |
| D. | all of the mentioned |
| Answer» B. snapshot | |
| 38. |
After conversion of high level queries into low level commands for file access and is calledcompiled_____: |
| A. | DDL |
| B. | DML |
| C. | SDL |
| D. | VDL |
| Answer» C. SDL | |
| 39. |
Indices whose search key specifies an order different from the sequential order of thefile are called ___________ indices. |
| A. | Nonclustered |
| B. | Secondary |
| C. | All of the mentioned |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 40. |
The operator takes the results of two queries and returns only rows that appear in both result sets. |
| A. | union |
| B. | intersect |
| C. | difference |
| D. | projection |
| Answer» C. difference | |
| 41. |
Which of the following are the process of selecting the data storage and data accesscharacteristics of the database? |
| A. | Logical database design |
| B. | Physical database design |
| C. | Testing and performance tuning |
| D. | Evaluation and selecting |
| Answer» C. Testing and performance tuning | |
| 42. |
A relation between 2 set of attributes is called as |
| A. | Join dependency |
| B. | Association |
| C. | Functional Dependency |
| D. | Multivalued dependency |
| Answer» D. Multivalued dependency | |
| 43. |
Which company has developed the hierarchical model? |
| A. | Oracle |
| B. | IBM |
| C. | Sun MicroSystems |
| D. | Microsoft |
| Answer» C. Sun MicroSystems | |
| 44. |
has made PL/SQL code run faster without requiring any additional work on the part of the programmer. |
| A. | sql server |
| B. | my sql |
| C. | oracle |
| D. | sql lite |
| Answer» D. sql lite | |
| 45. |
The ............ operator preserves unmatched rows of the relations being joined. |
| A. | Inner join |
| B. | Outer join |
| C. | Union |
| D. | Union join |
| Answer» C. Union | |
| 46. |
Under which two circumstances do you design database triggers? (Choose two) |
| A. | To duplicate the functionality of other triggers. |
| B. | To replicate built-in constraints in the Oracle server such as primary key and foreign key. |
| C. | To guarantee that when a specific operation is performed, related actions are perform |
| Answer» D. | |
| 47. |
BCNF stands for: |
| A. | Basic -Codd normal form |
| B. | Build -Codd normal form |
| C. | Boyce-Codd normal form |
| D. | None of these |
| Answer» D. None of these | |
| 48. |
is a special type of stored procedure that is automatically invoked whenever the data in the table is modified. |
| A. | procedure |
| B. | trigger |
| C. | curser |
| D. | none of the mentioned |
| Answer» C. curser | |
| 49. |
The provision of _______ is a major objective for database system: |
| A. | Data independence |
| B. | Data consistency |
| C. | Data integration |
| D. | Data sharing |
| Answer» B. Data consistency | |
| 50. |
Trigger are not supported in |
| A. | Delete |
| B. | Update |
| C. | Views |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |