nvl(mgrno,0)

nvl(mgrno,'none')

nvl('mgrno',0)

nvl(mgrno,'0')

control files

password files

parameter files

redo logs

buffer cache

large pool

java pool

all the above

True

False

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

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

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

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

Source file

Directories

Binary files

All the above

It is a dynamic view.

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

None of the above.

All of the above.

Check-In

Check-Out

Deliver

Retrieve

A new version of the file will be added

The current version will be updated

The current version of the file will be deleted

None

By Merging

By Sub Branching

By Creating a view

None of the above

Makebranch

Mkbranch

Mhbr

None of the above

To enable parallel development

To Enable single user development

To Enable multi site development

None of the above

Versioned object basic

Very old basis

Versioned object base

None

Single Project

Multiple project

Multiple projects of same type

None of the above

Snapshot

Dynamic

Multi Dynamic

Recursive

Dynamic

Snapshot

Both a & b

None

Reserved

Un-reserved

Both a & b

None

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

It allows changes across multiple elements to be logically grouped together

It controls public/private work

All the above

Trivial

Non-Trivial

Automatic

All the above

Html

Java

Binary

Ascii