You can pass easily using 1Z0-051 dumps. We keep postings these 1Z0-051 exam questions answers on this site regularly. Some search words are 1Z0-051 braindumps, study material, past papers, real questions, practice test dumps.
splitQ101. - (Topic 1) See the Exhibit and examine the structure of the PROMOTIONS table: Exhibit: Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A. You issue the following SQL statements: Exhibit: What would be the outcome? A. It generates an error because multiple conditions cannot be specified for the WHEN
splitQ111. - (Topic 1) You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit Using the PROMOTIONS table, you need to display the names of all promos done after January 1, 2001 starting with the latest promo. Which query would give the required result? (Choose all that apply.) A. SELECT promo_name,promo_begin_date FROM promotions WHERE promo_begin_date &g
splitQ41. - (Topic 1) Which two statements are true regarding views? (Choose two.) A. A sub query that defines a view cannot include the GROUP BY clause B. A view is created with the sub query having the DISTINCT keyword can be updated C. A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table D. A
splitQ31. - (Topic 2) Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikkilineni Julia Nayer You need to display customers' second names where the second name starts with "Mc" or "MC." Which query gives the required output? A. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers W
splitQ21. - (Topic 2) Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.) A. MANAGER must be a role. B. It allows the MANAGER to pass the specified privileges on to other users. C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table. D. It allows the MANAGER to apply all DML state
splitQ11. - (Topic 1) View the Exhibit and examine the structure of the CUSTOMERS table .Which statement would display the highest credit limit available in each income level in each city in the CUSTOMERS table? A. SELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY cust_city, cust_income_level, cust_credit_limit; B. SELECT cust_city, cust_income_level, MAX(cus
splitQ1. - (Topic 1) View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cus_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600? A. INSERT INTO orders VALUES (l.'10-mar-2007\ 'direct'. (SELECT
splitQ61. - (Topic 2) Examine the structure of the ORDERS table: You want to find the total value of all the orders for each year and issue the following command: SQL>SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders GROUP BY TO_CHAR(order_date,'yyyy'); Which statement is true regarding the outcome? A. It executes successfully and gives the correct output. B
splitQ51. - (Topic 2) Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > &&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time? A. An error is returned. B. You are prompted to enter a new value. C. A report is produced that matches the first report pr
splitQ71. - (Topic 1)Â See the structure of the PROGRAMS table:Â Which two SQL statements would execute successfully? (Choose two.)Â A. SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE) FROM programs;Â B. SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE)) FROM programs;Â C. SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing') FROM programs;Â D. SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date,end_da
splitQ91. - (Topic 1) Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which DELETE statement is valid? A. DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM employees); B. DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM new_employees); C. DELETE FROM employeesWHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ‘Carreyâ€
splitQ151. - (Topic 2) View the Exhibit and examine the structure of the CUSTOMERS table. You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10, 000. Evaluate the following two queries: Which statement is true regarding the execution of the above queries? A. Only the first query gives the
splitQ161. - (Topic 1) View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the CUST_LAST_NAME column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600? A. INSERT INTO orders VALUES (1,'10-mar-2007', 'direct'
splitQ81. - (Topic 1) View the Exhibit for the structure of the STUDENT and FACULTY tables. You need to display the faculty name followed by the number of students handled by the faculty at the base location. Examine the following two SQL statements: Which statement is true regarding the outcome? A. Only statement 1 executes successfully and gives the required result. B. Only statement 2 exe
splitQ141. - (Topic 2) The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use? A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_' ESCAPE '\' B. SELECT employee_id, last_name, job_
splitQ131. - (Topic 1) Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of theDEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of th
splitQ121. - (Topic 1) Which two statements are true regarding constraints? (Choose two.) A. A constraint can be disabled even if the constraint column contains data B. A constraint is enforced only for the INSERT operation on a table C. A foreign key cannot contain NULL values D. All constraints can be defined at the column level as well as the table level E. A columns with the UNIQUE cons