iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

IMPORTANT-READ CAREFULLY  

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)  

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)  

Q:   Write a stored procedure to add a record into the department table using the "Procedure Builder" tool.

 

 

Hands-On 04 (Form Builder)  

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)  

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)  

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?

 
 

Google
 
Web web site