Which of the following are not part of SQL?
Which of the following is not a type of SQL statement? Explanation: Data Communication Language (DCL) is not a type of SQL statement. Explanation: The CREATE TABLE statement is used to create a table in a database.
Which of the following is not a PL SQL unit Mcq?
4. ____________is not a PL/SQL unit. Table is not a PL/SQL unit.
Which are the section of PL SQL in the following?
A PL/SQL block consists of three sections: declaration, executable, and exception-handling sections. In a block, the executable section is mandatory while the declaration and exception-handling sections are optional. A PL/SQL block has a name.
What are the components of PL SQL?
A PL/SQL block consists of up to three sections: declarative (optional), executable (required), and exception handling (optional).
- Arvind209. Answered On : Jun 29th, 2008.
- Component of PL/SQL Block are Begin(Optional), Declare(Mandatory), Exception(Optional), END(Mandatory).
What is the purpose of trigger?
Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion. Each trigger is attached to a single, specified table in the database. Triggers can be viewed as similar to stored procedures in that both consist of procedural logic that is stored at the database level.
Which identifier is valid in PL SQL?
You can use uppercase, lowercase, or mixed case to write identifiers. PL/SQL is not case-sensitive except within string and character literals. Every character, including dollar signs, underscores, and number signs, is significant.
Is in PL SQL?
Question: What is the difference between ‘IS’ and ‘AS’ in PL/SQL? Answer: The PL/SQL language evolved such the the “IS” and “AS” operators are equivalent. Functionally the “IS” and “AS” syntax performs identical functions and can be used interchangeably.
What are identifiers in PL SQL?
An identifier is a name for a PL/SQL object, including any of the following:
- Constant or variable.
- Program name: procedure, function, package, object type, trigger, etc.
- Reserved word.