Oracle Oracle Database 12c SQL Fundamentals 1z0-061题库.pdfVIP

s@lm@n Oracle Exam 1z0-061 Oracle Database 12c: SQL Fundamentals Version: 6.1 [ Total Questions: 75 ] 买题库 QQ:860424807 Oracle 1z0-061 : Practice Test Question No : 1 Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query? A. It executes successfully and displays rows in the descending order of PROMO_CATEGORY. B. It produces an error because positional notation cannot be used in the order by clause with set operators. C. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement. D. It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement. Answer: D Question No : 2 View the Exhibit and examine the structure of the product, component, and PDT_COMP tables. In product table, PDTNO is the primary key. In component table, COMPNO is the primary key. In PDT_COMP table, PDTNO, COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in product table and COMPNO is the foreign key referencing the COMPNO in component table. 2 买题库 QQ:860424807 Oracle 1z0-061 : Practice Test You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist. Evaluate the following query: SQLSELECT pdtno, pdtname, compno, compname FROM product _____________ pdt_comp USING (pdtno) ____________ component USING (compno) WHERE compname IS NOT NULL; Which combination of joins used in the blanks in the above query gives the correct output? A. JOIN; JOIN B. FULL OUTER JOIN; F