Database-Oracle [3i Infotech Placement]: Sample Questions 121 - 122 of 132

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

Question 121

Oracle

Question

MCQ▾

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

Choices

Choice (4)

a.

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

b.

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

c.

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

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

Difference between a LIST BOX and COMBO BOX
LIST BOXCOMBO BOX
Selects multiple itemsCan select only one item
Displays a list of item to userDisplays a drop-down list of items.
Cannot add information at run timeAdd information at run time
Check-box used within list boxCannot use checkbox with in combo box

Question 122

Oracle

Question

MCQ▾

SYSTEM TABLESPACE can be made off-line

Choices

Choice (4)

a.

No

b.

Yes

c.

All of the above

d.

None of the above

Answer

a.

Explanation

Define Two Table Space, System Tablespace and User Tablespace
  • System tablespace is the memory allocated by oracle for creation of object, view, and indexes:
  • A logical group of data files in a database.
  • A database typically contains at least one tablespace, and usually two or more.
  • Within the database, the tablespace is similar to a folder on the hard drive of a computer.
  • Oracle automatically creates a tablespace called SYSTEM containing general information about the structure and contents of the database.
  • Made up of one or more database data files.
  • Total amount of storage space available in a tablespace is the sum of the physical disk size of all the data file associated with that tablespace.
  • The data files are created automatically when the tablespace is defined.
  • Ex. The first tablespace created are- SYSTEM and SYSAUX.
  • It can be created, deleted, and merged with the folders on the hard drive of a computer.

Developed by: