Database Management System - DBMS MCQ Questions and Answers Quiz

61. What is used to retrieve tuples from the relation.

  1. Select
  2. Create
  3. Drop
  4. All of the above

62. To select all column from the table the syntax is:

  1. Select from table_name
  2. Select all from table_name
  3. Select * from table_name
  4. Non of the above

63. To select all columns from the table the syntax is:

  1. Select from table_name
  2. Select all from table_name
  3. Select * from table_name
  4. Non of the above

64. The SQL statement to create a view is:

  1. SELECT VIEW
  2. CREATE VIEW
  3. MAKE VIEW
  4. INSERT VIEW

65. System analyst and application programmers are commonly referred to as …………………….

  1. Software engineers
  2. Naïve users
  3. Casual users
  4. Programmers

66. Which are the not user in End-user:

  1. Sophisticated user
  2. Naïve users
  3. Casual users
  4. All of these

67. Who access the database occasionally and have different needs each time:

  1. Sophisticated user
  2. Naïve users
  3. Casual users
  4. All of these

68. Who interact with the system by invoking one of the permanent application program:

  1. Sophisticated user
  2. Naïve users
  3. Casual users
  4. All of these

69. Who interact with the system without writing a program:

  1. Sophisticated user
  2. Naïve users
  3. Casual users
  4. All of these

70. …………………… is the process of organizing data into related tables.

  1. Specialization
  2. Normalization
  3. Generalization
  4. None of the above
Tags

MCQ Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Trivia Questions and Answers PDF

Database Management System - DBMS Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....