Database Management System - DBMS Multiple Choice Questions and Answers

141. Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called………………

1. Second normal form
2. Boyce-Codd normal form
3. First normal form
4. All of these

142. ................ requires that data should be made available to only authorized users.

1. Security
2. Data integrity
3. Privacy
4. None of the above

143. The statement in SQL which allows to change the definition of a table is

1. Select
2. Create
3. Alter
4. Update

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

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

145. 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

146. 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

147. The SQL statement to create a view is:

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

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

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

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

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

150. 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