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 |
Answer
c.Explanation
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.
Predefine Data Types and Sub Data Types
Category | Data Description |
Numeric | Can perform arithmetic operation |
character | Alphanumeric value respects single character or string |
BOOLEAN | Logical value- can perform logical operations. |
Datetime | Dates and times. |
Interval | Time intervals. |
Question 180
Explanation
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