3i Infotech Placement: Sample Questions 365 - 368 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 365

Edit

Write in Short

Short Answer▾

When is a memory allocated to a class?

Explanation

Unsderstanding of Allocated to a Class
  • Memory is allocated when instance of a class is created.
  • A class is a template- allocated memory when object of that class is created.

Question 366

Question

MCQ▾

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

Choices

Choice (4)

a.

Zoom_image

b.

Image_zoom

c.

Zoom_out

d.

Zoom_in ′

Answer

b.

Explanation

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

Question 367

Edit

Describe in Detail

Essay▾

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 368

Question

MCQ▾

Which is not part of the Data Definition Language?

Choices

Choice (4)

a.

ALTER

b.

ALTER SESSION

c.

CREATE

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

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

Developed by: