|Description: programming languages Online Quiz - 49|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
|Tags: programming languages|
A Rollback statement cannot be used to close transaction
Procedure C is a local construct to the package. What happens when this package is compiled?
In a PL/SQL block structure, which parts are optional?
_________ data type stores unstructured binary data upto 4GB length
SQL has facility for programmed handling of errors that arise during the manipulation of data
Raw types are used to store _________ data.
The __________ attribute is used to declare variables based on definitions of columns in table
SELECT name,salary , dept FROM emp e WHERE NOT EXISTS (SELECT 1 FROM dept WHERE deptno = e.dept); Which employees are retrieved from the above query:
A table has following 2 columns with the given valuesc1 c2 -------------- 1 1 1 NULL 2 0 NULL NULL . What will be the output of the following query :select count(*) , count (c1+c2) , count (distinct (c1 + c2)) from temp;
SELECT ROUND(123.456,2) , TRUNC(123.456,2), ROUND(125.456, -1) , TRUNC(126.456,-2) FROM DUAL;
While creating tables, the concept that is used to reduce redundancy in data is called
An attribute declared as primary key can have null values.
1)SELECT bus_name, profit 2) FROM business 3) WHERE city = 4) (SELECT city FROM locations 5) WHERE city LIKE 'Noid_' 6) AND state = 'UP') 7) ORDER BY profits desc; How do you modify the above code if you want to avoid causing an error if the subquery returns more than one row.
Which statement selects the odd number of records :
Which of the following queries can be used to delete duplicate records from a table -