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

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

An Element can be

  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

When you check in the file into ClearCase

  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

Which type of view will be using MVFS

  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

What are the different types of Merges

  1. Trivial

  2. Non-Trivial

  3. Automatic

  4. All the above


Correct Option: D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Trivial - This option is incorrect because trivial merges refer to merges that do not involve any conflicts or complex changes. They are straightforward and do not require much effort.

Option B) Non-Trivial - This option is incorrect because non-trivial merges refer to merges that involve conflicts or complex changes. They require careful consideration and decision-making to resolve conflicts and ensure the changes are integrated correctly.

Option C) Automatic - This option is incorrect because automatic merges refer to merges that can be performed automatically by version control systems. They typically occur when the changes being merged do not conflict with each other.

Option D) All the above - This option is correct because it includes all the types of merges mentioned above. Trivial merges, non-trivial merges, and automatic merges are all different types of merges that can occur in version control systems.

Therefore, the correct answer is option D) All the above.

Following files cannot be merged

  1. Html

  2. Java

  3. Binary

  4. Ascii


Correct Option: C
- Hide questions