3i Infotech Placement: Sample Questions 1031 - 1033 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 1031

Question

MCQ▾
  1. Declare
  2. @fvarfloat :=null;
  3. svarnumber:=5
  4. begin
  5. goto ≪fproc
  6. if@fvarisnullbegin
  7. fproc
  8. svar:=svar+5&
  9. endif.
  10. End.

What will be the value of svar after the execution?

Choices

Choice (4)

a.

Error

b.

10

c.

5

d.

Question does not provide sufficient data or is vague

Answer

c.

Explanation

Program execution would lead to an end if without and if.

Question 1032

Edit

Describe in Detail

Essay▾

Which is the subset of SQL commands used to manipulate Oracle Database structure, including table?

Explanation

Understanding of SQL Command
  • Data definition language is used to manipulate the data structures.
  • Used to create, modify and destroy databases and objects like table and views.
  • Integrity constrains are defined on tables when the table is created.
  • Provide commands for creating and deleting indexes.
  • Data manipulation language can change existing data in the table- Insert, Update and Delete and Merge.
  • CREATE command is used for the table and column definition along with name of each column and the associated data type.

Question 1033

Question

MCQ▾

If two groups are not linked in the data model editor, what is the hierarchy between them?

Choices

Choice (4)

a.

There is no hierarchy between unlinked groups

b.

The group that is to the right ranks higher than the group that is to the left

c.

The group that is above or leftmost ranks higher than the group that is to right or below it

d.

Question does not provide sufficient data or is vague

Answer

c.

Explanation

The group that is above or leftmost ranks higher than the group that is to right or below it.

Developed by: