Database Management System (DBMS)

231. Which operation are allowed in a join view:

1. UPDATE
2. INSERT
3. DELETE
4. All of these

View answer

232. The materialized view was introduced by:

1. Oracle 6
2. Oracle 7
3. Oracle 8
4. Oracle 9

View answer

233. We can delete from join view provided there is ___________ key preserved table in the join:

1. One and Only One
2. One and Two
3. Two and One
4. None of these

View answer

234. Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

1. Join view
2. Datable join view
3. Updatable join view
4. All of these

View answer

235. Which option is used to create a view as a constrained view and prohibit specific insert and update operations with the view:

1. DATABASE
2. WITH CHECK OPTION
3. WITH WRITE OPTION
4. WITH OPTION

View answer

236. Which command is used to add the views to the database:

1. DATABASE VIEW
2. CREATE VIEW
3. CREATE OPTION
4. None of these

View answer

237. Which option is used with the WHERE clause:

1. DATABASE
2. WITH CHECK OPTION
3. WITH WRITE OPTION
4. WITH OPTION

View answer

238. Which option may be used to create the inline view as a constrained view:

1. DATABASE
2. WITH CHECK OPTION
3. WITH WRITE OPTION
4. WITH OPTION

View answer

239. In which year ORACLE, an SQL product was released:

1. 1976
2. 1977
3. 1978
4. 1979

View answer

240. The prototype for SQL was originally developed by:

1. INTEL
2. APPLE
3. IBM
4. All of these

View answer