Advertisement

Pl SQL Questions and Answers (Q&A)

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

1018 views
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

986 views
John Smith
Answered: Jun 22, 2024
The view associated with the trigger.
The event associated with the trigger.

1 Answer

953 views
CHNAJ
Answered: Jun 22, 2024
Ceil

1 Answer

802 views
John Smith
Answered: Jun 22, 2024
The trigger fails because a SELECT statement on the table being updated is not allowed.

1 Answer

787 views
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

782 views
Ranaguha
Answered: Jun 22, 2024
The statement fails because functions called from SQL expressions cannot perform DML.

1 Answer

692 views
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

587 views
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

566 views
Tikamp
Answered: Jun 22, 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

551 views
Sudha_test
Answered: Jun 22, 2024
Implicit cursors are declared implicitly for all the DML and SELECTstatements.

1 Answer

545 views
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

493 views
John Smith
Answered: Jun 22, 2024
It allows the grantee to grand object privileges to other users and roles.

1 Answer

460 views
Maarsh
Answered: Jun 22, 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

377 views
Advertisement
Advertisement
Loading, please wait...

Email Sent
We have sent an email to your address "" with instructions to reset your password.