Database Management System Quick Study Episode- 03

Test your knowledge now with our Online Quizzes, Q&A and MCQs! Database Management System Quick Study Episode- 03. Take part in an interactive quiz experience with our online quizzes, Q&A and MCQs. Try it out now Online Quiz, Q&A & MCQ.

Table of Contents

1. Which of the following is not a characteristic of a relational database model?

a. Table

b. Tree like structure

c. Complex logical relationship

d. Records

1. Which of the following is not a characteristic of a relational database model?

2. Field is otherwise called as ……… of the record

3. A table can have only one

4. A field can be called as ……….. in relation context.

5. In the relational modes, cardinality is termed as

6. The …….. is used for creating and destroying table, indexes and other forms of structures.

7. The view of total database content is

8. The ………… refers to the way data is organized in and accessible from DBMS.

9. Architecture of the database can be viewed as

10. …….. introduced the relational database rules.

11. In a relational model, relations are termed as

12. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n) ……..

13. In the architecture of a database system external level is the

14. A functional dependency is a relationship between or among …….

15. Related fields in a database are grouped to form a

16. ………. is, a table have more than one set of attributes that could be chosen as the key

17. The database environment has all of the following components except.

18. The operation of eliminating columns in a table done by …….. operation.

19. The way a particular application views the data from the database that the application uses is a

20. ……. is a condition specified on a database schema and restricts the data that can be stored in an instance of the database.

21. A relational database developer refers to a record as

22. ………. keyword is used to find the number of values in a column.

23. An advantage of the database management approach is

24. The collection of information stored in a database at a particular moment is called as ……

25. Data independence means

26. A ……… is used to define overall design of the database

27. Key to represent relationship between tables is called

28. Grant and revoke are ……. statements.

29. DBMS helps achieve

30. ………. command can be used to modify a column in a table

31. The RDBMS terminology for a row is

32. To change column value in a table the ……… command can be used.

33. The full form of DDL is

34. To pass on granted privileges to other user the …… clause is used

35. A set of possible data values is called

36. ……… is critical in formulating database design.

37. A primary key if combined with a foreign key creates

38. A …………. represents the number of entities to which another entity can be associated

39. Which two files are used during operation of the DBMS

40. A ……….. is a set of column that identifies every row in a table.

41. The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

42. Which two files are used during operation of the DBMS?

43. The database schema is written in

44. The way a particular application views the data from the database that the application uses is a

45. The relational model feature is that there

46. Which one of the following statements is false?

47. Which of the following are the properties of entities?

48. Which database level is closest to the users?

49. Which are the two ways in which entities can participate in a relationship?

50. …….. data type can store unstructured data

51. What is a data integrity?

52. As per equivalence rules for query transformation, selection operation distributes over

53. In SQL the word ‘natural’ can be used with

54. Which of the following relational algebraic operations is not from set theory?

55. An entity set that does not have sufficient attributes to form a primary key is a

56. In case of entity integrity, the primary key may be

57. A logical schema

58. Which of the operations constitute a basic set of operations for manipulating relational data?

59. Which of the following is another name for weak entity?

60. Which of the following is record based logical model?

61. A file manipulation command that extracts some of the records from a file is called

62. In E-R Diagram derived attribute are represented by

63. The natural join is equal to

64. In E-R diagram relationship type is represented by

65. In E-R diagram generalization is represented by

66. A table joined with itself is called

67. ……….. means multiple copies of the same data items.

68. Different values for the same data item is referred to as …….

69. The ………. returns row after combining two tables based on common values.

70. The ………. can be used to ensure database integrity.

71. Which of the following is not a recovery technique?

72. Checkpoints are a part of

73. ……. deals with soft errors, such as power failures.

74. ……….. is an essential part of any backup system.

75. Media recovery deals with ………..

76. For a backup/restore system, …………. is a prerequisite for service in a enterprise.

77. Failure recovery and media recovery fall under ……..

78. The ………. consists of the various applications and database that play a role in a backup and recovery strategy.

79. In which the database can be restored up to the last consistent state after the system failure?

80. A ……….. is a block of Recovery Manager(RMAN)job commands that is stored in the recovery catalog.