|
Click
here for important notes
|
More Resources by
Google: |
|
|
|
|
Case Study for
Hands-On Oracle Tools
The Case Study for “Hands-On
Oracle Tools”
consists of more than 40 basic questions that we believe you must know.
In this Case Study, we look at certain elementary questions, which will
test your basic fundamental understanding of the Oracle Developer Tools.
These questions and their answers in the “Hands-On Training” enhance
your skills in using Oracle Developer Tools.
Hands-On
01 (Schema Builder) - Manuscript
Q:
How can you create
a table using the "Schema Builder" tool?
Q:
How can you define a
column, attribute, and primary key using the "Schema Builder" tool?.
Q:
How can you define a
required field and unique key using the "Schema Builder" tool?.
Q:
How can you grant an object
privilege to the public using the "Schema Builder" tool?
Q:
How can you check what other
users can access using the "Schema Builder" tool?
Q:
How can you remove a table using
the "Schema Builder" tool?
Hands-On
02 (Query Builder)
- Manuscript
Q:
Create a query using the
"Query Builder" tool.
Q:
How can you join multiple tables using the "Query Builder" tool?
Q:
How can you establish table relationship between multiple tables using the
"Query Builder" tool?
Q:
Execute a query using the "Query Builder" tool.
Q:
Sort a query using the "Query Builder" tool.
Q:
How can you add a "WHERE" clause condition to a query using the
"Query Builder" tool?
Q:
List a query using the "Query Builder" tool.
Q:
Save a query using the "Query Builder" tool.
Hands-On
03 (Procedure Builder)
-
Manuscript
Q:
Write a stored procedure
to add a record into the department table using the "Procedure
Builder" tool.
Hands-On
04 (Form Builder)
- Manuscript
Q:
How can you create a "Datablock" for a form application using
the "Form Builder" tool?
Q:
How can you create a
"layout" for a form application using the "Form Builder"
tool?
Q:
How can you use a "Content canvas" for a form application using
the "Form Builder" tool?
Q:
Use the "Execute Query" option to query customer's information.
Q:
How can you navigate a table using the "Form Builder" tool?
Q:
What does the "NEXT RECORD" option do?
Q:
What does the "PREVIOUS RECORD" option do?
Q:
What does the "Enter Query" option do?
Q:
How can you manipulate table's reocd?
Q:
Insert, delete and update a record.
Q:
How can you save a transaction using the "Form Builder" tool?
Hands-On
05 (Report Builder)
- Manuscript
Q:
How can you use the "Report Wizard" tool in the "Report
Builder" tool?
Q:
How can you use the "Object
Navigator" window?
Q:
How can you write a report?
Q:
How can you save a report?
Q:
How can you use the "Data Model" tool?
Q:
What is the "Property Palette" sheet?
Q:
What is the "Query" box in the "Data Model" window?
Q:
What is the "Group" box in the "Data Model" window?
Q:
How can you change a report style?
Q:
Use a tabular style for a report.
Q:
How can you navigate through your report?
Q:
How can you change a format mask for an item in the "Report
Builder" tool?
Hands-On
06 (Graphics Builder)
- Manuscript
Q:
How can you create a chart using the "Graphics Builder" tool?
Q:
How can you run a query
against a chart?
Q:
How can you modify a query?
Q:
How can you save a query?
|