0

databases Online Quiz - 223

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

I am working on manager number field on some table. which is correct usage of nvl function usage....?

  1. nvl(mgrno,0)

  2. nvl(mgrno,'none')

  3. nvl('mgrno',0)

  4. nvl(mgrno,'0')


Correct Option: A

Where do I need to configure to tell how oracle operates while it is running...?

  1. control files

  2. password files

  3. parameter files

  4. redo logs


Correct Option: C

find the SGA components

  1. buffer cache

  2. large pool

  3. java pool

  4. all the above


Correct Option: D

Distinct keyword must appear directly after the select keyword in SQL Query....

  1. True

  2. False


Correct Option: A

Which statements excute without error(select all)

  1. select ename||',is the'||job from emp

  2. select ename,||'is the||job from emp

  3. select 'ename'||'is the'||'job' from from emp

  4. select ename||concat('is the',job) from emp


Correct Option: A,C
  1. Source file

  2. Directories

  3. Binary files

  4. All the above


Correct Option: D

What is a Configuration Specification

  1. It is a dynamic view.

  2. It is a rule determine which versions of an element are visible in the new view

  3. None of the above.

  4. All of the above.


Correct Option: B

What is the operation to get a file from ClearCase

  1. Check-In

  2. Check-Out

  3. Deliver

  4. Retrieve


Correct Option: B
  1. A new version of the file will be added

  2. The current version will be updated

  3. The current version of the file will be deleted

  4. None


Correct Option: A

How do you propogate changes from one Branch to other

  1. By Merging

  2. By Sub Branching

  3. By Creating a view

  4. None of the above


Correct Option: A

How do we create branches using command line

  1. Makebranch

  2. Mkbranch

  3. Mhbr

  4. None of the above


Correct Option: B

What is the goal of Merging

  1. To enable parallel development

  2. To Enable single user development

  3. To Enable multi site development

  4. None of the above


Correct Option: A

VOB stands for

  1. Versioned object basic

  2. Very old basis

  3. Versioned object base

  4. None


Correct Option: C

Versioned object base

  1. Single Project

  2. Multiple project

  3. Multiple projects of same type

  4. None of the above


Correct Option: B

Whar are the different type of Views

  1. Snapshot

  2. Dynamic

  3. Multi Dynamic

  4. Recursive


Correct Option: A
  1. Dynamic

  2. Snapshot

  3. Both a & b

  4. None


Correct Option: A

What are the different type of Check-Out operations

  1. Reserved

  2. Un-reserved

  3. Both a & b

  4. None


Correct Option: C

Whar are the advantages of Branching

  1. It allows different projects to use the same source at the same time

  2. It allows changes across multiple elements to be logically grouped together

  3. It controls public/private work

  4. All the above


Correct Option: A
  1. Trivial

  2. Non-Trivial

  3. Automatic

  4. All the above


Correct Option: D
  1. Html

  2. Java

  3. Binary

  4. Ascii


Correct Option: C
- Hide questions