Online Oracle Database short Question PL/SQL Query Multiple Choice Question for Exams
i.
Which cursor attribute
evaluates to TRUE if the most recent SQL statement affects one or more rows?
A). SQL%FOUND. B)
.SQL%ISOPEN. C).SQL%ROWCOUNT.
D). SQL%NOTFOUND. E) None of the above
ii.
Operators of the same
priority are evaluated from ……….. to ……………..
iii.
A …………. Is a
Character, .………or Number included in the Select List.
iv.
Eliminate Duplicate
rows by using the ……….. Keyword in the ……….. Clause.
v.
……………. Convert a value
from one datatype to another and …………….. operate on sets of rows to give one
result per group.
vi.
Which Wizard would you
use to define the layout attributes for a data block in Form Builder?
A). Chart Wizard B) .Layout Wizard C). Report Wizard
D). Project
Wizard E). Data Block
Wizard
vii.
You are creating the
Sales form that will have two data blocks joined by a master-detail
relationship. When will the Data Block
Wizard prompt you to specify the relationship between the two data blocks?
A). after both data blocks are
created B). When
the Layout Wizard is launched C). before
either data block is created D). When
the first data block is created E).
When the second data block is created
viii.
You need to change the
table name of the data source for the EMP data block of the EMPLOYEE form. Which data block property would you alter to
complete the task?
A). Database Item B). Query All Records C). Query Data Source Type D). Query Data Source Name E). Query Data
Source Columns
F). Query Data Source Arguments
ix.
You need to create a
stacked canvas over a content canvas for the EMPLOYEE form. Which component would you use?
A). Stylebar B). Layout Wizard C). Report Wizard
D). Layout Editor E). Object Navigator F). Data Block Wizard
x.
Which Form Builder
component would you use to add pages to a tab canvas?
A). Layout Wizard B). Data Block Editor C). Layout Editor D). Object Navigator E). Data Block
Wizard
2.
i.
How can you create and fetch data using Explicit
cursors. Define different cursor attributes with some suitable examples also
discuss cursor for loop.
ii.
What is the Difference between Pre-defined Exceptions
and User Defined Exceptions? How can you handle all these exceptions provide
some examples.?
3. Differentiate
the Following Terms with some examples:
i.
Character Functions;
Date functions
ii.
Object privileges;
System Privileges
iii.
Cartesian Product; Outer
Joins
iv.
Complex Views; Synonyms
v.
PL/SQL Record; PL/SQL
Table.
4. Differentiate
the Following Terms:
i.
Navigation Triggers; Interface
Event Triggers
ii.
Record Groups; Visual Attributes
iii.
Window Built-ins; Parameter
List Built-ins
iv.
Pre Triggers; On
Triggers
v.
Menus; Parameters
5.
Briefly Explain different types of Data block items.
What type of Triggers and Built-ins you can use to add validation and
navigation functionality with them. Also provide some examples to change different
properties of these item types programmatically.
6.
With Reference to your Oracle Project Explain different
modules of your system. How can you integrate your modules using Oracle Form
Developer? What type of user Roles and privileges you have created to maintain
the security of your system. Also explain the steps you followed to design user
friendly interface of your project.
0 comments:
Post a Comment