| some questions in 1z0-07 ???? [message #218347] |
Wed, 07 February 2007 16:43  |
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,
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
