What does SQL stand for?
Structured Query Language
Strong Question Language
Structured Question Language
Which SQL statement is used to extract data from a database?
Select
Upadte
Delete
Truncate
Which SQL statement is used to update data in a database?
Save
Update
Modify
Set
Which SQL statement is used to insert new data in a database?
Add Row
Add Record
Insert
Set
With SQL, how do you select a column named 'FirstName' from a table named 'Persons'?
SELECT Persons.FirstName
SELECT Persons.FirstName
SELECT FirstName FROM Persons
What is TRUE about VIEWs ?
A VIEW can be created as a JOIN on two or more TABLEs.
A VIEW cann't have an ORDER BY clause in the SELECT statement.
A VIEW cann't have an GROUP BY and HAVING clause in the SELECT statement
A VIEW must have the column alias on SELECT statement of the VIEW creation.
What is the command used to encrypt a PL/SQL application?
ENCRYPT
DECRYPT
WRAP
UNWRAP
AUTONOMOUS_TRANSACTION is a:
Programming techniques
Automatically used in all programs
PL/SQL compiler directive
None of the above
Which is TRUE for ROWID data type ?
Binary Data upto 4GB
Character data upto 4GB.
A hexadecimal string representing the unique address of a row in its table
Binary data stored in an external file.
What are the difference between %ROWTYPE and
%TYPE in PL/SQL?
%ROWTYPE is used to associate a variable with an entire table row whereas %TYPE is used to associate a variable with a single column type
%ROWTYPE can be used in a cursor array processing whereas %TYPE cann't be
%TYPE can be used in a cursor array processing whereas ROWTYPE cann't be.
%ROWTYPE can be used in a SQL also whereas %TYPE cann't be in SQL.
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) from dual;
Error
0
1
0.00
PACK_MESSAGE is used in
queeing
piping
AUTONOMOUS TRANSACTIONS
Host I/O