You can pass easily using 1z0-047 dumps. We keep postings these 1z0-047 exam questions answers on this site regularly. Some search words are 1z0-047 braindumps, study material, past papers, real questions, practice test dumps.
splitQ31. Evaluate the following SELECT statement and view the Exhibit to examine its output: SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status FROM user_constraints WHERE table_name = ORDERS Which two statements are true about the output? (Choose two.) A. Inthe secondcolumn, indicates a check constraint. B. TheSTATUS columnindicateswhether the
splitQ71. View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. Evaluate the following MERGE statement: MERGE INTO orders_master o USING monthly_orders m ON (o.order_id = m.order_id) WHEN MATCHED THEN UPDATE SET o.order_total = m.order_total DELETE WHERE (m.order_total IS NULL) WHEN NOT MATCHED THEN INSERT VALUES (m.order_id, m.order_total); What would be the
splitQ41. View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. You want to see the product names and the date of expiration of warranty for all the products, if the product is purchased today. The products that have no warranty should be displayed at the top and the products with maximum warranty period should be displayed at the bottom. Which SQL statement would you exe
splitQ131. View the Exhibit and examine the details of the PRODUCT_INFORMATION table. You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement: SELECT product_name, list_price FROM product_information WHERE (category_id = 12 AND categ
splitQ141. View the Exhibit and examine the description of the EMPLOYEES table. Your company decided to give a monthly bonus of $50 to all the employees who have completed five years in the company. The following statement is written to display the LAST_NAME, DEPARTMENT_ID, and the total annual salary: SELECT last_name, departmentjd, salary450*12 "Annual Compensation" FROM employees WHERE MONTH
splitQ1. View the Exhibit and examine the structure of the ORDERS table. NEW_IDRDERS is a new table with the columns ORD_ID, ORD_DATE, CUST_ID, and ORD_TOTAL that have the same data types and size as the corresponding columns in the ORDERS table. Evaluate the following INSERT statement: INSERT INTO new_orders (ord_id, ord_date, cust_id, ord_total) VALUES(SELECT order_id.order_date.customer_id.
splitQ11. 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
splitQ21. EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table? A. UPDATE empdet SET ename ='Amit' WHERE empno = 1234; B. DELETE FROM empdet WHERE ename LIKE 'J%' C. CREATE VIEWempvu AS SELECT* FROMempdept; D. CREATEINDEX empdet_dx ON empdet(empno); Answer: CQ22. View the Exhibit and examine the descript
splitQ51. Which statement is true regarding external tables? A. The default REJECT LIMIT for external tables is UNLIMITED. B. The data and metadata for an external table are stored outside the database. C. ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table. D. The CREATE TABLE AS SELECT statement can be used to unload data into regular table
splitQ61. In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause? A. to find the groups forming the subtotal in a row B. to create group-wise grand totals for the groups specified within a GROUP BY clause C. to create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the
splitQ91. View the Exhibit and examine the data in the DEPARTMENTS tables. Evaluate the following SQL statement: SELECT department_id "DEPT_ID", department_name , 'b' FROM departments WHERE department_id=90 UNION SELECT department_id, department_name DEPT_NAME, 'a' FROM departments WHERE department_id=10 Which two ORDER BY clauses can be used to sort the output of the above sta
splitQ111. View the Exhibit and examine the ORDERS table. The ORDERS table contains data and all orders have been assigned a customer ID. Which statement would add a NOT NULL constraint to the CUSTOMER_ID column? A. ALTER TABLE orders ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id); B. ALTER TABLE orders MODIFY customer_id CONSTRAINT orders_cust_id_nn NOT NULL; C. ALTER TABLE orders
splitQ151. Evaluate the following SQL statement: SELECT product_name || 'it's not available for order' FROM product_information WHERE product_status = 'obsolete' You received the following error while executing the above query: ERROR: ORA-01756: quoted string not properly terminated What would you do to execute the query successfully? A. Enclose the character literal s
splitQ101. Which three tasks can be performed using regular expression support in Oracle Database 10g? (Choose three.) A. it can be used to concatenate two strings. B. it can be used to find out the total length of the string. C. it can be used for string manipulation and searching operations. D. it can be used to format the output for a column or expression having string data. E. it can be
splitQ81. Which two statements are true regarding roles? (Choose two.) A. A role can be granted to itself. B. A role can be granted to PUBLIC. C. A user can be granted only one role at any point of time. D. The REVOKE command can be used to remove privileges but not roles from other users. E. Roles are named groups of related privileges that can be granted to users or other roles. Answer: B
splitQ121. View the Exhibit and examine the structure of ORD and ORD_ITEMS tables. In the ORD table, the PRIMARY KEY is ORD_NO and in the ORD_ITEMS tables the composite PRIMARY KEY is (ORD_NO, ITEM_NO). Which two CREATE INDEX statements are valid? (Choose two.) A. CREATE INDEX ord_idx ON ord(ord_no); B. CREATE INDEX ord_idx ON ord_items(ord_no); C. CREATE INDEX ord_idx ON ord_items(item_n