0

databases Online Quiz - 7

Description: databases Online Quiz - 7
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. selects all the rows from the table having the column_xyz value starting with the word oracle

  2. selects all the rows from the table having the column_xyz value ending with the word oracle

  3. selects all the rows from the table having the column_xyz value containing the word oracle

  4. selects all the rows from the table having the column_xyz value not containing the word oracle


Correct Option: C
  1. abs(-123.456)

  2. trunc(123.456,2)

  3. round(123.456,2)

  4. avg(1,2,3,4,5)


Correct Option: C

What does initcap('oracle') return?

  1. O

  2. oracle

  3. Oracle

  4. ORACLE


Correct Option: C

What does the function next_day('14-mar-2001','tuesday') return?

  1. '14-mar-2002'

  2. '13-mar-2001'

  3. '20-mar-2001'

  4. '14-apr-2001'


Correct Option: C
  1. removes the time component from a date_time value

  2. removes the date component from a date_time value

  3. removes the day component from a date_time value

  4. removes the year component from a date_time value


Correct Option: A
  1. to_date(string,format)

  2. to_char(date,format)

  3. to_date(date,format)

  4. to_number(string,format)


Correct Option: B
  1. % processor time >80

  2. % processor time <80

  3. Processor queue length>2

  4. Batch request/sec

  5. sql compilation./sec

  6. sql recompilation/sec


Correct Option: B,D,E,F
  1. network

  2. relational

  3. hierarchical

  4. object-oriented


Correct Option: C
  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management


Correct Option: A
  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN


Correct Option: D

What information is not included in DBD

  1. access method

  2. segment name

  3. parameter

  4. key field length


Correct Option: C

IMS Db uses what kind of database management

  1. network

  2. relational

  3. hierarchical

  4. object-oriented


Correct Option: C
  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management


Correct Option: A

Which of the following is true about DBD ?

  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN


Correct Option: D

A segment has 3 occurrences for a parent. This segment is called a

  1. multiple

  2. twin

  3. sibling

  4. none of these


Correct Option: B

What information is not included in DBD

  1. access method

  2. segment name

  3. parameter

  4. key field length


Correct Option: C

IMS Db uses what kind of database management

  1. network

  2. relational

  3. hierarchical

  4. object-oriented


Correct Option: C

What is the advantage of IMS DB?

  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management


Correct Option: A
- Hide questions