Computer Science Database 100 Most Repeated MCQS

Computer Science Database 100 Most Repeated MCQS For Competitive Exams

For more MCQS download our Android Mobile App PakTest MCQs:

1. A Database Management System (DBMS) is ____.
2. Which of the following is not a level of data abstraction?
3. Disadvantages of File systems to store data is ____.
4. In an Entity-Relationship Diagram Rectangles represents ____.
5. Which of the following is not a Storage Manager Component?
6. Data Manipulation Language enables users to ____.
7. Which of the following is not an Schema?
8. Which of the following is Database Language?
9. Which of the following in not a function of DBA?
10. Which of the following is a Data Model?
11. Which of the following represents a relationship among a set of values?
12. Column header is refer as ____.
13. A relation is a ____.
14. In mathematical term "Table" is referred as ____.
15. In mathematical term "Row" is referred as ____.
16. ____ allow us to identify uniquely a tuple in the relation.
17. Minimal Super keys are called ____.
18. Which of the following is not modification of the Database?
19. Which of the following is relation-algebra operation?
20. Which of the following in not outer join?
21. Who proposed the relational model?
22. Set of premitted values of each attribute is called ____.
23. Which of the following in true regarding Null value?
24. Logical design of database is called ____.
25. Snapshot of the data in the database at a given instant of time is called ____.
26. Which of the following is not unary operation?
27. Which of the following is not binary operation?
28. Which of the following is correct regarding aggregate functions?
29. The primary key must be ____.
30. A command to remove a table from an SQL database ____.
31. Which of the following is not an aggregate function?
32. The attribute that can be divided into other attributes is called ____.
33. In an Entity-Relationship Diagram "Ellipses" represents ____.
34. In an entity-relationship diagram "Diamonds" represents ____.
35. What is ACID properties of transactions?
36. If every non-key attribute is functionally dependent on the primary key, the relation will be in ____.
37. Database locking concept is used to solve the problem of ____.
38. UML is stands for ____.
39. Data Manipulation Language (DML) is not to ____.
40. Which of the following in true regarding referential integrity?
41. Which of the following option is use to retrieval of data?
42. ODBC stands for ___ .
43. Which algebra is widely used in DBMS?
44. Which of the following is an unary operation?
45. Which SQL Query is use to remove a table and all its data from the database?
46. In precedence of set operators the expression is evaluated from ___.
47. In DBMS FD stands for ___ .
48. How many types of keys in Database Design?
49. Which of the following is based on Multi Valued Dependency?
50. Which of the following is the structure of the Database?
51. The minimal set of super key is called ___ .
52. A relation that has no partial dependencies is in which normal form ___.
53. A functional dependency between two or more non-key attributes is called ___.
54. A logical description of some portion of database that is required by a user to perform task is called as ___.
55. Which is a classical approach to database design?
56. What refers to the correctness and completeness of the data in a database?
57. A table that displays data redundancies yields ___ anomalies.
58. A lock that allows concurrent transactions to access different rows of the same table is known as a ___.
59. A type of query that is placed within a WHERE or HAVING clause of another query is called ___.
60. A transaction completes its execution is said to be ___.
61. When converting one (1) to many (N) binary relationship into tables, the recommended solution is usually ___.
62. Which of the following is not correct?
63. The property of transaction which ensures that either all operations of the transaction are reflected properly in the database or none, is called ___.
64. Which of the following is correct?
65. An entity type whose existence depends on another entity type is called a ___ entity.
66. A property or characteristic of an entity type that is of interest to the organization is called an ___.
67. A relationship between the instances of a single entity type is called a ___ relationship.
68. ___ attribute is an attribute that can be further subdivided to yield additional attributes.
69. In a super type/subtype hierarchy, each subtype has __.
70. The hierarchical database model uses the hierarchic sequence that always starts at ___.
71. Which of the following is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated?
72. A null value is created or represented by ___.
73. A functional dependency between two or more non-key attributes is called ___.

and more MCQs...