3i Infotech Papers: Sample Questions 318 - 320 of 1245

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

Question number: 318

» Database » Oracle

MCQ▾

Question

What built-in subprogram is used to manipulate images in image items?

Choices

Choice (4) Response

a.

Zoom_image

b.

Zoom_in’

c.

Zoom_out

d.

Image_zoom

Answer

d.

Explanation

Image_zoom is built-in subprogram used to manipulate image in image items.

Question number: 319

» Database » MySQL

Essay Question▾

Describe in Detail

What is an attribute?

Explanation

  • It is the name of the column.

  • An attribute gives the characteristics of the entity.

  • For example, A customer of bank may be described by: name, address, customer ID number.

  • It is also called as data element, data field, a field, a data item, or an elementary item.

Types of attributes:

  • Single valued Attributes:

  • Multi valued Attributed:

  • Compound Attribute:

  • Simple Attribute:

  • Stored Attribute:

  • Derived Attribute.

Question number: 320

» Database » Oracle

MCQ▾

Question

Which is not part of the Data Definition Language?

Choices

Choice (4) Response

a.

ALTER SESSION

b.

ALTER

c.

CREATE

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

Define DDL statements.

Define DDL Statements.

Define DDL statements.

  • ALTER SESSION is not support of the Data Definition Language.

Data Definition Language

  • Used to alter/modify a database or table structure and schema.

  • These statements handle the design and storage of database objects.

DDL statement enable:

  • Create, alter and drop schema objects

  • Grant and revoke privileges.

  • Analyse information on a table, index, or cluster.

  • Establish auditing options

  • Add comments to the data dictionary

  • The current transaction must end before and after every DDL statement.

  • Many DDL statement cause recompile of schema objects.

Examples

  • CREATE: create a new table, database, schema

  • ALTER: alter existing table, column description

  • DROP: delete existing objects from database