3i Infotech Papers: Sample Questions 351 - 353 of 1245

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question number: 351

» Database » Oracle

MCQ▾

Question

Which of the following packaged procedure is UNRESTRICTED?

Choices

Choice (4) Response

a.

USER_EXIT

b.

CALL_INPUT

c.

CLEAR_BLOCK

d.

EXECUTE_QUERY

Answer

a.

Explanation

Understanding of representation basis

Understanding of Representation Basis

Understanding of representation basis understricted and restricted sampling

  • Unrestricted package procedure does not interfere with the basic functions of SQL * Forms

  • It can be used in any triggers.

Below gives the list of restricted and unrestricted procedure

  • Call-unrestricted

  • User Exit- Unrestricted

  • Call_query- unrestricted

  • Break-unrestricted

  • Up-restricted

  • Execute Query- Restricted

  • Message- Restricted

  • Post- Restricted

  • Exit_form-Restricted

Question number: 352

» Database » MySQL

True-False▾

Question

Is the Following Statement True or False?

! =, < > , ^ = all denote the same operation.

Answer

TRUE

Explanation

Compound operator in sql

Compound Operator in Sql

Compound operator in sql

  • True

! = operator:

  • Check if the values of two operands are equal or not.

  • If values are not equal then condition becomes true.

(a! =b)

< > operator:

  • Check if the values of two operands are equal or not.

  • If values are not equal then condition becomes true.

(a < > b)

^= operator

  • In equality test

  • If values are not equal then condition becomes true.

(a^=b)

Question number: 353

» Basic CS » Operating System

Short Answer Question▾

Write in Short

Paging is a memory management function, while multiprogramming is a processor management function, are the two interdependent?

Explanation

  • Yes, paging and multiprogramming are independent.

  • Multiprogramming requires large memory for many processors, virtual memory and paging provide nearly infinite memory. Paging divides address space into smaller segments stored in secondary storage.

  • Moreover, main memory is limited and multiprogramming necessitates multiple working sets in the RAM. Intelligent memory management may thus improve performance.