Control Center

SQL Assist

Configuration Assistant

Command Line Processor

Primary key

Unique key

Foreign key

Composite key

INT

CHAR

XML

DOUBLE

BLOB

CLOB

DBCLOB

GRAPHIC

Uncommitted Read

Cursor Stability

Read Stability

Repeatable Read

Enterprise reverse planning

Enterprise revenue Planning

Effective resource planning

Enterprise resource planning

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

True

False

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

The two statements produce identical results.

The second statement returns a syntax error

There is no need to specify DESC because the results are sorted in descending order by default

The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;