By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,760 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,760 IT Pros & Developers. It's quick & easy.

Oracle Problems

P: 2
Dear ,

Please let me know the correct answer for the following


1.Which three statements about subqueries are true? (Choose three.)

A. A single row subquery can retrieve only one column and one row.
B. A single row subquery can retrieve only one row but many columns.
C. A multiple row subquery can retrieve multiple rows and multiple columns.
D. A multiple row subquery can be compared using the ">" operator.
E. A single row subquery can use the IN operator.
F. A multiple row subquery can use the "=" operator.

2.Which two are attributes of iSQL*Plus? (Choose two.)

A. iSQL*Plus commands cannot be abbreviated.
B. iSQL*Plus commands are accessed from a browser.
C. iSQL*Plus commands are used to manipulate data in tables.
D. iSQL*Plus commands manipulate table definitions in the database.
E. iSQL*Plus is the Oracle proprietary interface for executing SQL statements

3.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


Regards
Samay Jain
Oct 25 '07 #1
Share this Question
Share on Google+
7 Replies


amitpatel66
Expert 100+
P: 2,367
Dear ,

Please let me know the correct answer for the following


1.Which three statements about subqueries are true? (Choose three.)

A. A single row subquery can retrieve only one column and one row.
B. A single row subquery can retrieve only one row but many columns.
C. A multiple row subquery can retrieve multiple rows and multiple columns.
D. A multiple row subquery can be compared using the ">" operator.
E. A single row subquery can use the IN operator.
F. A multiple row subquery can use the "=" operator.

2.Which two are attributes of iSQL*Plus? (Choose two.)

A. iSQL*Plus commands cannot be abbreviated.
B. iSQL*Plus commands are accessed from a browser.
C. iSQL*Plus commands are used to manipulate data in tables.
D. iSQL*Plus commands manipulate table definitions in the database.
E. iSQL*Plus is the Oracle proprietary interface for executing SQL statements

3.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


Regards
Samay Jain
Samay,

We do not solve theoritical assignment questions.
Oct 25 '07 #2

debasisdas
Expert 5K+
P: 8,127
Kindly post the answers that you think is correct for further discussion on the topic.
Oct 25 '07 #3

P: 2
Please find the answers as below :-

1. Ans : BCD but it should be BCE

2. Ans: D,E - Want to know is this anwser is correct.

3. Ans : B,D but it swhould be A,B,D

Thanks...Samay
Oct 25 '07 #4

amitpatel66
Expert 100+
P: 2,367
Please find the answers as below :-

1. Ans : BCD but it should be BCE

2. Ans: D,E - Want to know is this anwser is correct.

3. Ans : B,D but it swhould be A,B,D

Thanks...Samay
Yes, first one is BCE
Second is B,E
Third: the query can be used for viewing data,inserting,updating as well as deleting.
Oct 25 '07 #5

P: 3
. What is true about joining tables through an equijoin?
A. You can join a maximum of two tables through an equijoin.
B. You can join a maximum of two columns through an equijoin.
C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
D. To join two tables through an equijoin, the columns in the join condition must be primary key and
foreign key columns.
E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a
minimum of n-1 join conditions.




. Which three statements correctly describe the functions and use of constraints? (Choose three.)
A. Constraints provide data independence.
B. Constraints make complex queries easy.
C. Constraints enforce rules at the view level.
D. Constraints enforce rules at the table level.
E. Constraints prevent the deletion of a table if there are dependencies.
F. Constraints prevent the deletion of an index if there are dependencies.


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.
Jul 5 '09 #6

P: 3
Comparison operators are used in

a. natural join
b. equijoin
c. non equijoin
d. outer join


You can join two tables by using one or more columns that have the same name in

a. natural join
b. equijoin
c. self join
d. none


Select vFirstname, cName from Accountant, Recruiter
where Accountant . cRecruitercode = Recruiter . cRecruitercode(+);

What join is performed in this query?

a. outer join
b. right outer join
c. left outer join
d. full join


in a where clause, the level of subqueries that are possible are

a. 2
b. 255
c. 100
d. 4
e. 10



When a join is implemented, a primary key is validated against the foreign key

a. true
b. false

A join operator can not be combined with another condition when using logical operators like

a. and
b. or
c. not
d. in
e. between….and
Choose all that apply.


.What will happen if you call a SQL function with an argument of a datatype other than the datatype expected by a SQL function?

A. the argument will need to be converted explicitly

B. the argument will be rejected

C. the argument will be accepted as is

D. the argument will be converted implicitly
Jul 5 '09 #7

P: 3
please do let me the correct options for the above questions as soon as possible.
Jul 6 '09 #8

Post your reply

Sign in to post your reply or Sign up for a free account.