3i Infotech Papers: Sample Questions 132 - 134 of 1245

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

Question number: 132

» Database » Oracle

MCQ▾

Question

Identify the RESTRICTED packaged procedure from the following

Choices

Choice (4) Response

a.

MESSAGE

b.

USER_EXIT

c.

EXIT_FORM

d.

BREAK

Answer

c.

Explanation

  • Restricted package procedure affects the basic functions of SQL * Forms.

  • That cannot used in all triggers except key triggers.

Below is the list of RESTRICTED packaged procedures:

  • Execute Query- Restricted

  • Message- Restricted

  • Post- Restricted

  • Exit_form-Restricted

  • Up-restricted

Question number: 133

» Database » MySQL

MCQ▾

Question

Which kind of COMMENT statements are placed within SQL statements?

Choices

Choice (4) Response

a.

ANSI SQL style statements (…)

b.

Asterisk (*) in column?

c.

C Style comments (/*……*/)

d.

All a. , b. and c. are correct

Answer

d.

Explanation

Below two syntaxes can create a comment within SQL statement in oracle- making it easier to maintain.

Syntax using – symbol

  • Syntax for creating a SQL comment in oracle using – symbol

    –comment goes here

  • A comment started with – symbol and ends with new line in SQL statement.

  • Includes a single line within SQL.

Syntax using /* and */ symbols

  • Syntax for creating a SQL comment using /* and */ symbols is:

    • /* comment */

  • A comment starts with /* symbol and ends with */.

  • This method can span several lines within our SQL.

Question number: 134

» Operating System » Unix

Essay Question▾

Describe in Detail

List the system calls used for process management.

Explanation

  • fork ()

    • Create a new process.

  • exec ()

    • Execute a new program in a process

  • wait ()

    • Wait until a created process completes its execution

  • exit ()

    • Exit from a process execution

  • getpid ()

    • Get a process identifier of the current process.

  • getppid ()

    • Get parent process identifier.

  • nice ()

    • Bias the existing priority of a process.

  • brk ()

    • Increase/decrease the data segment size of a process.