Answers to Chapter 12

Reviewing It

1: What is Portal v3.0?
A1: It is Web-based Web-page development software from Oracle Corp
2: What are key differences between Portal v3.0 and its predecessor WebDB?
A2: WebDB had its own listener and was basically independent of the Web server where Portal v3.0 is integrated with Oracle9iAS
3: What is a portlet?
A3: A small application, Web URL, and so on, that can be included in a Portal page.

Checking It

1: What URL starts the Portal environment:

  1. http://<host-name>/portal30

  2. http://10.4.50.100/pls/portal30

  3. http://<host-name>/portal30/portal30

  4. All of the above

A1: b
2: Portal is only a Web-development tool.

True/False

A2: False, it monitors and administrates the database as well
3: Portal can build which of these:

  1. Form

  2. Report

  3. XML

  4. Menu

  5. List of Values

  6. All of the above

A3: False
4: On the base tabular form, there are four buttons by default.

True/False

A4: False, three buttons.

Applying It

Independent Exercise 1:

  • Build a simple Portal Application Form based on the EMP table.

  • Query KING.

  • Query all those making more than $2,000.

Independent Exercise 2:

  • Build a Portal Application Report based on

    SELECT DNAME, SUM(SAL)

    FROM DEPT, EMP

    WHERE DEPT.DEPTNO = EMP.DEPTNO

Independent Exercise 3:

  • Build a portal page with three columns.

  • Populate these columns with various portlets.

  • Run this newly created page.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset