Get real exam questions for 1Z0-051 Oracle Database: SQL Fundamentals I. 100% Free.
Q1. - (Topic 1) View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format: CATEGORIES 5MP Digital Photo Camera's category is Photo Y Box's category is Electronics Envoy Ambassador's category is Hardware Which two queries would give the required output? (Choose two.) A. SELECT prod_name || q'''s category is
Q1. - (Topic 1) Which two statements are true regarding single row functions? (Choose two.) A. They can be nested only to two levels B. They always return a single result row for every row of a queried table C. Arguments can only be column values or constant D. They can return a data type value different from the one that is referenced E. They accept only a single argument View AnswerAnswe
Q1. - (Topic 1) The following data exists in the PRODUCTS table: PROD_ID PROD_LIST_PRICE 123456 152525.99 You issue the following query: SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*') FROM products WHERE prod_id = 123456; What would be the outcome? A. 152526**** B. **152525.99 C. 152525** D. an error message View AnswerAnswer: A Explanation: The LPAD(string, length
Q1. - (Topic 1) Evaluate the following SQL statement: SQL> SELECT cust_id. cust_last_name FROM customers WHERE cust_credit_limit IN (select cust_credit_limit FROM customers WHERE cust_city='Singapore'): Which statement is true regarding the above query if one of the values generated by the sub query is NULL? A. It produces an error. B. It executes but returns no rows. C. It gener
Q1. - (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 > '
Q1. - (Topic 2) Which is an iSQL*Plus command? A. INSERT B. UPDATE C. SELECT D. DESCRIBE E. DELETE F. RENAME View AnswerAnswer: D Explanation: Explanation: The only SQL*Plus command in this list : DESCRIBE. It cannot be used as SQL command. This command returns a description of table name, including all columns in that table, the datatype for each column and an indication of whether the
Q1. - (Topic 1) View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.) A. CREATE VIEW v3 AS SELECT * FROM SALES WHERE cust_id = 2034 WITH CHECK OPTION; B. CREATE VIEW v1 AS SELECT * FROM SALES WHERE time_id <= SYSDATE - 2*365 WITH CHECK OPTION; C. CREATE VIEW v2 AS SELECT prod_id, cust_id, time_id F
Q1. - (Topic 1) You need to display the date ll-oct-2007 in words as "Eleventh of October, Two Thousand Seven'. Which SQL statement would give the required result? A. SELECT TO_CHAR('ll-oct-2007'. 'miDdspth "of Month. Year') FROM DUAL: B. SELECT TO_CHAR(TO_DATE('ll-oct-2007'X 'miDdspth of month, year') FROM DUAL; C. SELECT TO_CHAR(TO_DATE('ll-oct-2007&#
Q1. - (Topic 2) View the Exhibit and examine the structure and data in the INVOICE table. Which statements are true regarding data type conversion in expressions used in queries? (Choose all that apply.) A. inv_amt ='0255982' : requires explicit conversion B. inv_date > '01-02-2008' : uses implicit conversion C. CONCAT(inv_amt,inv_date) : requires explicit conversion D. i
Q1. - (Topic 2) Which two statements are true regarding indexes? (Choose two.) A. They can be created on tables and clusters. B. They can be created on tables and simple views. C. You can create only one index by using the same columns. D. You can create more than one index by using the same columns if you specify distinctly different combinations of the columns. View AnswerAnswer: A,D Q2
Q1. - (Topic 2) View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks would require subqueries? (Choose two.) A. Display the minimum list price for each product status. B. Display all suppliers whose list price is less than 1000. C. Display the number of products whose list price is more than the average list price. D. Display the total number of products supplie
Q1. - (Topic 1) View the Exhibit and examine the structure of the CUSTOMERS table. Exhibit: you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country as customers with the last name 'king' and whose credit limit is less than the maximum credit limit in countries that have customers with the last name 'king'. Which statemen
Q1. - (Topic 1) View the Exhibit and examine the description for the PRODUCTS and SALES table. PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table. You want to remove all the rows from the PRODUCTS table for which no sale was done for the last three years. Which is the valid DELETE statement? A. DELETE FROM products WHERE prod_id = (SELECT prod_id FROM sales WHER
Q1. - (Topic 1) Which is an iSQL*Plus command? A. INSERT B. UPDATE C. SELECT D. DESCRIBE E. DELETE F. RENAME View AnswerAnswer: D Explanation: Explanation: The only SQL*Plus command in this list: DESCRIBE. It cannot be used as SQL command. This command returns a description of tablename, including all columns in that table, the datatype for each column and an indication of whether th
Q1. - (Topic 1) Which two statements are true about constraints? (Choose two.) A. The UNIQUE constraint does not permit a null value for the column. B. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. C. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. D. The NOT NULL constraint ensures that null values are not permitted for the column. View
Q1. - (Topic 2) Which four are valid Oracle constraint types? (Choose four.) A. CASCADE B. UNIQUE C. NONUNIQUE D. CHECK E. PRIMARY KEY F. CONSTANT G. NOT NULL View AnswerAnswer: B,D,E,G Explanation: Oracle constraint type is Not Null, Check, Primary Key, Foreign Key and Unique Incorrect Answer: AIs not Oracle constraint CIs not Oracle constraint FIs not Oracle constraint Refer: Introd
Q1. - (Topic 2) Examine the structure of the EMP_DEPT_VU view: Which SQL statement produces an error? A. SELECT * FROM emp_dept_vu; B. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department_id; C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department_id, job_id; D. SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GRO
Q1. - (Topic 2) You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase . Which statement would accomplish this requirement? A. S
Q1. - (Topic 2) Which two statements about creating constraints are true? (Choose two) A. Constraint names must start with SYS_C. B. All constraints must be defines at the column level. C. Constraints can be created after the table is created. D. Constraints can be created at the same time the table is created. E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary vie
Q1. - (Topic 2) View the Exhibit; e xamine the structure of the PROMOTIONS table. Each promotion has a duration of at least seven days. Your manager has asked you to generate a report, which provides the weekly cost for each promotion done to l date. Which query would achieve the required result? A. SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM promotions; B. SELECT p