3i Infotech Papers: Sample Questions 745 - 748 of 1245

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

Question number: 745

» Database » MySQL

Short Answer Question▾

Write in Short

What is a VIEW? How to get script for a view?

Explanation

VIEW: View is a logical partition of one or more table in horizontally (by putting condition) or vertically (by including selected columns).

  • View can be used to update table, provides security mechanism.

  • View definition (query) stored as plan text or Encrypted text

  • We can see view definition by using following stored procedure exec sp_helptext viewname

Question number: 746

» Languages » C & C Plus Plus

Short Answer Question▾

Write in Short

Is the following statement a declaration/definition. Find what does it mean?

int (* x) [10];

Explanation

  • Here x is a pointer to array of (size 10) integers.

  • Apply clock-wise rule to find the meaning of this definition.

Question number: 747

» Database » MySQL

Short Answer Question▾

Write in Short

What is DML Compiler?

Explanation

Define DML compiler

Define DML Compiler

Define DML compiler

DML Compiler:

  • Translates DML statements in a query language within low level instructions understandable through the query evaluation engine.

  • Attempts to transforms users request within an equivalent and well-organized from for executing the query understandable through Data Manager, Interprets DDL statements and records them within a set of tables containing Meta data in a form that can be used through other elements of a DBMS.

Question number: 748

» Database » Oracle

MCQ▾

Question

What is the difference between a LIST BOX and COMBO BOX?

Choices

Choice (4) Response

a.

A list box is a data entry area while a combo box can be used only for control purposes

b.

In the list box, the user is restricted to selecting a value from a list but in a combo box the user can type in a value which is not in the list

c.

In a combo box, the user is restricted to selecting a value from a list but in a list box the user can type in a value which is not in the list

d.

All of the above

Answer

b.

Explanation

Difference between a LIST BOX and COMBO BOX

Difference between a LIST BOX and COMBO BOX

LIST BOX

COMBO BOX

Selects multiple items

Can select only one item

Displays a list of item to user

Displays a drop-down list of items.

Cannot add information at run time

Add information at run time

Check-box used within list box

Cannot use checkbox with in combo box