Home » Other » Training & Certification » some questions in 1z0-07 ????
some questions in 1z0-07 ???? [message #218347] Wed, 07 February 2007 16:43 Go to next message
m_arafa
Messages: 36
Registered: June 2006
Member
hi all,

there are plenty of questions , please respond to me i'm urgent i'm sorry :-

1-
Which data dictionary table should you query to view the object privileges granted to the user on specific
columns?
A. USER_TAB_PRIVS_MADE
B. USER_TAB_PRIVS
C. USER_COL_PRIVS_MADE
D. USER_COL_PRIVS

2-
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 is the Oracle proprietary interface for executing SQL statements.

3-
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 satement 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 definition in the database; /SQL* Plus does not allow manipulation of
values in the database.

4-
Which are /SQL*Plus commands? (Choose all that apply.)
A. INSERT
B. UPDATE
C. SELECT
D. DESCRIBE
E. DELETE
F. RENAME

5-
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
Which INSERT statement is valid?
A. INSERT INTO employees (employee_id, first_name, last_name, hire_date)
VALUES (1000, 'John', 'smith','01/01/01);
B. INSERT INTO employees(employee_id, first_name, last_name, hire_date)
VALUES (1000, 'John', 'smith','01 january 01');
C. INSERT INTO employees(employee_id, first_name, last_name, Hire_date)
VALUES (1000, 'John', 'smith', To_ date ('01/01/01));
D. INSERT INTO employees(employee_id, first_name, last_name, hire_date)
VALUES (1000, 'John', 'smith','01-Jan-01');

thanx in advance,
Re: some questions in 1z0-07 ???? [message #218415 is a reply to message #218347] Thu, 08 February 2007 02:22 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
If you preparing for IZO-007 exam then you must solve above question yourself.
if you have any question then take help of documentation.

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm


regards
Taj
Re: some questions in 1z0-07 ???? [message #549473 is a reply to message #218347] Fri, 30 March 2012 15:59 Go to previous messageGo to next message
techiguys
Messages: 1
Registered: March 2012
Junior Member
Q.1: ???
Q.2: B,E
Q.3: A
Q.4: D
Q.5: D
Re: some questions in 1z0-07 ???? [message #549491 is a reply to message #549473] Sat, 31 March 2012 02:28 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If these were you lucky guesses, good news for you! Some of your answers are (at least) partially correct.
Previous Topic: PATHWAY FOR MS SQL SERVER
Next Topic: Best PL/SQl Online Training in USA | BLUECUBEIT
Goto Forum:
  


Current Time: Thu Mar 28 14:39:06 CDT 2024