最新的Oracle 1Z0-047免費考試真題

問題1

Evaluate the SQL statements:
CREATE TABLE new_order
(orderno NUMBER(4),
booking_date TIMESTAMP WITH LOCAL TIME ZONE);
The database is located in San Francisco where the time zone is -8:00.
The user is located in New York where the time zone is -5:00.
A New York user inserts the following record:
INSERT INTO new_order
VALUES(1, TIMESTAMP 007-05-10 6:00:00 -5:00");
Which statement is true?

A. When the San Francisco user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000 -8:00'

B. When the New York user selects the row, booking_date is displayed as 2007-05-10 6.00.00.000000 -5:00'.

C. When the New York user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000'

D. When the San Francisco user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000'

正確答案: D

問題2

Which statements are true regarding the hierarchical query in Oracle Database 10g? (Choose all that apply.

A. You cannot specify conditions when you retrieve data by using a hierarchical query.

B. It is possible to retrieve data only in top-down hierarchy.

C. It is possible to retrieve data in top-down or bottom-up hierarchy.

D. It is possible to remove an entire branch from the output of the hierarchical query.

正確答案: C,D

問題3

EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?

A. CREATE VIEW empvu AS
SELECT* FROM empdept;

B. CREATE INDEX empdet_dx
ON empdet(empno);

C. UPDATE empdet
SET ename = 'Amit'
WHERE empno = 1234;

D. DELETE FROM empdet
WHERE ename LIKE 'J%';

正確答案: A

問題4

View the Exhibit and examine the structure of the EMP table.
You executed the following command to add a primary key to the EMP table:
ALTER TABLE emp
ADD CONSTRAINT emp_id_pk PRIMARY KEY (emp_id)
USING INDEX emp_id_idx;
Which statement is true regarding the effect of the command?

A. The PRIMARY KEY would be created in a disabled state because it is using an existing index.

B. The PRIMARY KEY is created along with a new index.

C. The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.

D. The PRIMARY KEY is created and it would use an existing unique index.

正確答案: D

問題5

View the Exhibit and examine the description of the PRODUCT_INFORMATION table.
You want to display the expiration date of the warranty for a product. Which SQL statement would you execute?

A. SELECT product_id, TO_YMINTERVAL(SYSDATE) + warranty_period
FROM product_information;

B. SELECT product_jd, TO_YMINTERVAL(SYSDATE + warranty_period)
FROM product_information;

C. SELECT product_id, SYSDATE + warranty_period
FROM product_information;

D. SELECT product_jd, TO_YMINTERVAL(warranty_period)
FROM product_information;

正確答案: C

問題6

Which three statements are true regarding single-row functions? (Choose three.)

A. They can modify the data type of the argument that is referenced.

B. They can be nested up to only two levels.

C. They can accept only one argument.

D. They can be used in SELECT, WHERE, and ORDER BY clauses.

E. They can accept a column name, expression, variable name, or a user-supplied constant as arguments.

F. They can return multiple values of more than one data type.

正確答案: A,D,E

問題7

Which two statements are true regarding subqueries? (Choose three.)

A. Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.

B. A subquery can be used in the FROM clause of a SELECT statement.

C. If the subquery returns NULL, the main query may still return result rows.

D. The ORDER BY clause can be used in the subquery.

E. A subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause.

正確答案: B,C,D

問題8

Given below is a list of datetime data types and examples of values stored in them in a random
order:
Datatype Example
1) INTERVAL YEAR TO MONTH a) 2003-04-15 8:00:00 -8:00'
2) TIMESTAMP WITH LOCAL TIME ZONE b) '-K)6 03:30:16.000000'
3) TIMESTAMP WITH TIME ZONE c) '17-JUN-03 12.00.00.000000 AM'4)INTERVAL DAY TO
SECOND d) '402-00'
Identify the option that correctly matches the data types with the values.

A. 1-b.2-a.3-c.4-d

B. 1-d.2-c.3-b.4-a

C. 1-d.2-c.3-a.4-b

D. 1-b.2-a, 3-d, 4-c

正確答案: C

問題9

Which statement correctly differentiates a system privilege from an object privilege?

A. Users require system privileges to gain access to the database whereas they require object privileges to create objects in the database.

B. A system privilege is the right to perform specific activities in a database whereas an object privilege is a right to perform activities on a specific object in the database.

C. System privileges give the rights to only create user schemas whereas object privileges give rights to manipulate objects in a schema.

D. System privileges can be granted only by the DBA whereas object privileges can be granted by DBAs or the owner of the object.

正確答案: B

問題10

View the Exhibit and examine the data in EMP and DEPT tables.
In the DEPT table, DEPTNO is the PRIMARY KEY.
In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing
the DEPTNO column in the DEPT table.
What would be the outcome of the following statements executed in the given sequence?
DROP TABLE emp;
FLASHBACK TABLE emp TO BEFORE DROP;
INSERT INTO emp VALUES (2.COTT 10); INSERT INTO emp VALUES (3,ING 55);

A. Only the first INSERT statement would succeed because all the constraints except the primary key constraint are automatically retrieved after a table is flashed back.

B. Both the INSERT statements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.

C. Both the INSERT statements would fail because all constraints are automatically retrieved when the table is flashed back.

D. Only the second INSERT statement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.

正確答案: D

最新的Oracle Database SQL Expert - 1Z0-047免費考試真題

聯系我們

站內鏈接

最新更新