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