Free Oracle 1Z1-047 Exam Dumps Questions & Answers

Evaluate the following statements:
CREATE TABLE digits
(id NUMBER(2),
description VARCHAR2(15));
INSERT INTO digits VALUES (1,'ONE');
UPDATE digits SET description =TWO'WHERE id=1;
INSERT INTO digits VALUES (2.'TWO ');
COMMIT;
DELETE FROM digits;
SELECT description FROM digits
VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE;
What would be the outcome of the above query?

• A.It would not display any values.
• B.It would display the values ONE, TWO, and TWO.
• C.It would display the value TWO once.
• D.It would display the value TWO twice.

View the Exhibit and examine the descriptions of the DEPT and LOCATIONS tables. You want to update the CITY column of the DEPT table for all the rows with the corresponding
value in the CITY column of the LOCATIONS table for each department. Which SOL statement would you execute to accomplish the task?

• A.UPDATE deptd
  SET city = (SELECT city
  FROM locations I)
  WHERE d.location_id = l.location_id;
• B.UPDATE deptd
  SET city = ANY (SELECT city FROM locations I);
• C.UPDATE deptd
  SET city = (SELECT city
  FROM locations I
  WHERE d.location_id = l.location_id);
• D.UPDATE deptd
  SET city = ALL (SELECT city
  FROM locations I
  WHERE d.location_id = l.location_id);

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 remove an entire branch from the output of the hierarchical query.
• C.It is possible to retrieve data in top-down or bottom-up hierarchy.
• D.It is possible to retrieve data only in top-down hierarchy.

View the Exhibit and examine the data in the CUST_DET table.
You executed the following multitable INSERT statement:
INSERT FIRST
WHEN credit_limit >= 5000 THEN
INTO cust_1 VALUES(cust_id, credit_limit, grade, gender)
WHEN grade = THE
INTO cust_2 VALUES(cust_id, credit_limit, grade, gender)
WHEN gender = THE
INTO cust_3 VALUES(cust_id, credit_limit, grade, gender)
INTO cust_4 VALUES(cust_id, credit_limit, grade, gender)
ELSE
INTO cust_5 VALUES(cust_id, credit_limit, grade, gender)
SELECT * FROM cust_det;
The row will be inserted in________.

• A.CUST 1, CUST 2 and CUST 4 tables because CREDIT LIMIT and GRADE conditions are satisfied for CUST 1 and CUST 2, and CUST 4 has no condition on it
• B.CUST_1 ,CUST_2 and CUST_5 tables because CREDIT_LIMIT and GRADE conditions are satisfied but GENDER condition is not satisfied
• C.CUST_1 table only because CREDIT_LIMIT condition is satisfied
• D.CUST_1 and CUST_2 tables because CREDIT_LIMIT and GRADE conditions are satisfied

Given below is the list of meta character syntaxes and their descriptions in random order: Meta character syntax Description 1)^ a) Matches character not in the list 2) [^...] b) Matches character when it occurs at the beginning of a line 3) | c) Treats the subsequent meta character as a literal 4) \ d) Matches one of the characters such as the OR operator
Identify the option that correctly matches the meta character syntaxes with their descriptions.

• A.1-b, 2-a, 3-d, 4-c
• B.1-d, 2-b, 3-a, 4-c
• C.1-a, 2-b, 3-d, 4-c
• D.1-b, 2-c, 3-d, 2-a