Tag: databases

True

False

List of Values with validation.

Storing varchar Data.

Storing number Data.

List of Value.

Explicity fired.

Not taking space in database.

Only DML triggers are there.

Trigger timing is mandatory.

To insert in a view.

To insert in a view which is created with more than one table.

To insert into read only view.

None.

IN,OUT

OUT,OUT

IN ,IN

OUT,IN

Descriptive Flow Field.

Descriptive Flex Field.

Descriptive Flow File.

Descriptive Flex File.

Form->Function->User->Menu->Responsibility

Form->Menu->Function->Responsibility->User

Form->Function->Menu->Responsibilty->User

Form->Function->User->Menu->Responsibilty

It is a KeyFlex field used to store different segment values.

It will store attribute values that will be used to track future requirements.

knowledge Flex Field

It is containing of one segment

A role can be given to a maximum of 1000 users

A user can have access to a maximum of 10 roles

A role can have a maximum of 100 privileges contained in it.

Privileges are given to a role by using the CREATE ROLE statement

A role is a named group of related privileges that can be granted to the user

A user can have access to several roles, and several users can be assigned the same role

The underlying tables must have data

You need SELECT privileges on the view

The underlying tables must be in the same schema

You need SELECT privileges only on the underlying tables