Tag: databases

Questions Related to databases

which one is not the view feature..? ( choose one)
technology databases

  1. restrict data access

  2. easy maintainance of complex queries

  3. fast access

  4. data independence

Show answer
Correct Option: C

When 'select * from ' is given, oracle server checks for..
technology databases

  1. control files

  2. redo log files

  3. user_views data dictionary view

  4. base table

Show answer
Correct Option: C

data type of 'text' column stored in user_view column...
technology databases

  1. varchar2()

  2. long

  3. char()

  4. lob()

Show answer
Correct Option: B

simple view definition contains functions.....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

which one is not the view feature..?
technology databases

  1. restrict data access

  2. fast access

  3. easy maintainance for complex queries

  4. data independence

Show answer
Correct Option: B

Which one is useful to check whether the columns in a join view can be updated...?
technology databases

  1. user_views

  2. all_views

  3. user_updatable_columns

  4. dba_views

Show answer
Correct Option: C

Which one is correct statement about inline views....?
technology databases

  1. inline view is a schema object

  2. is a subquery used in where clause

  3. inline view can't have group functions

  4. none of the above

Show answer
Correct Option: D

'ORDER BY' clause can be used in the creation of a view..?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

The maximum columns that can present in a view..?
technology databases

  1. 999

  2. 1000

  3. 1001

  4. limit is only for tables....

Show answer
Correct Option: B

How to change the definition of a view in a simple way..?
technology databases

  1. drop the view and create a new one

  2. use CREATE OR REPLACE syntax

  3. use ALTER VIEW syntax

  4. use UPDATE sytax

Show answer
Correct Option: B