databases Online Quiz - 225

Description: databases Online Quiz - 225
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which type of view is implemented as a subquery embedded in the FROM clause of a SELECT statement and is identified by an alias?

  1. Simple

  2. Inline

  3. Complex

  4. Nested

Correct Option: B
  1. TRUNC=To_Date('09-Jan-02,DD-MON-YY,'YEAR',"Date" from Dual;

  2. Select TRUNC(To_Date('09-Jan-02,DD-MON-YY,YEAR')) "DATE" from Dual;

  3. Date =TRUNC(To_DATE('09-Jan-02','DD-MON-YY'),'YEAR'),'YEAR)"DATE: from DUAL;

  4. SELECT TRUNC(TO_DATE('12-Feb-99','DD-MON-YY'), 'YEAR') "Date " FROM DUAL;

Correct Option: D

Convert a date to a character expression

  1. SELECT SUBSTR ('HelloWorld',1) FROM dual;

  2. SELECT LOWER (SUBSTR ('HellowWorld', 2,1) FROM dual;

  3. SELECT INITCAP(TRIM('HellowWorld', 1,1) FROM dual;

  4. SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

Correct Option: D
  1. Immediately after the SELECT clause

  2. Before the WHERE clause

  3. After the ORDER BY clause

  4. After the WHERE clause

Correct Option: D
  1. restrict data access

  2. easy maintainance of complex queries

  3. fast access

  4. data independence

Correct Option: C

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

  1. control files

  2. redo log files

  3. user_views data dictionary view

  4. base table

Correct Option: C

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

  1. varchar2()

  2. long

  3. char()

  4. lob()

Correct Option: B

simple view definition contains functions.....

  1. True

  2. False

Correct Option: B

which one is not the view feature..?

  1. restrict data access

  2. fast access

  3. easy maintainance for complex queries

  4. data independence

Correct Option: B

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

  1. user_views

  2. all_views

  3. user_updatable_columns

  4. dba_views

Correct Option: C
  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

Correct Option: D

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

  1. True

  2. False

Correct Option: A
  1. 999

  2. 1000

  3. 1001

  4. limit is only for tables....

Correct Option: B
  1. drop the view and create a new one

  2. use CREATE OR REPLACE syntax

  3. use ALTER VIEW syntax

  4. use UPDATE sytax

Correct Option: B

An NPS 10600 has how many SPU's

  1. True

  2. False

Correct Option: A

In NPS, you can ALTER DATABASE while other people are accessing the same database

  1. No

  2. Yes

  3. 1

  4. 0

Correct Option: A
- Hide questions