Database-MySQL [3i Infotech Placement]: Sample Questions 94 - 95 of 162

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

Question 94



PL/SQL supports datatype.


Choice (4)


Scalar datatype


Composite datatype


Both a. and b. are correct


None of the above




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 95


Describe in Detail


What is Authorization and Integrity manager?


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

Developed by: