3i Infotech Placement: Sample Questions 107 - 109 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 107

Question

MCQ▾

What is a DATABLOCK

Choices

Choice (4)

a.

Set of Segments

b.

Set of Extents

c.

Smallest Database storage unit

d.

Question does not provide sufficient data or is vague

Answer

c.

Explanation

Oracle Data Block and Operating System Block
  • A smallest database storage unit.
  • The small unit of I/O by a database.
  • A specific number of bytes of physical database space on disk.
  • Oracle requests data in multiples of Oracle data blocks, not operating system blocks.
  • A multiple the os block size.
  • Oracle data blocks are the smallest units of storage that Oracle can use or allocate.

Question 108

Edit

Write in Short

Short Answer▾

How to run SQL script from a Unix Shell?

Explanation

Run SQL script file

  1. Open a command prompt window.
  2. In the Command Prompt window, type: sqlcmd -S myServer⧵instanceName -i C: ⧵myScript. sql
  3. Press ENTER.

Question 109

Edit

Write in Short

Short Answer▾

Predict the output or error (s) for the following:

  1. main ()
  2. {
  3.     chara[4] =“HELL” ;
  4.     printf ( “%s” ,a);
  5. }

Explanation

HELL % @! ~@! @? ? ? @ ~ ~!

  • In this program
Table Showing the Program
char a [4] = “HELL” ;
  • The character array has the memory just enough to hold the string “HELL” and doesn՚t have enough space to store the terminating null character.
printf ( “% s” , a) ;
  • Printf prints the HELL correctly and continues to print garbage values till it accidentally comes across a NULL character.

Developed by: