Which of the following is true about execution section of PL SQL block?
Answer : B. Q 5 – Which of the following is true about the execution section of a PL/SQL block? A – It is enclosed between the keywords BEGIN and END.
Which of the following is not true about PL SQL?
Q 2 – Which of the following is not true about PL/SQL loop structures? … B – The WHILE loop repeats a statement or group of statements while a given condition is true. C – The FOR loop executes a sequence of statements multiple times and abbreviates the code that manages the loop variable.
Which of the following is not true about PL SQL constants and literals *?
Which of the following is not true about PL/SQL constants and literals? A constant holds a value that once declared, does not change in the program. The CONSTANT declaration cannot impose the NOT NULL constraint. A constant is declared using the CONSTANT keyword.
Which of the following is not true about PL SQL nested tables?
Which of the following is not true about PL/SQL nested tables? Nested table is similar to declaration of an index-by table along with INDEX BY clause. A nested table can be stored in a database column. Elements of a nested table could be a %ROWTYPE of any database table.
Which of the following is not true about PL SQL triggers?
Which of the following is not true about PL/SQL triggers? Triggers are stored programs. They are automatically executed or fired when some events occur. Triggers could be defined on the table, view, schema, or database with which the event is associated.
Which of the following is true about PL SQL package body?
Which of the following is true about PL/SQL package body? The package body has methods declared in package specification and private. It is created using the CREATE PACKAGE Statement.
Which of the following is not valid is PL SQL?
Which SQL function is used to count the number of rows in a SQL query?
|Q.||Which of the following is NOT VALID is PL/SQL?|
|D.||date1 date := sysdate|
|Answer» b. NUM1, NUM2 number;|
Which of the following are the advantages of PL SQL packages?
PL/SQL has these advantages:
- Tight Integration with SQL.
- High Performance.
- High Productivity.
- Support for Object-Oriented Programming.
- Support for Developing Web Applications.
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.
What is true about PL SQL functionalities?
What is TRUE about PL/SQL functionalities? Conditions and loops are fundamental elements of procedural languages like PL/SQL. Various types and variables can be declared, as can procedures and functions, as well as types and variables of those types.
Which of the following is not valid SQL type?
Explanation: DECIMAL is not a valid SQL type because it is nothing but numeric only in SQL. NUMERIC has fixed precision, and scale numbers range from -10^38+1 to 10^38-1.
Which of the following is true about scalar data types in PL SQL Mcq?
Q 11 – Which of the following is true about scalar data types in PL/SQL? … B – Examples of scalar data types are NUMBER, DATE, or BOOLEAN. C – PL/SQL provides subtypes of data types. D – All are true.
Which of the following is true about PL SQL nested table?
Q 7 – Which of the following is true about PL/SQL nested tables? A – Nested tables are like one-dimensional arrays with arbitrary number of elements. B – Unlike arrays a nested table doesn’t have declared number of elements. The size of a nested table can increase dynamically.
Which of the following events require execution of trigger as its response?
Triggers are written to be executed in response to any of the following events. A database manipulation (DML) statement (DELETE, INSERT, or UPDATE). A database definition (DDL) statement (CREATE, ALTER, or DROP). A database operation (SERVERERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN).
Which of following is true concerning a procedure?
|Que.||Which of the following is true concerning a procedure?|
|b.||They do not need to have a unique name.|
|c.||They include procedural and SQL statements.|
|d.||They are the same thing as a function.|
|Answer:They include procedural and SQL statements.|