Try Oracle : 1Z1-047 valid & accurate questions and answers

View the Exhibit and examine the structure of the CUST table.
Evaluate the following SQL statements executed in the given order:
ALTER TABLE cust
ADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_id) DEFERRABLE INITIALLY DEFERRED;
INSERT INTO cust VALUES (1,'RAJ1); --row 1
INSERT INTO cust VALUES (1,'SAM); --row 2 COMMIT;
SET CONSTRAINT cust_id_pk IMMEDIATE;
INSERT INTO cust VALUES (1,'LATA '); --row 3 INSERT INTO cust VALUES (2,'KING '); --row 4 COMMIT;
Which rows would be made permanent in the CUST table?

• A. rows 2 and 4
• B. rows 3 and 4
• C. row 4 only
• D. rows 1 and 4

View the Exhibit and examine the details for the CATEGORIES_TAB table. Evaluate the following incomplete SQL statement:
SELECT category_name ,category_description FROM categories_tab You want to display only the rows that have 'harddisks' as part of the string in the CATEGORY_DESCRIPTION column.
Which two WHERE clause options can give you the desired result? (Choose two.)

• A. WHERE REGEXPJJKE (category_description, 'hard+.s');
• B. WHERE REGEXPJJKE (category_description, '^H|hard+.s$');
• C. WHERE REGEXPJJKE (category_description, '^H|hard+.s');
• D. WHERE REGEXPJJKE (category_description, '[^Hlhard+.s]');

Which three tasks can be performed using regular expression support in Oracle Database 10g? (Choose three.)

• A. it can be used to find and replace operations for a column or expression having string data.
• B. it can be used for string manipulation and searching operations.
• C. it can be used to format the output for a column or expression having string data.
• D. it can be used to concatenate two strings.
• E. it can be used to find out the total length of the string.

View the Exhibit and examine the structure of the ORDERS table.
You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed after the last order placed by the customer whose CUSTOMER_ID is 101 Which query would give you the desired output?

• A. SELECT order_id, order_date FROM orders
  WHERE order_date > ALL (SELECT MAX(order_date) FROM orders) AND
  Customer_id = 101;
• B. SELECT order_id, order_date FROM orders
  WHERE order_date > ANY (SELECT order_date
  FROM orders
  WHERE customer_id = 101);
• C. SELECT order_id, order_date FROM orders
  WHERE order_date > ALL (SELECT order_date
  FROM orders
  WHERE customer_id = 101);
• D. SELECT order_id, order_date FROM orders
  WHERE order_date IN (SELECT order_date FROM orders
  WHERE customer id = 101);

Which two statements are true regarding roles? (Choose two.)

• A. The REVOKE command can be used to remove privileges but not roles from other users.
• B. A user can be granted only one role at any point of time.
• C. A role can be granted to PUBLIC.
• D. A role can be granted to itself.
• E. Roles are named groups of related privileges that can be granted to users or other roles.