Home » SQL & PL/SQL » SQL & PL/SQL » help for slecting right options
help for slecting right options [message #220225] Mon, 19 February 2007 12:05 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member
Which two statements about subqueries are true? (Choose two.)



A. A single row subquery can retrieve data from only one table.

B. A SQL query statement cannot display data from table B that is referred to in its
subquery, unless table B is included in the main query's FROM clause.

C. A SQL query statement can display data from table B that is referred to in its
subquery, without including table B in its own FROM clause.

D. A single row subquery can retrieve data from more than one table.

E. A single row subquery cannot be used in a condition where the LIKE operator is used
for comparison.

F. A multiple-row subquery cannot be used in a condition where the LIKE operator is
used for comparison.

C D F But question ask to select only 2.

C As it can display data without being part of FROM clause of main query.

SELECT last_name,(SELECT department_name from departments D WHERE D.department_id = E.department_id)
FROM employees



-----------------------------------------------------------------------------------------------------------------------
When should you create a role? (Choose two)



A. to simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy st
atement

B. to grant a group of related privileges to a user

C. When the number of people using the database is very high

D. to simplify the process of granting and revoking privileges

E. to simplify profile maintenance for a user who is constantly traveling.



C D

but many are in favour C & B What you say.


----------------------------------------------------------------------------------------------------------------------

From SQL*Plus, you issue this SELECT statement:
SELECT * FROM orders;
You use this statement to retrieve data from a database table for _______________. (Choose all that apply)

A. updating
B. viewing
C. deleting
D. inserting
E. truncating

Can this also be use for inserting !!!!!!!!!??????
Re: help for slecting right options [message #220270 is a reply to message #220225] Tue, 20 February 2007 00:07 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If memory serves me right, this is the THIRD time you ask this...
Topic locked.
Previous Topic: New user with CREATE SESSION privilege
Next Topic: data in sample table can't be inserted into db- error :ORA-00054
Goto Forum:
  


Current Time: Sun Dec 04 08:55:36 CST 2016

Total time taken to generate the page: 0.04654 seconds