Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?A. SQRTB. DECODEC. NEW_TIMED. ROWIDTOCHAR
Latest Answer: answer: b ...
The user issues the following statement. What will be displayed if the EMPID selected is 60494? SELECT DECODE(empid, 38475, "Terminated",60494, "Recruited", "NotRecruited") FROM emp;A. 60494B. 38475C. TerminatedD. Recruited
In order to perform an inner join, which criteria must be true?A. The common columns in the join do not need to have shared values.B. The tables in the join need to have common columns.C. The common columns in the join may or may not have shared values.D. The common columns in the join must have shared values.
Once defined, how long will a variable remain so in SQL*Plus?A. Until the database is shut downB. Until the instance is shut downC. Until the statement completesD. Until the session completes
The default character for specifying runtime variables in SELECT statements isA. AmpersandB. ColonC. HashD. Asterisk
A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?A. select e.empid, d.head from emp e, dept d;B. select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;C. select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);D. select e.empid, d.head from emp e, dept d where
For avoiding a cartesian product of 4 tables, the minimum number of joins required after WHERE clause is:A. 2B. 3C. 4D. 5
Which one of the following uses of the HAVING clause is inappropriate?A. To put returned data into sorted orderB. To exclude certain data based on known criteriaC. To include certain data based on unknown criteriaD. To include certain data based on known criteria
The "emp" table contains 14 rows. How many rows will the following query return?SQL> Select * from Emp where rownum > 5;A. 9B. 10C. 0D. Error
View page << Previous 5 6 7 8 [9] 10 11 12 13 Next >>
Go Top
