Online Oracle and SQL Exam Questions MCQ's Sample Paper For Exam
i.
What will be result of
these values?
Select ROUND (45.923, 2), ROUND (45.923, 0),
ROUND (45.923,-1), TRUNC (45.923,2), TRUNC (45.923, 0), TRUNC (45.923,-1) from
dual;
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.
Define the following with some examples
a) Multiple
column sub queries
b) Foreign
key and Unique Key Constraints
c) Creating,
using and Modifying Sequences.
d) Explicit
Cursors and its attributes.
e) Handling
Exceptions.
3.
Contrast the Following Terms with some examples:
i.
Character Functions: Number functions
ii.
Object privileges: System Privileges
iii.
Non Equi Joins: Outer Joins
iv.
Views: Synonyms.
v.
PL/SQL Record: PL/SQL Table.
4. Contrast
the Following Terms:
i.
LOV: Alerts
ii.
Object Libraries: Visual Attributes
iii.
Master Detail Forms:
Content and Stack Canvases
iv.
Object Navigator: Layout Editor
v.
Data Blocks: Control Blocks
5. Briefly
Explain Forms Level, block level and item level triggers how can you make
navigation structure and add functionality using built-ins? Provide some
examples.
6. With
Reference to your Oracle Project what type of queries you made up to facilitate
users. How can you integrate your System? What type of dynamic functionality
you add up with your system. Also explain the steps you followed to design user
friendly interface of your project.
0 comments:
Post a Comment