DBMS Quiz Question with Answer


11. A data manipulation command the combines the records from one or more tables is called

  1. SELECT
  2. PROJECT
  3. JOIN
  4. PRODUCT

12. Which of the following is a legal expression in SQL?

  1. SELECT NULL FROM EMPLOYEE;
  2. SELECT NAME FROM EMPLOYEE;
  3. SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
  4. None of the above

13. AS clause is used in SQL for

  1. Selection operation.
  2. Rename operation.
  3. Join operation.
  4. Projection operation.

14. The users who use easy-to-use menu are called

  1. Sophisticated end users.
  2. Naïve users.
  3. Stand-alone users.
  4. Casual end users.

15. It is better to use files than a DBMS when there are

  1. Stringent real-time requirements.
  2. Multiple users wish to access the data.
  3. Complex relationships among data.
  4. All of the above.

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

  1. strong entity set.
  2. weak entity set.
  3. simple entity set.
  4. primary entity set.

17. A DBMS query language is designed to

  1. support end users who use English-like commands.
  2. support in the development of complex applications software.
  3. specify the structure of a database.
  4. all of the above.

18. The DBMS language component which can be embedded in a program is

  1. The data definition language (DDL).
  2. The data manipulation language (DML).
  3. The database administrator (DBA).
  4. A query language.

19. Which one of the following statements is false?

  1. The data dictionary is normally maintained by the database administrator.
  2. Data elements in the database can be modified by changing the data dictionary.
  3. The data dictionary contains the name and description of each data element.
  4. The data dictionary is a tool used exclusively by the database administrator.

20. A subschema expresses

  1. the logical view.
  2. the physical view.
  3. the external view.
  4. all of the above.

Tags :


Multiple Choice Questions and Answers on DBMS


DBMS Multiple Choice Questions and Answers


DBMS Trivia Quiz


DBMS Question and Answer PDF Online




Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....