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
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.