The UNION ALL operator does not eliminate duplicate selected rows from the result set.
True
False
The ALTER SEQUENCE statement can affect only the future sequence numbers
If you use the CREATE DATABASE statement on an existing database, all data in the datafiles will be lost.
The ALTER TRIGGER command can be used to change the definition of an existing trigger.
PDoees PL/SQL stands for Procedural Language extension of SQL
What is the syntax of select .... into statement
SELECT row_name INTO variable_name FROM table_name [WHERE condition];
SELECT column_name INTO variable_name FROM table_name [WHERE condition];
SELECT column_name INTO variable_name FROM table_name [WHEN condition];
SELECT table_name INTO variable_name FROM table_name [WHERE condition];
The Syntax to declare a record of a User-defined datatype is:
table_name record_type_name;
column_name record_type_name;
record_type_name record_name;
record_name record_type_name;
There are ______ types of loops in PL/SQL
1
3
2
4
Which of the following is not a way to execute stored functions
EXECUTE [or EXEC] database.function_name;
employee_name := employer_details_func;
SELECT employer_details_func FROM dual;
dbms_output.put_line(employer_details_func);
SQL%ISOPEN attribute always returns null in implicit Cursors.