Computer Operator
Database System – Set 5
Dear ! This is Database System – Set 5 Quiz and it contains 50 questions.
1 / 50
1. Which of the following is not a storage Manager Component ?
2 / 50
2. DROP is a …………. statement in sql.
3 / 50
3. Dependency preservation is not guaranteed in
4 / 50
4. Which of the following is not a recovery technique ?
5 / 50
5. The statement that is executed automatically by the system as a side effect of the modification of the database is
6 / 50
6. Relations produced from an E-R model will always be
7 / 50
7. Isolation of the transaction is ensured by
8 / 50
8. Which of the following is not a characteristic of a relational database model ?
9 / 50
9. The value of the attribute describes a particular ………………………
10 / 50
10. Isolation of the transaction is ensured by
11 / 50
11. The keyboard to eliminate duplicate rows from the query results in SQL is
12 / 50
12. Which of the following is not an schema ?
13 / 50
13. Which two files are used during operation of the DBMS ?
14 / 50
14. The normalization was first proposed by ………….
15 / 50
15. Which of the following represents a relationships among a set of values
16 / 50
16. Which of the following aggregate functions does not ignore nulls in its results?
17 / 50
17. The clause alter table in SQL can be used to
18 / 50
18. Which of the following constitutes a basic set of operations for manipulating relational data ?
19 / 50
19. What is data integrity?
20 / 50
20. Which one of the following is set of one or more attributes taken collectively to uniquely identify a record ?
21 / 50
21. A list consists of last names , first names , addresses and pin codes. if all people in the list have the same last name and same pin code a useful key would be
22 / 50
22. Which of the following is true for network structure?
23 / 50
23. For each attribute of a relation, there is a set permitted values , called the ———— of that attribute.
24 / 50
24. If the closure of an attribute set is the entire relation then the attribute set is a
25 / 50
25. A table can have only one
26 / 50
26. A relational is an ………….. if an attribute of a composite key is dependent on an attribute of other composite key .
27 / 50
27. The data models defined by ANSI/SPARC architecture are
28 / 50
28. A table can have only one
29 / 50
29. Disadvantages of File systems to store is :
30 / 50
30. Manager salary details are hidden from the employee . This is
31 / 50
31. Which of the following is not a level of data abstraction ?
32 / 50
32. Operator is used to compare a value to a list of literals values that have been specified
33 / 50
33. The part of a database management system which ensures that the data remains in a consistent state is
34 / 50
34. Data Manipulation Language enables users to
35 / 50
35. Which of the following is a Data Model ?
36 / 50
36. A Database Management System (DBMS) is
37 / 50
37. Union operator is a :
38 / 50
38. Which is the best file organization when data is frequently added or deleted from a file?
39 / 50
39. In an Entity-Relationship Diagram Rectangles represents
40 / 50
40. Relationships among relationships can be represented in an E-R model using
41 / 50
41. Wait-for graph is used for
42 / 50
42. A ——– is a property of the entire relation, rather than of the individual tuples in which each tuple is unique
43 / 50
43. Column header is refer as
44 / 50
44. The graphical representation of a query is ……….
45 / 50
45. In a multi-user database , if two users wish to update the same record at the same time , they are prevented from doing so by
46 / 50
46. The default level of consistency in SQL is
47 / 50
47. The clause in SQL that specifies that the query results should be sorted in ascending or descending order based on the value of one or more columns is
48 / 50
48. An advantage of view is
49 / 50
49. Which normal form is considered adequate for normal relational database design ?
50 / 50
50. Dependency preservation is not guaranteed in
Your score is
Restart quiz Exit
You cannot copy content of this page