databases Online Quiz - 146
Description: databases Online Quiz - 146 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
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
The Syntax to declare a record of a User-defined datatype is:
There are ______ types of loops in PL/SQL
Which of the following is not a way to execute stored functions
SQL%ISOPEN attribute always returns null in implicit Cursors.
Implicit Cursors are created by users in PL/SQL block.
Oracle engine creates Cursors for every SELECT statements.
There are 4 attributes of Cursor variables
Explicit Cursors need to be opened in DECLARE section.
Which SQL keyword is used to retrieve a minimum value?
The table rows are also known as...
What is the ABS SQL function used for?
Which SQL keyword is used to retrieve only unique values?
What does DML stand for?
Which of the following commands is used to delete data from a SQL database table?
Which of the following is not a SQL keyword or SQL clause?
There are triggers for…