DBMS MCQ Multiple Choice Questions Answers - Page 2 for Practice

31. A report generator is used to

32. The database environment has all of the following components except:

33. Count function in SQL returns the number of

34. It is possible to define a schema completely using

35. _________ is a virtual table that draws its data from the result of an SQLSELECT statement.

36. Which one of the following is not true for a view:

37. A relational database developer refers to a record as

38. Which of the following is correct:

39. Cartesian product in relational algebra is

40. The result of the UNION operation between R1 and R2 is a relation that includes

41. The statement in SQL which allows to change the definition of a table is

42. A set of possible data values is called

43. Which of the following database object does not physically exist?

44. The ______ operator is used to compare a value to a list of literals values that have beenspecified.

45. The physical location of a record is determined by a mathematical formula that trAnsformsa file key into a record location is :

46. _______ produces the relation that has attributes of R1 and R2

47. The natural join is equal to :

48. Which of the following is a valid SQL type?

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

50. The view of total database content is

51. Relational Algebra is

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

53. An advantage of the database management approach is

54. Which of the following is an advantage of view?

55. The conceptual model is

56. DML is provided for

57. The method of access which uses key trAnsformation is known as

58. The method of access which uses key transformation is known as

59. The language used in application programs to request data from the DBMS is referred to as the

60. E-R model uses this symbol to represent weak entity set ?


Tags

Multiple Choice Questions and Answers on DBMS

DBMS Multiple Choice Questions and Answers

DBMS Trivia Quiz

DBMS Question and Answer PDF Online