| naidu |
Posted: Dec 26, 2006 06:28:06 AM |
Total Post: 85
Joined: Nov, 2006
|
Which statement correctly describes SQL and /SQL*Plus?
A. Both SQL and /SQL*plus allow manipulation of values in the database.
B. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
C. /SQL*Plus is a language for communicating with the Oracle server to access data;
SQL recognizes SQL statements and sends them to the server.
D. SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database.
Answer:
Plz help me on this |
|
|
 Jayanta |
| Posted: Dec 26, 2006 02:06:40 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
Any database package can use sql for dml,ddl,dcl,tcl purposes
But sql*plus is an oracle proprietary interface which accepts sql and passes it to oracle server. So sql*plus is not a language.
Sql*plus has its own set of commands like describe, auto commit etc and they can be abbreviated. Sql*plus commands can’t manipulate oracle data.
Hope this will work
With regards
jayanta
|
|
|
|
|
| naidu |
| Posted: Dec 27, 2006 03:09:18 AM | |
|
Total Post: 85
Joined: Nov, 2006
|
plz give a proper ans for this i am not getting ans which have u sent to me plz
|
|
|
|
|
| Jayanta |
| Posted: Dec 27, 2006 04:24:50 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
option a is definitely wrong.
u wrote option b as
B. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
here "/SQL*Plus recognizes SQL statements and sends them to the server;" is correct but the next portion of this option "SQL is the Oracle proprietary interface for executing SQL statements. " is wrong bcos it is sql*plus not sql is the Oracle proprietary interface for executing SQL statements.
option c is also wrong i have already given the explanation.
again first portion of option d (before ;) is correct and the rest is wrong.
hope u have mistyped the question by joining two options into one
hope this will help.
with regards
jayanta
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
