3i Infotech Placement: Sample Questions 422 - 424 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 422

Write in Short Short Answer▾

Is there any tag in html to upload and download files?

Edit

Explanation

Yes, < input type = “file” > is there tag in html to upload and download files.

Question 423

Describe in Detail Essay▾

What is page fault? it՚s types?

Edit

Explanation

Define Page Fault
  • Page fault handler is one of critical parts of code in the linux kernel.
  • It has major influence on memory subsystem՚s performance.
  • Each process is assigned to a memory chunk named as pages.
  • A process has a page table containing page table entries that point to the memory assigned to the process. They communicate to the CPU, the memory locations which valid for the process.
  • A page table that does not currently map to RAM, will result in page fault by CPU.

Two types of page fault:

Validity fault

  • Validity fault is the result of non setting of valid bits in main memory at the time of refererring a page.

Protection fault

  • Provides protection mechanism in response to access violation caused by running code.
Two Types of Page Fault

Question 424

Question MCQ▾

Is it possible to open a cursor which is in a Package in another procedure?

Choices

Choice (4)

a.

Yes

b.

No

c.

None of the above

d.

All of the above

Edit

Answer

a.

Explanation

Steps of Creating Cursors in Oracle
  • Yes, it is possible to open a cursor, which is in a Package in another procedure. Cursor:
  • Declared in a package specification- is global and can be accessed by other procedures or procedures in a package.
  • Declared in a procedure- is local to the procedure that cannot be accessed by other procedures.
  • Is declared in the declaration part.
  • Declaration section cannot assign the value to variable.