最新の1Z0-007問題集で試験を準備する

Oracle 1Z0-007 試験概要:

Oracle 1Z0-007 試験シラバストピック:

Oracle Introduction to Oracle9i: SQL 認定 1Z0-007 試験問題：

問題 #1

In which scenario would index be most useful?

A. The indexed column contains a wide range of values.
B. The indexed columns are used in the FROM clause.
C. The indexed columns are part of an expression.
D. The indexed column is declared as NOT NULL.

問題 #2

Which are /SQL*Plus commands? (Choose all that apply.)

A. DELETE
B. UPDATE
C. SELECT
D. DESCRIBE
E. RENAME
F. INSERT

問題 #3

Which SELECT statement will the result 'ello world' from the string 'Hello World'?

A. SELECT LOWER(SUBSTR('Hello World', 1, 1) FROM dual;
B. SELECT SUBSTR( 'Hello World',1) FROM dual;
C. SELECT INITCAP(TRIM ('Hello World', 1,1)) FROM dual;
D. SELECT LOWER(TRIM ('H' FROM 'Hello World')) FROM dual;
E. SELECT LOWER(SUBSTR('Hello World', 2, 1) FROM dual;

問題 #4

Which three statements about subqueries are true? (Choose three.)

A. The subquery and main query can retrieve data from different tables.
B. A main query can have more than one subquery.
C. Only one column or expression can be compared between the subquery and main query.
D. The subquery and main query must retrieve data from the same table.
E. A subquery can have more than one main query.
F. Multiple columns or expression can be compared between the subquery and main query.

問題 #5

Examine the statement:
Create synonym emp for hr.employees;
What happens when you issue the statement?

A. An error is generated.
B. You create a table called employees in the HR schema based on you EMP table.
C. You will have two identical tables in the HR schema with different names.
D. You create an alternative name for the employees table in the HR schema in your own schema.

解説：