Wednesday, 20 January 2016

Computer Quiz MCQs for IBPS IT Officer Exam : PL/SQL 142

Dear experts, Computer Quiz MCQs for IBPS IT Officer Exam : PL/SQL : here mm team presenting most expected computer quiz questions for your upcoming IBPS IT officer Exam 2016.

Q.1 What does the / command do?
a) Does nothing
b) Prints the character
c) Re-executes the non SQL *PLUS command that was most recently executed.
d) Re-execute the most recently executed command

Q.2 SQL*Plus will know you are typing a PL/SQL block when it encounters the keyword?
a) PL/SQL
b) BEGIN
c) EXCEPTION
d) DECLARE

Q.3 Which of the following is buffered by SQL*Plus?
a) SQL Statements
b) SQL*Plus commands
c) PL/SQL block
d) None of these

Q.4 A script file that is executed by SQL *Plus cannot contain?
a) SQL *Plus commands
b) SQL statements
c) PL/SQL block
d) none of these

Q.5 Script files can be executed by the?
a) START command
b) STA command
c) @ command
d) EXECUTE command

Q.6 Which of the following method cannot be used to specify a comment in SQL*Plus scripts?
a) --
b) REMARK
c) /*....*/
d) None of these

Q.7 The DESCRIBE command if used on a table, will not display information about?
a) primary key
b) default values
c) indexes
d) triggers

Q.8 A PL/SQL block can return data to SQL*Plus through?
a) bind variables
b) substitution variables
c) local variables
d) none of these

Q.9 The owner of the DUAL table is?
a) SYS
b) SUPERUSER
c) SCOTT
d) MANAGER

Q.10 SGA stand for?
a) Show Global Area
b) Start Global Area
c) System Globel Area
d) Shut Globel Area

Answer key will be published soon Today.
Anskey key updated: Red color option(s) mean correct answer.

No comments:

Post a Comment

Advertisement