BCA Eighth Semester Database Programming MCQs of 2021 Batch
BCA Eighth Semester Database Programming MCQs of 2021 Batch
Multiple Choice Questions
i. Which SQL*Plus command redirects output from a query to a text file?
c) SPOOL
Don’t forget to follow Uni Bytes
ii. What is the shortcut symbol used to run the command stored in the SQL buffer immediately?
a) /
Don’t forget to follow Uni Bytes
iii. Which section of a PL/SQL block is mandatory?
c) BEGIN and END
Don’t forget to follow Uni Bytes
iv. Which cursor attribute returns the number of rows fetched or affected so far?
d) %ROWCOUNT
Don’t forget to follow Uni Bytes
v. What type of cursor is automatically created by Oracle for all Data Manipulation Language (DML) statements?
b) Implicit cursor
Don’t forget to follow Uni Bytes
vi. Which statement is used to skip the remaining part of the current loop iteration and move directly to the next iteration?
c) CONTINUE WHEN
Don’t forget to follow Uni Bytes
vii. What is the main difference between a Procedure and a Function in PL/SQL?
b) A function must return a value, while a procedure does not require one.
Don’t forget to follow Uni Bytes
viii. For which database component are standard DML triggers typically not supported?
d) Standard Views
Don’t forget to follow Uni Bytes
ix. What is a key operational advantage of using a Stored Procedure instead of multiple individual SQL queries?
c) It offers faster execution through pre-compiled code execution plans and reduces network traffic.
Don’t forget to follow Uni Bytes
x. How do you define an optional parameter with a default value of ‘Nepal’ in a SQL stored procedure?
b) @Country VARCHAR(50) = ‘Nepal’
Don’t use our content without permission. 📸⚠️
Thank you for sharing you everyone! If you’d like to share your notes, lab reports, solution, assignments, projects, or any other academic materials, feel free to contact us through social media (Uni Bytes), email us at unibytesofficials@gmail.com, or visit our website at www.unibytes.xyz.
We regularly provide updates on BCA news, results, exam routines, and other important information. Stay connected with Uni Bytes for all your academic needs
📢 Stay Connected with Us!
Follow us on social media for the latest updates, events, and more:
