Hello friends if you are looking for OC PLSQL SE AD MCQ | OC PLSQL SE AD Multiple choice questions | OC PLSQL SE AD Objective type questions | OC PLSQL SE AD Question answers dumps | OC PLSQL SE AD Accenture dumps
Please use ‘FIND IN PAGE OPTION’ in google chrome to find any questions
1.
In oracle reports, which of the following components of data model is used to determine
the hierarchy of data appearing in the report.
Ans: Data columns
2.
Choose YES or NO
Can we add a computed column in the report after the report is created? Ans:
YES
3.
Which of the following is not a report module component.
Ans: Templets.
4.
In oracle Reports which of the following acts as placeholders for column values? Ans: Fields
5.
In oracle reports, which of the following surround the layout object which enable control of
multiple object simultaneously?
Ans: Frames
6.
In oracle reports which of the following procedure is used to specify the fill pattern of an
object?
Ans: SRW.SET_FILL_PATTERN.
7.
Which of following processes the client request, including user authentication, scheduling,
caching and report distribution.
Ans: Reports server
8.On which hardware the oracle Autonomous database is built?
Ans: oracle Exadata Database machine
9.
In which of the following type of database expected response time of and data intensive
operation will be in second.
Ans: OLTP
10. Which migrating to OADB, Nang realised that there is no need for any installation as
OADB comes pre installed on the EXADATA?
Ans: TRUE
11. Which of following can be consider as best fit scenario were OLTP systems can be consider?
Ans: ALL (online banking, online air ticket booking, online train booking)
12. The services offering from oracle Autonomous database, ATP and ADB make use of the
same OCI setup in the back end?
Ans: TRUE
13. In which of the following data warehouse type loading data to target is done before
transformation?
Ans: ETL
14. Which of the following is considered as one of the characteristics of data warehouse? Ans:
ALL (Subject oriented, time variant integrated)
15. Which of the following is used as a repository for creating various reports and analytical
solutions?
Ans: Data warehouse
16. Which of the following can be created from data model view of a oracle report? Ans: ALL
(summery clm, data link, formula clm)
17. While creating computed columns in oracle reports which property is the property
inspector needs to be consider to choose a column?
Ans: Source
18. Which one of these is not a standard reports builder report type?
Ans: Tabbed Report
19. Which of the following component of oracle 10g reports is used to deploy and manage all
applications that are developed using oracle 10g developer suite?
Ans: Oracle 10g application server
20. Which of the following component of oracle reports is treated as web server incorporating
and open SSL module to provide support for secure socket layers SSL and HTTP secure
socket layers HTTPs ?
Ans: Oracle HTTP server
21. Which of the following is not an object paper layout?
Ans: Repeating value
22. In Oracle reports which of the following component of data model is used to hold the data
value of a report?
Ans:
23. Which of the following is considered as an advantage of data warehouse? Ans: ALL
24. In Oracle reports, a data module can be shared be both paper and web layout? Ans: TRUE
25. In Oracle reports, Which of the following consists of text and graphics that appear in a
report each time it is run?
Ans: Repeating frames.
26. In oracle reports which of the following is a user defined column that gets data from PL/SQL
functions or expression?
Ans: Formula column.
27. In oracle reports which one of these is a valid reports builder file format? Ans: .RDF
28. Clarke assumes that based on the nature of work he is doing in the oracle autonomous
database OCI will automatically configure the database to ether autonomous data
warehouse ADW or autonomous transaction processing .
Ans: TRUE
29. Nang's company is working on oracle database for past 7 years with their own premise
license. They have decided to migrate to cloud services and use OADB. What type of
license options will oracle provide to Nang's company?
Ans: Here customer can apply there existing
30. Which of the following operations are generally performed on OLAP systems? Ans: ALL
31. Which of the following trigger type would be a best fit for validating the user input in
oracle reports?
Ans: Validation trigger
33. Below are the option which defined the three design principal autonomous database
1. Self recurring
2. Self driving
3. Self reparing
4. Self securing
Which three are correct option
Ans: 2,3 and 4
34. Which of the following is one of the type of oracle report editors view.
Ans: ALL (Web source, paper design and paper layout )
35. Which of the following is true about format triggers in oracle reports. Ans: A format
trigger ------ pl/sql-------(2 line ans)
36. Which of following option is invalid to Preview a reports in report builder? Ans:
37. While creating computed columns in oracle reports which property is the property
inspector needs to be consider to choose a aggregate function?
Ans: Source
38. Which of the following built-in is used to call a oracle report from the oracle form? Ans:
Web.Show_Document()
39. Which of the following is the return type of format triggers in oracle report?
Ans: Boolean
40. In oracle reports formula column names are prefixed by default which one of the
following?
Ans: CF_
41. Which of the following is a hierarchical browsing and editing interface that enables user
to locate and manipulate application objects quickly and easily?
Ans: Object navigatior
42. In oracle reports which of the following is not a data module component.
Ans: B___plate
43. Which of the following reports style is a valid option that can be considered with ______
Report using oracle reports builders Ans:
44. Which of the following is not oracle report builder component?
Ans: Property pallet
45. In oracle reports Which of the following is act as placeholder for column values?
Ans: Fields
46. In oracle reports Which of the following will allow programmer to create a routines like
procedures, functions and package.
Ans: Program units
47. Which of the following type of database is used to perform analysis on multidimensional data from various sources?
Ans: OLAP
48. Which of the following component to process custom (JSP) report tags and delivery
information between HTTP sever and report server.
Ans: report server and JSP
49. Which one these is a component of report builder?
Ans: ALL
50. In oracle reports Which of the following is not a valid data source type?
Ans: HTML query
51. In oracle reports module all objects have certain properties which of the following is
the place where we can view and edit the properties?
Ans: Property inspector.
1]In Oracle Report, which of the following surrounded the layout objects which
enable control of multiple objects simultaneously?
ANS: Frames
2]In Oracle Reports, which of the following procedure is used to specify the fill
pattern of an object?
ANS: SRW.SET_FILL_PATTERN
3]Which of the following processes the client requests, including user
authentication, scheduling caching and report distribution?
ANS: Reports Server
4]Which one of these is not a standard Reports Builder report type?
ANS: Break Report
5]On which hardware the Oracle Autonomous Database is built?
ANS: Oracle Exadata
6]In Oracle Reports,which of the following component of Data Model is used to
create computed columns?
ANS: Formula Clumns
7]Which of the following is one of the type of Oracle Report editor’s view?
ANS: Web Source
Paper Design View
Paper Layout View
(ALL)
8]In Oracle Reports,a Data Model can be shared by both paper and Web
Layout?
ANS: True
9]Which of the following is true about Format Triggers in Oracle Reports?
ANS: A Format Trigger is a c….. PLSQL.
10]Nang’s company is working on Oracle Database for Past 7years with their
own premise license.They have decided to migrate to cloud services and use
OADB.What type of license options will oracle provide to Nang’s company?
ANS:
11] State True or False.
While migrating to OADB, Nang realized that there is no need for any
installation as OADB comes pre installed on the EXADATA.
ANS:
12] In which of the following type of database, expected response time of an
data intensive operation will be in seconds?
ANS: OLTP
13]State True or False.
The services offering from Oracle Autonomous Database, ATP and ADB
make use of the same OCI setup in the back end.
ANS:
14]Which of the following can be considered as a best fit scenario where OLTP
systems can be considered?
ANS: Online Banking
Online Air Ticket Booking
Online Train Booking
(All)
15]In which of the following data warehouse type,loading data to target is done
before transformation?
ANS: ELT
16]Which of the following is considered as one of the characteristics of Data
Warehouse?
ANS: Subject Oriented
Time Variant
Integrated
(All)
17] Which of the following option is invalid to preview a report in reports
button?
ANS: Run Print Preview
18]Which of the following is used as a repository for creating various reports
and analytical solutions?
ANS: Data Warehouse
19]Which of the following option is invalid to preview a report in reports
button?
ANS: Run Print Preview
20]While creating computed columns in Oracle Reports,which property in the
property inspector needs to be considered to choose a Aggregate Function?
ANS: Function
21Which of the following can be created from Data Model view of a Oracle
Report?
ANS: Summary Column
Formula Column
Data Links
(ALL)
22]Which of the following component of Oracle 10g reports is used to deploy
and managed at applications that are developed using Oracle 10g Developer
Suite?
ANS: Oracle 10g Application Server.
23]Which of the following is not a component of report?
Ans: Frame
Repeating Frame
Field
Repeating Value
24]Which of the following component of Oracle Report is treated as Web
Server incorporating an OpenSSL module to provide support for Secure Socket
Layers(SSL) and HTTP Secure Socket Layer(HTTPs)?
ANS: Oracle HTTP Server
25]While creating computed columns in Oracle Reports, which property in the
property inspector needs to be considered to choose a column?
ANS: Source
26]Which of the following is considered as an advantage of data warehouse?
ANS:
27]Which of the following is not an object of paper layout?
ANS:
28]Choose Yes/No.
Can we add a computed coloumn in the report after the report is created?
ANS: Yes.
29]In Oracle Reports,Which of the following consists of text and graphics that
Appear in a report each time it is run?
ANS: BoilerPlate
30]In Oracle reports, which of the following is a user defined column that gets
data from PL/SQL function or expression?
ANS: Formula Column
31] Which of the following is not a report module component?
ANS: Templates
32]In Oracle Reports,which one of these is a valid report builder file format?
ANS: .rdf
33]State: True or False.
Clarke assume’s that based on the nature of work he is doing in the Oracle
Autonomous Database,the OCI will automatically configure the database to
either Autonomous Data Warehouse(ADW) or Autonomous Transaction
Processing(ATP).
ANS: True
False
34]Which of the following operations are generally performed on OLAP
systems?
ANS: Roll-up
Drill-Down
Dice
(ALL)
35]Which of the following trigger type would be best fit for validating the user
input in oracle reports?
ANS: Validation Trigger
36]Nang’s company is working on oracle database for past 7 years.Their onpremise database had migrated to cloud services and use OADB.Should they
move all the frontend application to the cloud as well?
ANS: Yes
No
37]Below are the options which define the three Design Principles of
Autonomous Database.
1.Self Recurring 2. Self Driving
3.Self Reparing 4. Self Securing
Which three are correct options
ANS: 2,3,4.
38]Which of the following bulletin is used to call a oracle report from the oracle
form?
ANS: Web.Show_Document()
39]Which of the following is the return type of format triggers in oracle report?
ANS: Boolean
40]In Oracle Reports, formula column names are prefixed by default with one
of the following?
ANS: CF_
41]In Oracle Reports,which of the following surround the layout objects which
enable control of multiple objects simultaneously?
ANS: Frames
42]Which of the following is a hierarchical browsing and eating interface that
enables user to locate and manipulate application objects quickly and easily?
ANS: Object Navigator.
43]Which of the following can be created from data model view of oracle
report?
ANS: Queries, Groups, Formula Columns, Summary Columns,
Placeholder Columns, System and User Parameters, and Data Links.
44]In Oracle Reports,which of the following is not a Data Model component?
ANS: BoilerPlate
45]Which of the following report style is a valid option that can be considered
while creating a report using oracle reports builder?
ANS:
46]Which of the following is not a Oracle Reports builder component?
ANS: Property pallette
47]In Oracle Reports, which of the following acts as placeholder for column
values?
ANS: Fields
48]In Oracle Reports, which of the following will allow programmer to create
routines like procedure, functions and packages?
ANS: Program Units
49]Which of the following type of database is used to perform analysis on
multi-dimensional data from various sources?
ANS: OLAP
50]Which of the following component process custom(JSP) report tags and
deliver information between HTTP server and report server?
ANS: Reports Servlet and JSP.
51]Which one of these is a component of Reports Builder?
ANS: Report Editor
Program Units
Templates
(ALL)
52]In Oracle Reports, which of the following is not a valid data source type?
ANS: HTML Query
53]In Oracle Reports module, all objects have certain properties. Which of the
following is the place where we can view and edit the properties?
ANS: Property Inspector
54]Which of the following is not a Report Module component?
ANS: Templates
55]Which component of reports services 10g is responsible for below actions?
1.Fetches data from the data source
2.Formats the report
3.Sends output to cache.
ANS: Reports Engine
56]which of the following triggers are available in Oracle Reports?Choose most
appropriate option. Choose most appropriate option.
ANS: Before Parameter Form
After Parameter Form
Before Report
(All of the above)
57]Which triggers are used dynamically to change the formatting attributes like
font and font style of any object on the report? Choose the most appropriate
option.
ANS: Format Triggers
58]Identify the report trigger that will fire first. Choose most appropriate option.
ANS: Before Parameter Form Trigger
59]Identify the report trigger that will be fired last.Choose most appropriate
option.
ANS: After Report Trigger
60]Which one of these are not components of Reports Builder?
Choose most appropriate option.
ANS: Object Navigator, Data Model, Layout Editor, Report Editor,
Property Inspector, Program Units, PL/SQL Editor, Templates, PL/SQL
Libraries.
61]Which of the following option in a Report Module can be used to view the
HTML content of a report?
ANS: Web Source
62]Reports Architecture includes
ANS: 1]Oracle 10g Products
2]Oracle Report Services
3]Reports Services Architecture
63]Oracle 10g Products consists
ANS: 1]Oracle 10g Database
2]Oracle 10g Application Server (Oracle10g AS)
3]Oracle 10g Developer Suite(Oracle 10g DS)
64]Oracle 10g Database
ANS: 1]This manages all information and creates integrity constraints.
2]These constraints can be automatically reused by Oracle 10g
Developer Suite tools.
3]This reduces the amount of manual coding.
65]Oracle 10g Application Server (Oracle 10g AS)
ANS: 1] This is used to deploy and manage all applications that are
developed using Oracle 10g Developer Suite.
2]It contains Oracle 10g Forms Services that is used to deploy form
applications.
66]Oracle 10g Developer Suite (Oracle 10g DS)
ANS: 1] This uses the features of Oracle 10g Database and Application
Server to quickly build scalable, secure, and reliable e-business
applications.
2]The Suite provides complete and highly productive development
environment for building applications.
3]The Suite includes Oracle 10g Forms Developer that is used to
build Forms applications and Oracle 10g Reports Developer that is
used to create customized reports.
67]Oracle Report Services
ANS: 1] It is a component of Oracle 10g Application Server.
2]This component is used to deploy Oracle Reports Developer
applications on the internet.
68]Report Services Architecture
ANS: The Report Services Architecture consists of five major components.
1]Oracle 10g as HTTP Server: i]This is the Web Server
incorporating an OpenSSL module to provide support for Secure
Socket Layers (SSL) and HTTP Secure Sockets Layers (HTTPS).
ii]It also provides a servlet engine to support the running of Java
Servlet applications.
2]Reports Servlet and JSP: These components process custom (JSP)
report tags and deliver information between HTTP server and
Report server.
3]Reports Server: It processes client requests, including user
authentication, scheduling, caching, and report distribution.
4]Reports Engine: The Reports Engine fetches data from the data
source, formats the report, sends output to cache, and notifies the
Reports Server that the job is ready.
5]Reports Cache: The Reports cache stores the completed jobs.
69] Benefits of Oracle 10g Developer Suite
ANS: 1] Oracle 10g Developer Suite is optimized for the Oracle 10g
Database and Oracle 10g Application Server.
2]It provides flexible and scalable solutions for Data Warehousing
and Business Intelligence.
3]It provides a standard Java and XML Integrated Development
Environment (IDE) and supports the full application development
lifecycle.
4]It combines the power of Oracle Application Development tools
and Oracle Business Intelligence tools.
70]Oracle Reports Developer
ANS: 1] Oracle 10g Reports Developer is an enterprise reporting tool. This
enables businesses to give immediate access to information to all levels
within and outside of the organization in a scalable and secure
environment.
2]Oracle Reports Builder is one of the components of Oracle 10g
Reports Developer.
3]Oracle 10g Reports Developer is the solution for Web and paper
publishing that enables you to publish any data in any format (PDF,
HTML, printed, XML) to any destination (Web, Portal, e-mail, file)
in an efficient manner.
4]Oracle9i Reports Developer delivers high quality information to
users with only an Internet browser in open Internet document
standards.
5]The goal of Oracle9i Reports Developer is to be the universal
publishing solution of choice for any publishing need within an
organization.
71]Components of Oracle Report Builder
ANS: i]Reports Builder interface enables you to create several different types of
modules.
ii]It provides a Report Editor in which the structure and objects can be viewed
in the Report Module.
1)You can overload subprograms if their formal parameters differ only in numeric data type.PL/SQL looks for matc
hing numeric parameters in which order?
A) 1.PLS_INTEGER 2.NUMBER 3.BINARY_FLOAT 4.BINARY_4.DOUBLE
B) 1.BINARY_DOUBLE 2.BINARY_FLOAT 3.PLS_INTEGER 4.NUMBER
C) 1.NUMBER 2.PLS_INTEGER 3.BINARY_FLOAT 4.BINARY_DOUBLE
D) THere is no such ordernin which it looks
ANS-A
2)PL?SQL Exception message consists of which of the following parts?A. Type of Exception B.Error Code C.Error
Message
A)Only A
B)Only B
C)Only A and C
D)A,B and C
ANS-D
3)How many IN arguments procedure DBMS_LOCK.SLEEP has?
A)0
B)1
C)2
D)It can have any number of arguments
ANS-B
4)What will be the output of the following code snippet?
DECLARE
Time TIMESTAMP(3);
BEGIN
Time:='15-SEP-2013 07:48:53.275';
DBMS_OUTPUT.PUT_LINE(TO_CHAR(Time));
End;
A)15-SEP-13 07.48.53.275 AM
B)15-SEP-2013 07.48.53.275 AM
C)15-SEP-.
13 07.48.53.275
D)15-SEP-13 07.48.53.275 PM
ANS-A
5)Which of the following is considered as the best practice whiledesigning trigger?
a)Use triggers to ensure that whenever a specific event occurs,any necessary actions are done(regardless of which us
er or application issues the triggering statement).
b)Do not create triggers that duplicate database features.
c)Do not create triggers that depend on the order in which a SQL statement processes rows(which can vary).
d)Use BEFORE row triggers to modify the row before writing the row data to risk.
e)Use AFTER row triggers to obtain the row ID and use it in operations.
f)Do not create recursive triggers.
g)Use DATABASE triggers judiciously.They fire every time any databases user initiates a triggering event.
A)a,b,c,d,e,f
B)a,b,c,d,e,f,g
C)a,c,d,e,f,g
D)c,d,e,f,g
E)a,b,c,d,f,g
ANS-B
6)Which of the following is false about parameterized cursors.
A)Parameters allow values to be passed to a cursor when it is opened and used within the query when it executes
B)These can be opened more than once in a block,by passing different sets of values each time
C)The datatype of the parameters are same as those for scalar variables,but are not given sizes and scales
D)The parameters are treated like PL/SQL,variables within the cursor's query expression
E)None of the above
ANS-
7)Oracle error after installing or upgrading to a new databses that occurs when attempting to connect before Orcale h
as been started.This error states "Oracle not available".
A)ORA-01034
B)ORA-01555
C)ORA-04031
D)ORA-12154
E)ORA-29516
ANS-A
8)Which of the functions are used in WHEN OTHERS exception handler
A)SQLCODE
B)SQLERRM
C)SQLERRNUM
D)ROWNUM
E)None of these
ANS-A and B
9)What is the output of the following code snippet?
DECLARE
SUBTYPE p_integer IS PLS_INTEGER RANGE-11..11;
y_axis p_integer;
PROCEDURE test(x_var IN p_integer)IS
BEGIN
DBMS_OUTPUT.PUT_LINE(x_var);
END test;
BEGIN
y_axis:=13;
test(12);
END
A)Program executes successfully and prints MORE THAN TEN CHARACTERs
B)ORA-06501: PL/SQL:numeric or value error
C)program fails as NULL can be assigned to VARCHAR2
D)Program fails as NULL v_letter cannot be recognised inside procedure
ANS-B
10)Which of these is not a predefined PL/SQL Character Data Types?
A)NCHAR
B)NRAW
C)RAW
D)NVARCHAR
ANS-B
11)YOu have two triggers on the table.When you drop the table:A.ALLtriggers on a dropped table will remain in the
system but would return an error when used. B.All triggers on a dropped
table have been dropped as well.C Dropping a Trigger totally depends on whether the Trigger is on the statement or
a row level.
A)Only A
B)Only B
C)Both A and c
D)Both B and C
ANS-option B(Only B)
12)User-defined functions can be used in:A.Check constraints B.Indexes C.Virtual colums
A)only B
B)only C
C)Both B and C
D)BOth A and C
ANS-option C(Both B and C)
13)Ram developed the following code:What will be the output of above code?DECLARE
l_variable SIMPLE_DOUBLE:
BEGIN
l_variable:=NULL;
dbms_output.put_line('Result is'||l_result);
END;
A)Program Executes Successful and displays Resukt is.....
B)Program fails as ther is a syntax error while assigning NULL
C)Program fails as there is no datatype like SIMPLE_DOUBLE
D)Program fails as SIMPLE_DOUBLE cannot hold NULL values
ANS-D
14)Which of following auditing types can be used as the simplest way to audit procedure Execution?A. Schema obje
ct auditing B.Priviledge auditing C.Statement auditing
A)Only A
B)Only B
C)Only C
D)Both B and C
ANS-Option C
15)To define independent block,you use which of the following Compiler directive pragma?
A)AUTONOMOUS_BLOCK
B)AUTONOMOUS_TRANSACTION
C)INDEPENDENT_BLOCK
D)AUTONOMOUS_STRING
ANS-B
16)Which system privilege enables someone to execute anyusers's function in database?A.Execute any procedure B
>Execute any function C.Execute any unit
A)only A
B)only B
C)both B and C
D)Both A and B
ANS-option D
17)You have been asked to look employee table using LOCK TABLR statement in a specified lock mode so that to
allow concurrent access to a table;they prevent other users
from locking the entire table for exclusive use.Which type of lock you will use here?
A)LOCK TABLE employee IN ALLOW SHARE MODE NOWAIT;
B)LOCK TABLE employee IN TABLE SHARE MODE NOWAIT;
C)LOCK TABLE employee IN ROW SHARE MODE NOWAIT;
D)There is not such lock
ANS-C
18)What are database triggers?Please select all the correct answers
A)Set of PLSQL package
B)Set of PLSQL function
C)Set of code fires automatically after DDL operations performed
D)Set of code fires automatically after DML operations performed
E)Set of code fires automaticalyy before DML operations performed
ANS-B,C,D,E
19)Native Dynamic SQL has been integrated into the PL/SQL language by adding one new statement ___________
_,which executes a specified SQL statement immediately by enhancing
the OPEN FOR statements
A)Open For
B)Execute Immediate
C)Execute Immediate and Open for
D)None of the above
E)All of the above
ANS-B
20)Which of the following is true about bind variables
A)Bind variables are also called non-PL/SQL variables
B)Bind variables are also calles PL/SQL variables
C)These variables are declared in the host environment such as SQL Plus
D)They can be referenced in PL/SQL statements,by prefixing the colon(:)before the variable name
E)They can be referenced in PL/SQL statements,by suffixing the colon(:)after the variable name
ANS-A,C,D
21)Which of the following is true about LOBs.A LOB can be
Ans-A,B and C
A)An attribute of a user-defined type
B)A column in a table
C)A bind or host variable
22)When you normalize a relation by breaking it into two similar relations,what must you do to maintain data integri
ty?
ANS-*Link the relations by a common field
*Create a primary key(s) for the new relation
23)In which of the following scenarios,you cannot overload subprograms
ANS-*You cannot overload two subprograms if thier formal parameters differ only in subtype and the different subt
ypes are based on types in the same family(...)
*Two functions that differ only in return type,even if the types are in different families
24)Which of these is a procedure(PL/SQL block) that contains the SQL statements and PL/SQL code to be executed
?
ANS-Trigger Action
25)What will be the outcome of the following code?
DECLARE
BEGIN
NULL;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT>PUT_LINE
(Here is the code);
END;
ANS-COde will fail due to un-handled exception
26)TO handle error comditions(typically ORA messages)that have no predefined name,you must use which of the fo
llowing?
ANS-EXCEPTION_INT
27)What will be the outcome?
DECLARE
marks NUMBER;
Subject NUMBER;
BEGIN
Marks:=100;
Subject:=4;
IF marks>30 THEN
marks:+35;
ELSIF subject<5 THEN
marks:=marks-2;
END IF;
CASE marks
WHEN 100 THEN DBMS_OUTPUT_LINE('EXCELLENT');
WHEN 90 THEN DBMS_OUTPUT_LINE('Very Good');
WHEN 80 THEN DBMS_OUTPUT_LINE('Good');
WHEN 33 THEN DBMS_OUTPUT_LINE('Fair');
WHEN 30 THEN DBMS_OUTPUT_LINE('Poor');
END CASE;
ANS-Code fails due to exception RAISE CASE_NOT_FOUND
28)You have written a code which fails due system failure with disk storage or memory which has no relation......
ANS:- Handle named exceptions whenever possible, instead of using when others in exception handlers.
29)What can cause a high value for recursive calls?
ANS:- 1)A high value for recursive calls is cause by improper cursor usage
2)Due to excessive dynamic space management actions
3)Due to excessive statement re-parses.
30)The technology applies the resources of many computers in a network to a single problem at the same time-ususa
lly to scientific or technical problem.....
ANS:-Grid computing
31)What type of index is recommended for a materialzed view containing only joins...
ANS:-An index on the Rowid's of each of the tables used in the join.
32)Gaps in sequence values can occur when?
ANS:-1)A rollback occurs
2)The system crashes
3)A Sequence is used in another table
33)Complete the following and choose the correct option
PACKAGE pich_pkgu
iS
my_flag BOOLEAN = TRUE
END;
which of the following will display true
ANS;- "BEGIN
DBMS_OUTPUT_LINE(case WHEN pich_pkg.my_flag THEN 'TRUE' END);
END;"
34)Which of the following is true about functions when called from SQL statements
ANS:-1)When called from INSERT,UPDATE or DELETE statement function cannot query or modify any databas
e tables modified by that statement
2)When called from a SELECT,INSERT,UPDATE or DELETE statement the function cannot execute SQL tra
nsaction control statements..................
35)Which of the following data dictionary views can you use to get dynamic statastical information about queues?
ANS:-ALL_QUEUES
36)Explain Plan help developers which of the following ways
ANS:-1)Ensure that the the tables are joined in optimal order
2)Determine the most restrictive indexes to fetch the rows
3)Determine the Best internal join method
4)Determine that the SQL is executing the steps in the optimal order.
37)Which of the following is a restriction or cursor variable
ANS :- a)you cannot declare cursor variables in apackage specification
b)You cannot use comparison operators to test cursor variables for equality,inequality,nullity.
38)When the database detects an event the Trigger mechanism executes the action specified in the trigger.The action
can include publishing the event to a queue.........
ANS:-DBMS_AQ_package
39)By default an anonymus block in which type of unit in terms of AUTHID Clauses?
Ans;-IR Unit (invoker)
40)Which of these Triggers can be defined only on views and not on table ?
ANS;-INSTEAD of
41)ACE's are evaluated in the order they appear in the ACL.which of the following is the outcome of evaluating in a
ccess control entry
ANS:- 1)The application privilege is granted
2)The application privelege is denied
42)When should you use oracle external tables VS Oracle SQL "Loader
ANS:-1)To transfer the data as it is being loaded into the database
2)To Load very larger files with large quantities of data
43)Which of the following is true about Real Apllication Security?
ANS:-1)Supports declaritive security policies
2)Enables end-to-end security for multitier applications resources
3)Provides an integrated solution to secure database and application resources
4)Advances the security architecture of oracle database to meet existing and emerging demands........
44)What are all the parameters recquired to execute DBMS_MVIEWESTIMATE_MVIEW_SIZE?
ANS;-1)stmt_id and select_clause in VARCHAR@ data type
2)NUM_rows and num_bytes as number data type
3)stmt_id and select_clause will be IN clause
45)which of the following is true about Pl SQL exceptions
ANS;-1)you cannot declare an exception twice in the same block
2) you can declare the same exception in two different blocks
3)exceptions declared in a block are considered local to the block and global to all it's sub blocks
Q. package can be altered using A.ALTER B.CREATE C.SYS built-in packages
Ans. Both A AND B
Q.Which of the following Can be used to replace in following procedure to enable successful
execution?
create procedure my_new_proc(cRES OUT varhar2) is begin execute immediate
A.select * from dual into cRES B. select * into cREs from dual C.begin Select* into value from
dual;end,using out cRES
Ans. Both A AND C
Q.Inside subprograms,which of the following parameters act like a constant
Ans. IN
Q.______ clause is used to specify a trigger to be a row level Trigger?
Ans. FOR EACH ROW
Q. The EXISTS operator tests for existence of rows in the results set of the subqurey. what happens
when a subqurey row value is found
Ans. THE CONDITION IS FLAGGED TRUE
THE SEARCH CONTINUES IN THE INNER QUREY
Q .Which of the following are used in WHEN OTHERS exception handler
A. SQLCODE
SQLERRM
Q.Evaluate the SQl statement How many roles will user scott have access to? CREATE ROLE clerk;
Ans. 1
Q. Which of these is not a predefined PL/SQL character Data Types?
Ans.NRAW
Q. Procedure debug info can be find in : A. ALL_OBJECTS B.ALL_PROCEDURES
C.ALL_PROBE_OBJECTS
Ans. A,B, and C
Q. Which is the default value of cursor_sharing?
Ans. Exact
Q. which of these is a type of trigger (Both A and B)
A. Application Trigger
B. Database Trigger
C. Package Trigger
Ans. Both A and B
Q. which of these require less storage space as compared to other datatypes?
A. PLS_INTEGER
Q. You have been asked to lock employee table using the LOCK TABLE… which type of lock you will
use here?
Ans. LOCK TABLE employee IN ROW SHARE MODE MOWAIT;
Q. User-defined functions can be used in: A. Check Constraint B. Indexes C. Virtual columns
Ans. Both A and C
Q. How you can reduce or minimize network traffic when passing Host Cursor Variables to PL/SQl?
Ans. You can reduce network traffic by grouping OPEN_FOR statements
Q. Which of the following statements are allowed to be executed by Dynamic SQL
Ans. CREATE,DROP
ALTER
RETURNING INTO Clause
Q. which of the following is true about LOBs. A LOB can be
Ans. An attribute of user defined data type
A coloumn in a table
A bind or host variable
Q. Which of the following is true about bind variables ?
Ans. These Variables are declared in the host environment, such as SQL Plus
They can be referenced in PL/SQL statements, by prefixing the colon(:) before the variable
name
Q. When you normalized a relation by breaking it into two smaller relations, what must you do to
maintain data integrity?
Ans. Link the relations by common field
Create a primary key(s) for the new relation
Q. In which of the following scenarios, you cannot overload subprograms
Ans. 1.You cannot overload two subprograms if their formal parameters differ only in subtype
The different subtypes are based on types in the same family (Varchar and String)
Two functions that differ only in return type, even if the types are in different families.
Q. Which interface allow the DBA to administer that part …shared pool that is used SQL result cache
and PL/SQL function result cache?
Ans. DBMS_RESULT_CACHE package
Q. What is the out put of the following code snipper?
Ans. The sum of products equals: 166
Q. What impact does the below statement has on the rows in the table employee,department?
Ans. No Row is locked by this statement.
Q. When you retrieve into a ROWID variable, you can use which built-in function?
Ans. ROWIDTOCHAR
Q. you have been asked to use the dynamic SQL Statement that is a DMl statement with a
RETURNING INTO clause. What will you do with the bind variables?
Ans. Put in-bind arguments in the USING clause and out-bind arguments in the RETURNING INTO
clause.
Q. Which will be the outcome of the following code?
Ans. Code will fail due to un-handled exception.
Q. You have written a code which fails due system failure with disk storage or memory which has no
relation how you will handle these type of situations?
Ans. Handle named exceptions whenever possible, instead of using WHEN OTHERS in exception
handlers.
Q. Compile the following package and chose the correct option
Ans. BEGIN DBMS_OUTPUT.PUT_LINE (plch_pkg.my_flag);
Q. Which of the following is true about functions when called from SQL statements.
Ans. When called from INSERT,UPDATE, or DELETE statement, function cannot query or modify any
database tables modified by that statement
When called from SELECT, INSERT ,UPDATE OR DELETE ……….ALTER SYSTEM
Q. Which of the following is true about the WHERE CURRENT OF clasue is CURSORS
Ans. IF A CURSOR IS DECLARED…
THIS ALLOWS UPDATES….
THIS CLAUSE EVALUATES TO THE ROW…….
Q. oracle generates Bytes code for PLSQL Program unit when:
Ans. PLSQL_CODE_TYPE is set to INTERPRETED
Q. Which features are a part of the procedures in the DBMS_STATS package that are not used by the
ANALYZE command?
Ans. Parrlel,external,storing execution,forcing
Q. SYS PACKAGE UTL_RECOMP IS USED…….A.RECOMPILE CAN… B.Package must be… C. package do
not support..
Ans. BOTH A AND B
Q. Which of the packages are used for correcting blocks corrupted in the database?
Ans. DBMS_REPAIR
Q. Procedure compile_schema is a part of which SYS Package?
Ans. DBMS_UTILITY
Q. which of the following are the advantages of Application sessions
A. Application session encapsulate
They enable applications…
An application session can be………
They are accessible by all nodes……..
Q. Which of the following is true about Real Application security
Ans. Supports declarative security …………
Enables end-to-end security…………
Provides an integrated….
Advances the security……..
Q. Which of the following is true about principals in real application security
Ans. Principals are users..
Principal I an..
Principal is a……
Q.Which of the following are the techniques for data masking
Ans. Condition-based Masking
Compound Masking
Deterministic Masking
Q.which of the following is true about plsql exceptions
Ans. You cannot…….
You can declare……..
You can raise………
Exceptions declared……….