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: Apr 24, 2024

Upd_bat_stat(v_id);

1 Answer

1050 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

1010 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

985 views

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

John Smith
Answered: Apr 24, 2024

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

1 Answer

950 views

Which SQL functions can operate on any datatype?

CHNAJ
Answered: Apr 24, 2024

Ceil

1 Answer

798 views

What are the advantages of Pl SQL?

John Smith
Answered: Apr 24, 2024

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

1 Answer

785 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

776 views

What will be the output of the following code?

Ranaguha
Answered: Apr 24, 2024

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

1 Answer

688 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

586 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

562 views

Why do stored procedures and functions improve performance?

Tikamp
Answered: Apr 24, 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

550 views

What are implicit cursors?

Sudha_test
Answered: Apr 24, 2024

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

1 Answer

543 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

489 views

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

John Smith
Answered: Apr 24, 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: Apr 24, 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

375 views

Pl SQL Quizzes

Pl SQL Questions and Answers (Q&A)

Related