3i Infotech Papers: Sample Questions 324 - 326 of 1245

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

Question number: 324

» Database » MySQL

Essay Question▾

Describe in Detail

What are the privileges that can be granted on a table by a user to others?

Explanation

  • User requires ADMIN privilege to grant privileges to others. For example:

    • Delete:

      • Delete rows from tables within the schema.

    • Insert:

      • Insert rows of data into tables within the schema.

  • References:

    • Set up references to primary keys within the schema.

  • Select:

    • To select rows from tables within the schema.

  • Trigger:

    • To create triggers on tables within the schema.

  • Update:

    • Update rows in tables within the shaman.

  • Execute:

    • Execute functions or stored procedure within the shaman.

Question number: 325

» Database » Oracle

MCQ▾

Question

Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger?

Choices

Choice (4) Response

a.

No

b.

Yes

c.

All of the above

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

  • No, we cannot use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger.

  • Restricted package procedure affect the basic functions of SQL * From.

  • It cannot be use in any triggers except key trigger.

    Bellow the list of restricted packaged procedure:

    • Up

    • Execute Query

    • Message

    • Exit_form

    • Post

Question number: 326

» Basic CS » Data Structures

Essay Question▾

Describe in Detail

In the given binary tree, using array we can store the node 4 at which location?

Explanation

Image shows the binary tree

Image Shows the Binary Tree

Image shows the binary tree

  • At location 6: 1 2 3 – 4 – 5

  • This is how array stores the tree: Root LC1 RC1 LC2 RC2 LC3 RC3 LC4 RC4, where LCn means Left Child of node n and RCn means Right Child of node n