Database-Oracle [3i Infotech Placement]: Sample Questions 89 - 90 of 132

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

Question 89

Oracle

Question

MCQ▾

What are the SQL clauses supported in the link property sheet?

Choices

Choice (4)

a.

WHERE & START WITH

b.

START WITH & HAVING

c.

WHERE, START WITH & HAVING

d.

WHERE & HAVING

Answer

c.

Explanation

  • WHERE, START WITH & HAVING are the SQL clauses supported in the link property sheet.

WHERE Cause

  • Used to filter the result from a SELECT, INSERT, UPDATE, or DELETE statement.

    Syntax

    WHERE conditions;

START with Cause

  • Appears in hierarchical SQL queries and queries data with master details relationships.
  • Marks node starting node or level of the tree structured data.
  • Scalar value can be assigned the root of the query.

Syntax

SELECT [COLUMNS]

FROM TABLE_NAME

START WITH [COLUMN] = [ROOT NODE VALUE]

CONNECT BY [CONDITION]

HAVING Clause

  • Restricts the results of a GROUP BY in a selectExpression.
  • Applied to the entire result as a single group.

Syntax

HAVING searchCondition

Question 90

Oracle

Question

MCQ▾

Can we create an LOV without an RECORD GROUP?

Choices

Choice (4)

a.

No

b.

Yes

c.

All of the above

d.

None of the above

Answer

a.

Explanation

Understanding of Record Group and LOV
  • No, we cannot create an LOV without an RECORD GROUP.
  • LOV populates a text item based on a selection from the list.
  • The user can search a LOV for string within the values.
  • A record group is a query, displaying database into the LOV.
  • LOV gets data from record groups which may be populated using SQL queries or by entering a static LOV
  • SQL behind an existing LOV on a form modified using personalization.
  • New record group is created or we attach new created record group to the existing LOV.

Developed by: