Computer Operator
Database System – Set 3
Dear ! This is Database System – Set 3 Quiz and it contains 50 questions.
1 / 50
1. Which type of file is part of the oracle database ?
2 / 50
2. A subschema expresses
3 / 50
3. Which are the physical structures that constitute the oracle database ?
4 / 50
4. What is the type of oracle backup in which all uncommitted changes have been removed from the Data files ?
5 / 50
5. ………………… produces the relation that has attributes of R1 and R2
6 / 50
6. This is an open standard application programming interface (API) for accessing a database.
7 / 50
7. In an E-R diagram an entity set is represent by a
8 / 50
8. ………….. data type can store unstructured data
9 / 50
9. In a Hierarchical model records are organized as
10 / 50
10. Which of the following is an advantage of view ?
11 / 50
11. The method of access which uses key transformation is known as
12 / 50
12. In an E-R diagram environment has all of the following components except :
13 / 50
13. Which statements are used to UNLOCK the user ?
14 / 50
14. SET concept is used in :
15 / 50
15. An advantage of the database management approach is
16 / 50
16. DBMS helps to achieve
17 / 50
17. The conceptual model is
18 / 50
18. In the relational modes , cardinality is termed as :
19 / 50
19. Which of the following operation is used if we are interested in only certain columns of a table
20 / 50
20. Which of the following are the properties of entities ?
21 / 50
21. Which privilege is required to create a database ?
22 / 50
22. The statement in SQL which allows to change the definition of a table is
23 / 50
23. Relational calculus is a
24 / 50
24. Which are the two ways in which entities can participate in a relationship ?
25 / 50
25. Key to represent relationship between tables is called
26 / 50
26. Relational calculus is a
27 / 50
27. ODBC stands for
28 / 50
28. Which of the following is valid SQL type ?
29 / 50
29. Which two files are used during operation of the DBMS ?
30 / 50
30. The database environment has all of the following components except :
31 / 50
31. The view of total database content is
32 / 50
32. For which two constraints are indexes created `when the constraint is added ?
33 / 50
33. This is a collection of descriptions about data objects that is created for the benefit of programmers and others who might need to refer to them
34 / 50
34. Which of the following database object does not physically exist ?
35 / 50
35. Which of the following is another name for week entity ?
36 / 50
36. DML is provided for
37 / 50
37. The language which has recently become the de-facto standard for interfacing application programs with relational database system is
38 / 50
38. In a relation
39 / 50
39. A relational database developer refers to a record as
40 / 50
40. Which database level is closed to the users ?
41 / 50
41. This family of products is IBM’s cross – platform relational database management system.
42 / 50
42. E- R model uses this symbol to represent weak entity set ?
43 / 50
43. The language used in application programs to request data from the DBMS is referred to as the
44 / 50
44. What type of failure occurs when oracle fails due to an operating system or computer hardware failure ?
45 / 50
45. When is the SGA created in an oracle database environment ?
46 / 50
46. Count function in SQL return the number of
47 / 50
47. In the relational models , cardinality is termed as :
48 / 50
48. A set of possible data values is called
49 / 50
49. ‘AS’ clause is used in SQL for
50 / 50
50. In case of entity integrity , the primary key may be
Your score is
Restart quiz Exit
You cannot copy content of this page
