Topic: Database Administration >> reply
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| aliai |
Posted: May 04, 2008 04:52:51 PM |
Total Post: 17
Joined: Apr, 2008
|
Q1)which three statements about subqueries are true?
A)a single row sbuquery can retrieve only one column and one row
B)a single row sbuquery 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 by using the ">" operator
e)a single row subquery can use the IN operator
f)a multiple row subquery can use the "=" operator
Q2) which statements correctly describes SQL and /SQL*Plus?
A.both SQL and /SQL*plus allow manipulation of values in the database
B./SQL*plus recognizes SQL statement and sends them to the server,SQL is the oracle proprietary interface for executing SQL statements
C./SQL*plus 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
Q3)Which are /sql*plus commands?(choose all that apply)
A.INSERT
B.UPDATE
C.SELECT
D.DESCRIBE
E.DELTE
F.RENAME
Q4)Which two are attributes of /SQL*plus? (choose two)
A./SQL*PLUS commands cannot be abbreviated
B./SQL*PLUS commands are accesses from a browser
C./SQL*PLUS commands are used to manipulate data in tables
D./SQL*PLUS commands manipulate table definitions in the database
E./SQL*PLUS commands is the oracle proprietary interface for executing SQL statements.
Q5)FOR which two actions can you use the TO_DATE functions
A.convert any data literal to date
b.convert any date to a character literal
c.convert any date to a character literal
d.format 'January 10 1999' for input
e.format '10-jan-99' to 'January 10 1999'
i have gone through with the course material but the options are so close
i have doubt plz give ur answer that might clear my doubt or if you can not answer tellme whether my answers are correct or not plzz.
Q1) b,c,d
Q2)b
Q3)a,b,c,d,e
Q4)b,e
Q5)b,e
|
|
|
 Mohammed Taj |
| Posted: May 05, 2008 02:23:29 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Find all answer : http://tahiti.oracle.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 387 |
| Vinoth Kumar | 379 |
| Gopu Gopi | 350 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
