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: Nov 21, 2024

Upd_bat_stat(v_id);

1 Answer

1059 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

1025 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

996 views

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

John Smith
Answered: Nov 21, 2024

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

1 Answer

959 views

Which SQL functions can operate on any datatype?

CHNAJ
Answered: Nov 21, 2024

Ceil

1 Answer

810 views

What are the advantages of Pl SQL?

John Smith
Answered: Nov 21, 2024

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

1 Answer

793 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

791 views

What will be the output of the following code?

Ranaguha
Answered: Nov 21, 2024

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

1 Answer

693 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

570 views

Why do stored procedures and functions improve performance?

Tikamp
Answered: Nov 21, 2024

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

554 views

What are implicit cursors?

Sudha_test
Answered: Nov 21, 2024

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

500 views

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

John Smith
Answered: Nov 21, 2024

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

1 Answer

460 views

How would you define subqueries in SQL?

Maarsh
Answered: Nov 21, 2024

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

384 views

Pl SQL Quizzes

Pl SQL Questions and Answers (Q&A)

Related