Home » Other » Training & Certification » 1Z0-007 questions (merged)
1Z0-007 questions (merged) [message #219742] Thu, 15 February 2007 16:43 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member
Have few question where I & my oracle tutor are not 100% sure about answer.

I have mark my answer in bold where I am very much doubtfull have put ? after option.

Would like to thank you in advance.

Q1)
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

I feel C D F But only 2 need to be selected.

[ Option C as date department_name retirve without being part of FROM clause of main query

SELECT last_name,(SELECT department_name FROM department D WHERE D.department_id = E.department_id)
FROM employees E ]

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

Q2)Mark item for review
For which two actions can you use the TO_DATE function? (Choose two.)


A.convert any date literal to a date

B.convert any numeric literal to a date

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 belive A D ]

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


Q3)In which scenario would an index be most useful?


A.The indexed column is declared as NOT NULL.

B.The indexed columns are used in the FROM clause.

C.The indexed columns are part of an expression.

D.The indexed column contains a wide range of values.

Answer is D , but C also can be answer right ?

-------------------------------------------------------------
Q4)
Mark item for review
In which three cases would you use the USING clause? (Choose three.)


A.You want to create a nonequijoin.

B.The tables to be joined have multiple NULL columns.

C.The tables to be joined have columns of the same name and different data types.

D.The tables to be joined have columns with the same name and compatible data types.

E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

[ require to select 3 option....D [ C ? E ?]............ ]
--------------------------------------------------------------
Q5) In which two cases would you use an outer join? (Choose two.)
Click HERE to vote for your answer!

A. The tables being joined have NOT NULL columns.
B. The tables being joined have only matched data.
C. The columns being joined have NULL values.
D. The tables being joined have only unmatched data.
E. The tables being joined have both matched and unmatched data.
F. Only when the tables have a primary key/foreign key relationship

[ E [C?] ]

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

Q6)what is true about single row function?
A. cannot be nested
B. manipulate data items
C. act on each row returned
D. return one result per row
E. accept only one argument and return only one value
F. accept arguments which can be a column or an expression

BCDF

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

Q7) 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 statement.
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
--------------------------------------------------

Q8)Which three is true regarding the use of outer joins? (Choose three.)

A. You cannot use IN operator in a condition that involves an outer join.
B. You use (+) on both sides of the WHERE condition to perform an outer join.
C. You use (*) on both sides of the WHERE condition to perform an outer join.
D. You use an outer join to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outer join.
F. You cannot link a condition that is involved in an outer join to another condition by using the OR operator.

A E F
-------------------------------------------------------

Q9)
For which two actions can you use the TO_DATE function? (Choose two.)


A.convert any date literal to a date

B.convert any numeric literal to a date

C.convert any date to a character literal

D.format 'January 10 1999' for input

E.format '10-JAN-99' to 'January 10 1999'

D F




Which is correct option [message #219748 is a reply to message #219742] Thu, 15 February 2007 17:13 Go to previous messageGo to next message
IT Guru
Messages: 59
Registered: January 2007
Member
I have attach .pdf file, in that I have following question.

My answers are mark with bold format.


QUESTION 147 B C E

QUESTION 168 B ?

QUESTION 173 A C [q. ask to select only one where I find 2 answer are correct, word AS should not be there in option other wise none answer is correct]

QUESTION 182 C is for proceduer rest are for table so which one consider as system one


QUESTION 190 B D [only one need to be select]

QUESTION 191 C D


THANK YOU FOR YOUR VALUABLE TIME GIVEN

QUESTION 203 A D F ( E ? )

[Updated on: Fri, 30 March 2007 06:13] by Moderator

Report message to a moderator

Re: 1Z0-007 questions (merged) [message #327133 is a reply to message #219742] Sat, 14 June 2008 02:58 Go to previous messageGo to next message
ruchika19840
Messages: 7
Registered: June 2008
Junior Member
Hey IT Guru

How will i access that attachment files?

Appreciate your help.


Ruchi
Re: 1Z0-007 questions (merged) [message #327138 is a reply to message #327133] Sat, 14 June 2008 03:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no attched file and you should read OraFAQ Forum Guide what is said about braindumps.

Regards
Michel
Re: 1Z0-007 questions (merged) [message #338075 is a reply to message #219742] Sun, 03 August 2008 02:12 Go to previous messageGo to next message
taskeen21
Messages: 1
Registered: August 2008
Junior Member
hi,

this is syed. i am planning to take the 007 exam on september 2nd. could you please email me the STS and other material (new and/or old) you have for this exam?

email ids : [removed]

thanks in advance.

[Edit MC: remove email - read answer at http://www.orafaq.com/forum/m/333598/102589/?srch=mail#msg_333598]

[Updated on: Sun, 03 August 2008 03:34] by Moderator

Report message to a moderator

Re: 1Z0-007 questions (merged) [message #538639 is a reply to message #338075] Sat, 07 January 2012 18:01 Go to previous messageGo to next message
tsantony
Messages: 1
Registered: January 2012
Location: SINGAPORE
Junior Member

hi everyone
I'm new to this forum. i'm planning to write my 1z0-007 exam by 9/01/2012. i saw your FAQs are really very useful. please help me to answer my question in future.

thanks in advance.
Antony
Re: 1Z0-007 questions (merged) [message #538647 is a reply to message #538639] Sun, 08 January 2012 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No problem if you show you made some effort to find the answer by yourself in giving your opinion and on what it is based (references to documentation).

Regards
Michel
Re: 1Z0-007 questions (merged) [message #541377 is a reply to message #538647] Tue, 31 January 2012 00:51 Go to previous message
babar82
Messages: 108
Registered: March 2009
Location: Karachi
Senior Member
Is the course outline for Oracle 1z0-007 revised. Topics for User Administration are not included?
Previous Topic: Oracle 10g OCA
Next Topic: technical consultants(apps developers)
Goto Forum:
  


Current Time: Thu Mar 28 08:49:09 CDT 2024