Database Management System - DBMS Objective Questions | MCQ Quiz for Practice

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

71. ………………… is a full form of SQL.

1. Structured query language
2. Standard query language
3. Sequential query language
4. Server side query language

72. FDs are the types of constraints that are based on………………

1. Superset key
2. Key
3. Key revisited
4. None of these

73. ……………… table store information about database or about the system.

1. System
2. SQL
3. Nested
4. None of these

74. What is a virtual table

1. Table
2. Stored procedure
3. View
4. Rules

75. SQL outputs a single table known as the………………

1. Tablespace
2. View
3. Column
4. Result set