3i Infotech Papers: Sample Questions 792 - 794 of 1245

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

Question number: 792

» Languages » C & C Plus Plus

Short Answer Question▾

Write in Short

What is a modifier?

Explanation

  • A modifier, also called a modifying function is a member function that changes the value of at least one data member.

  • In other words, an operation that modifiers the state of an object.

  • Modifiers are also known as ‘mutators’.

Question number: 793

» Database » MySQL

Essay Question▾

Describe in Detail

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

Explanation

Define GRANT statement.

Define GRANT Statement.

Define GRANT statement.

  • WITH GRANT option allows the privilege receiver to in future grant the privileges to any other user.

  • It can be used in SQL GRANT command to SQL SQLECT, UPDATE, INSERT, DELETE and other privileges on tables or views.

  • The keyword PUBLIC allows granting SQL privileges to all local user.

Question number: 794

» Database » Oracle

MCQ▾

Question

EXP command is used

Choices

Choice (4) Response

a.

To create Rollback segments

b.

To import data from the exported dump file

c.

To take Backup of the Oracle Database

d.

Question does not provide sufficient data or is vague

Answer

c.

Explanation

  • EXP command takes Backup of the Oracle Database.

  • Expert utility to write data from an oracle database into an operating system file in binary format.

  • Provides simple mechanism to transfer data between oracle databases.

  • Extracts objects, followed by their related objects.

  • Backup stored outside the database.

  • An Export file is an Oracle binary-format dump file typically located on disk or tape.

  • Dump files can only be read by oracle import utility.

EXP includes below options:

  • Export full database

  • Export one or more user

  • Export one or more table

  • Export all object in tablespace

  • Logging the export messages

  • Controlling output dump filename

  • Export only selected rows from a table.

  • Controlling constraints, grants, triggers and indexes.