Oracle MCQ with answer | Oracle Objective type question answer | Oracle Multiple Choice Question with answer | Oracle Database Question answer | Oracle Database SQL Basics MCQ | TOP ORACLE DBA Objective Questions and Answers
51.We can use other SQL DDL statements like Create, Drop, Alter, Grant, and Revoke?
ANS – TRUE
52.What are the commands that can be used in setup section.
A. Ask, BEGIN- SQL, Declare-Chart
B. Declare-Variable, Load-Lookup, Use
C. Declare-Printer, Declare- Procedure, Declare-Report, Declare-Variable, Load-Lookup
D. All of these
53.In which sections, the Begin-Select paragraph is allowed.
ANS – Begin-Program, Begin-Procedure
54.How many files can be opened at any time?
ANS – 256
55.What is the purpose of load-lookup command?
ANS – Used for faster access of the data from database tables
56.What is the use of Last-Page command?
ANS – To print last page number on each page
57.The purpose of Document Section -(BEGIN-DOCUMENT and END-DOCUMENT) is to
ANS – create form letters/business letters.
58.What happens if you haven’t written the close command for all the files you opened in the program?
ANS – The files will be closed on successful termination of the program
59.Which is the command to create a report whose name is not same as that of program name?
ANS – NEW-REPORT
60.What should be the parameters to load-lookup if the table ps_personal_data is accessed and lookup syntax is as follows: Lookup names $emplid $name?
ANS – Load-lookup Name=names Table=ps_person al_data Key=emplid Return_value=name
61.What is the purpose of document markers, how are they represented?
ANS – Document markers are represented by @ and they are the means to mark a position in the document where you place data from areas external to the document paragraph parts of the program
62.Which of the following is not true about file handling?
ANS – SQR internal variable #end-file is set to 0 when there are no more records to read.
63.When a STOP command is issued , what happens to the SQR program
ANS – STOP command halts SQR program and causes a ROLLBACK command to be performed
64.BEGIN-SQL Update ps_personal_data Set zip=$new_zip Where zip=$old_zip End-SQL. In the above SQL statement how do you get the count of rows updated?
ANS – Use reserved variable #SQL- count
65.How do you make a procedure Get-Dept-Id as local
ANS – How do you make a procedure Get-Dept-Id as local, By using procedure arguments like – < Begin-
Procedure Get- Dept-Id ($dept_id)
66.open-status returns the status of I/O operation commands in SQR
ANS – TRUE
67.To work with effective-dated data, which of the following methods have to be used?
ANS – CurrentItem, GetEffectiveItem
68.To load data from a CSV input file into PeopleSoft using a batch program, the following can be used
ANS – CI with AE and File Layout, CI with AE
69.Any section in any application engine program which is set as a private, can call from any application engine program dynamically
ANS – FALSE
70.The physical, dedicated tables are locked at the time the Application Engine program is loaded into memory? State True or False.
ANS – TRUE
71.In Application Engine Program, in %SelectInit meta sql funtion, if any values have not selected then previous value will be there. State TRUE or FALSE
ANS – FALSE
72.In an Application Engine Program, what is the maximum number of Actions in a Step?
ANS – 7
73.Benefits of Component Interface is listed below.
A.Saves time and money
B.Customization is insulated from complexities of the application
C.Upgradeable using PeopleTools
D.Delivers PeopleSoft Logic
E.All of the above
74.Which of the following function is used to handle errors in CI ?
ANS – ErrorHandler
75.Which CI method cannot be used, when CI is in update mode?
ANS – Create