DBMS Objective Questions | MCQ Quiz for Practice

61. The full form of DDL is

1. Data Derivation Language
2. Dynamic Data Language
3. Detailed Data Language
4. Data Definition Language

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

1. Triangle
2. Ellipse
3. Dashed ellipse
4. Rectangle

63. In E-R Diagram relationship type is represented by

1. Diamond
2. Ellipse
3. Dashed ellipse
4. Rectangle

64. In E-R diagram generalization is represented by

1. Triangle
2. Ellipse
3. Dashed ellipse
4. Rectangle

65. Which of the following is a comparison operator in SQL?

1. All of the above
2. Equals To
3. LIKE
4. BETWEEN

66. Which database level is closest to the users?

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

67. In a Hierarchical model records are organized as

1. Tree.
2. Graph.
3. List.
4. Links.

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

1. all of the above.
2. hash.
3. direct.
4. sequential.

69. The database schema is written in

1. DCL
2. HLL
3. DML
4. DDL

70. Conceptual design

1. is designing the relational model.
2. is a documentation technique.
3. needs data volume and processing frequencies to determine the size of the database.
4. involves modelling independent of the DBMS.

71. The relational model feature is that there

1. are tables with many dimensions.
2. is no need for primary key data.
3. is much more data independence than some other database models.
4. are explicit relationships among records.

72. A logical schema

1. none of these
2. is the entire database
3. is a standard way of organizing information into a accessible part
4. describe how data is actually stored on disk

73. A logical schema

1. both B and C
2. is the entire database.
3. is a standard way of organizing information into accessible parts.
4. describes how data is actually stored on disk.

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

1. All of the above.
2. It is an integrated collection of logically related records.
3. It consolidates separate files into a common pool of data records.
4. Data stored in a database is independent of the application programs using it.

75. A table joined with itself is called

1. Equi Join
2. Join
3. Self Join
4. Outer Join