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