databases Online Quiz - 226
Description: databases Online Quiz - 226 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which section of a PL/SQL block commences with the BEGIN keyword?
Which constraint can be defined only at the column level?
Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?
SELECT TO_CHAR(1000000, '$99,999.00') SALARY FROM dual What Is the Output?
There are also multiple-column subqueries: Queries that return more than one column from the inner SELECT statement.(T/F)
What is the output in RR format for following dates Date Specified :27-Oct-1995
Which statement describes the ROWID data type?
What will be the output of following Select 8 from Emp ? Emp table has 10 rows
Is Century Information is recorded when Oracle data base stores the DATE internally into a table?
What is the correct use of the Trunc command on a date?
How many join conditions should be there to avoid a Cartesian Join for joining three tables?
Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?
Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?
Where is the GROUP BY clause statement placed in a SELECT statement that includes a WHERE clause?