19 Best Pl SQL Questions and Answers (Q&A) - ProProfs Discuss

Most Read

Examine this procedure: CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID,LAST_NAME) VALUES (V_ID, V_LAST_NAME); COMMIT; END; This...

Ranaguha
Answered: Jan 22, 2025

Upd_bat_stat(v_id);

1 Answer

1061 views

How do you select all the records from a table named "EMP" where the value of the column "Last_Name" is "KING"?

John Adney
Answered: Jul 23, 2017

When the like keyword is used the % sign should be used

select * from emp where last name = 'KING' is the correct answer

5 Answers

1029 views

What is true about sequences in SQL?

Markda John
Answered: Jan 02, 2018

A minimum ascending value of 1 is entered by default. The starting value can change, as Kratika states above. However, a maximum of one does not make sense when you are talking about decreasing;...Read More

3 Answers

997 views

Which two dopes the instead of clause in a trigger identify in SQL?

John Smith
Answered: Jan 22, 2025

The view associated with the trigger.
The event associated with the trigger.

1 Answer

964 views

Which SQL functions can operate on any datatype?

CHNAJ
Answered: Jan 22, 2025

Ceil

1 Answer

811 views

What are the advantages of Pl SQL?

John Smith
Answered: Jan 22, 2025

The trigger fails because a SELECT statement on the table being updated is not allowed.

1 Answer

796 views

Which two circumstances do you use to design database triggers?

N. Kingsley, Writer
Answered: Sep 18, 2018

A database trigger is run when specific actions occur within a database. Triggers help the database designer ensure operations, such as maintaining an audit file. The triggers can happen after or...Read More

3 Answers

794 views

What will be the output of the following code?

Ranaguha
Answered: Jan 22, 2025

The statement fails because functions called from SQL expressions cannot perform DML.

1 Answer

695 views

What is the primary key?

E. Stanley, Technical writer
Answered: Oct 11, 2018

Candidate key.
It is a column that is use to uniquely qualify and identify a database record without referring to another data. One of the candidate keys is selected as the table primary...Read More

3 Answers

590 views

What does LOB stands for in database language?

I.Elizabeth
Answered: Feb 22, 2018

PL stands for Procedural Language and SQL refers to Structured Query Language. They are connected to Oracle's database management system and are a programming language. LOBs are databa...Read More

2 Answers

571 views

Why do stored procedures and functions improve performance?

Tikamp
Answered: Jan 22, 2025

They postpone PL/SQL parsing until run time.
They reduce the number of calls to the database and decrease network traffic by bundling commands.

1 Answer

555 views

What are implicit cursors?

Sudha_test
Answered: Jan 22, 2025

Implicit cursors are declared implicitly for all the DML and SELECTstatements.

1 Answer

548 views

What are subqueries in SQL?

Profa
Answered: Oct 06, 2017

Answers that are supposed to be correct are ridiculous. Scalar subqueries do not have to fetch data from the same table as main query. It is NOT true that only one column can be compared between...Read More

3 Answers

502 views

What is true about the WITH GRANT OPTION clause in SQL?

John Smith
Answered: Jan 22, 2025

It allows the grantee to grand object privileges to other users and roles.

1 Answer

461 views

How would you define subqueries in SQL?

Maarsh
Answered: Jan 22, 2025

A main query can have more than one subquery.
The subquery and main query must retrieve data from the same table.
Only one column or expression can be compared between the subquery and...Read More

1 Answer

386 views

Pl SQL Quizzes

Pl SQL Questions and Answers (Q&A)

Related