Database [3i Infotech Placement]: Sample Questions 179 - 180 of 294

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

Question 179

Question MCQ▾

PL/SQL supports datatype.

Choices

Choice (4)

a.

Scalar datatype

b.

Composite datatype

c.

Both a. and b. are correct

d.

None of the above

Edit

Answer

c.

Explanation

PL/SQL Datatypes in Image

Data Types

  • Scalar type
    • Has no internal components.
    • Reference single value
  • Composite type
    • Has internal components it can be manipulated individually.
    • Use PL/SQL records when we want to store value of different data types.
    • Use when we want to store value of the same data type.
  • Reference type
    • Holds values, called pointers and that designate other program item.
  • LOB type
    • Hold value, called lob locators, that specify the location of large object that store out-of-line.
Image Show the Data Types

Predefine Data Types and Sub Data Types

Table of the Data Types and Sub Data Types
CategoryData Description
NumericCan perform arithmetic operation
characterAlphanumeric value respects single character or string
BOOLEANLogical value- can perform logical operations.
DatetimeDates and times.
IntervalTime intervals.

Question 180

Describe in Detail Essay▾

What is Authorization and Integrity manager?

Edit

Explanation

Define Authorization and Integrity Manager

Authorization Manager

  • Provides flexible framework for integrating role-based access control into applications.
  • Enables administrators who use those applications to provide access through assigned user roles that relate to job functions.

Integrity Manager

  • Ensure accuracy and consistency of data in a relational database.
  • Data integrity is handled in a relational database through the concept of referential integrity.
  • Many types of integrity constraints play a role in referential integrity