DBMS MCQ Multiple Choice Questions Answers - Page 2 for Practice

31. In a Hierarchical model records are organized as

32. The method in which records are physically stored in a specified order according to a keyfield in each record is

33. The database schema is written in

34. Conceptual design

35. The relational model feature is that there

36. A logical schema

37. A logical schema

38. The property / properties of a database is / are :

39. A table joined with itself is called

40. A B-tree of order m has maximum of _____________ children

41. Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:

42. The way a particular application views the data from the database that the applicationuses is a

43. SET concept is used in :

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

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

46. In the relational modes, cardinality is termed as:

47. ODBC stands for

48. The language which has recently become the defacto standard for interfacing applicationprograms with relational database system is

49. A primary key is combined with a foreign key creates

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

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

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

53. _____________ function divides one numeric expression by another and returns theremainder.

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

55. Key to represent relationship between tables is called

56. Relational calculus is a

57. Transaction processing is associated with everything below except

58. Which of the following operation is used if we are interested in only certain columns of atable?

59. _________ data type can store unstructured data

60. In an E-R diagram attributes are represented by


Tags

Multiple Choice Questions and Answers on DBMS

DBMS Multiple Choice Questions and Answers

DBMS Trivia Quiz

DBMS Question and Answer PDF Online