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