help for slecting right options [message #220225] |
Mon, 19 February 2007 12:05  |
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 !!!!!!!!!??????
|
|
|
|