DBMS Questions and Answers | Online Quiz for Practice

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

1. Cartesian product
2. Difference
3. Intersection
4. Product

47. The natural join is equal to :

1. Cartesian Product
2. Combination of Union and Cartesian product
3. Combination of selection and Cartesian product
4. Combination of projection and Cartesian product

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

1. CHARACTER
2. NUMERIC
3. FLOAT
4. All of the above

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

1. Child
2. Owner
3. Dominant
4. All of the above

50. The view of total database content is

1. Conceptual view.
2. Internal view.
3. External view.
4. Physical View.

51. Relational Algebra is

1. Data Definition Language .
2. Meta Language
3. Procedural query Language
4. None of the above

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

1. data file.
2. data record.
3. menu.
4. bank.

53. An advantage of the database management approach is

1. data is dependent on programs.
2. data redundancy increases.
3. data is integrated and can be accessed by multiple programs.
4. none of the above.

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

1. Data security
2. Derived columns
3. Hiding of complex queries
4. All of the above

55. The conceptual model is

1. dependent on hardware.
2. dependent on software.
3. dependent on both hardware and software .
4. independent of both hardware and software.

56. DML is provided for

1. Description of logical structure of database.
2. Addition of new structures in the database system.
3. Manipulation & processing of database.
4. Definition of physical structure of database system.

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

1. Direct
2. Hash
3. Random
4. Sequential

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

1. direct.
2. hash.
3. random.
4. sequential.

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

1. DML
2. DDL
3. VDL
4. SDL

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

1. Dotted rectangle.
2. Diamond
3. Doubly outlined rectangle
4. None of these