Database Management System – Set 4

0%

Report a question

You cannot submit an empty report. Please add some details.

Database Management System – Set 4

Dear ! This is Database Management System – Set 4 Quiz and it contains 50 questions.


Keep Learning!

1 / 50

1) Which of the following is another name for week entity ?

2 / 50

2) E- R model uses this symbol to represent weak entity set ?

3 / 50

3) A set of possible data values is called

4 / 50

4) Which of the following is an advantage of view ?

5 / 50

5) In a relation

6 / 50

6) In creating a database , this is the process of organizing it into tables in such a way that the results of using the database are always unambiguous .

7 / 50

7) In a Hierarchical model records are organized as

8 / 50

8) Which statements are used to UNLOCK the user ?

9 / 50

9) In an E-R diagram an entity set is represent by a

10 / 50

10) The method of access which uses key transformation is known as

11 / 50

11) An advantage of the database management approach is

12 / 50

12) This family of products is IBM’s cross – platform relational database management system.

13 / 50

13) Relational calculus is a

14 / 50

14) Which database level is closed to the users ?

15 / 50

15) This is a collection of data items organized as a set of formally – described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables .

16 / 50

16) The statement in SQL which allows to change the definition of a table is

17 / 50

17) SET concept is used in :

18 / 50

18) For which two constraints are indexes created `when the constraint is added ?

19 / 50

19) The conceptual model is

20 / 50

20) Which of the following database object does not physically exist ?

21 / 50

21) Which two files are used during operation of the DBMS ?

22 / 50

22) A relational database developer refers to a record as

23 / 50

23) The language used in application programs to request data from the DBMS is referred to as the

24 / 50

24) Which of the following is valid SQL type ?

25 / 50

25) 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

26 / 50

26) The language which has recently become the de-facto standard for interfacing application programs with relational database system is

27 / 50

27) Which of the following are the properties of entities ?

28 / 50

28) Which type of file is part of the oracle database ?

29 / 50

29) Which are the physical structures that constitute the oracle database ?

30 / 50

30) What is the type of oracle backup in which all uncommitted changes have been removed from the Data files ?

31 / 50

31) Key to represent relationship between tables is called

32 / 50

32) In case of entity integrity , the primary key may be

33 / 50

33) A subschema expresses

34 / 50

34) Relational calculus is a

35 / 50

35) The database environment has all of the following components except :

36 / 50

36) DML is provided for

37 / 50

37) When is the SGA created in an oracle database environment ?

38 / 50

38) DBMS helps to achieve

39 / 50

39) Which privilege is required to create a database ?

40 / 50

40) ………………… produces the relation that has attributes of R1 and R2

41 / 50

41) In the relational models , cardinality is termed as :

42 / 50

42) ‘AS’ clause is used in SQL for

43 / 50

43) In the relational modes , cardinality is termed as :

44 / 50

44) ………….. data type can store unstructured data

45 / 50

45) This is an open standard application programming interface (API) for accessing a database.

46 / 50

46) ODBC stands for

47 / 50

47) Count function in SQL return the number of

48 / 50

48) In an E-R diagram environment has all of the following components except :

49 / 50

49) The view of total database content is

50 / 50

50) What type of failure occurs when oracle fails due to an operating system or computer hardware failure ?

Your score is

The average score is 0%

🎉 Challenge alert! 💡 Share this quiz with your friends and see who scores the highest! 🏆🤩🔥
LinkedIn Facebook
0%

Exit

We’d love to hear your thoughts! 📝 Share your valuable review with us. 🙌

🌟 Thank you for your support! Your feedback means the world to us. 🙏💖

You cannot copy content of this page