prepsimulation.com

Oracle 1Z0-051 Oracle Database: SQL Fundamentals I

2020 Oracle Official New Released 1Z0-051 Q&As
100% Free Download! 100% Pass Guaranteed!
https://www.certleader.com/1Z0-051-dumps.html

certleader.com


[New Version Jan 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q61-Q72]

Q1. - (Topic 1) Examine the structure of the EMPLOYEES table: You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: Which INSERT statement meets the above requirements? A. INSERT


[New Version Jan 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q49-Q60]

Q1. - (Topic 1) The PRODUCTS table has the following structure: Evaluate the following two SQL statements: Which statement is true regarding the outcome? A. Both the statements execute and give the same result B. Both the statements execute and give different results C. Only the second SQL statement executes successfully D. Only the first SQL statement executes successfully View AnswerAns


[New Version Jan 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q37-Q48]

Q1. - (Topic 1) See the Exhibit and examine the structure and data in the INVOICE table: Exhibit: Which two SQL statements would execute successfully? (Choose two.) A. SELECT MAX(inv_date),MIN(cust_id) FROM invoice; B. SELECT AVG(inv_date-SYSDATE),AVG(inv_amt) FROM invoice; C. SELECT MAX(AVG(SYSDATE-inv_date)) FROM invoice; D. SELECT AVG(inv_date) FROM invoice; View AnswerAnswer: A,B Q2.


[New Version Dec 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q25-Q36]

Q1. - (Topic 1) View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query? A. It executes successfully. B. It returns an error because the BETWEEN operator cannot be used in the HAVING clause. C. It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT


[New Version Dec 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q13-Q24]

Q1. - (Topic 2) Examine the following SQL commands: Which statement is true regarding the execution of the above SQL commands? A. Both commands execute successfully. B. The first CREATE TABLE command generates an error because the NULL constraint is not valid. C. The second CREATE TABLE command generates an error because the CHECK constraint is not valid. D. The first CREATE TABLE command g


[New Version Oct 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q1-Q12]

Q1. - (Topic 2) View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr. You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000. Which SQL statement would you use? A. SELECT promo_name, promo_cost, promo_begin_date FROM promot


[New Version Oct 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q169-Q175]

Q1. - (Topic 2) View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'. You issue the following query: SQL> SELECT LOWER(REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM CUSTOMERS WHERE LOWER(cust_last_name) LIKE 'a%n' What woul


[New Version Aug 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q157-Q168]

Q1. - (Topic 1) Examine the structure and data of the CUSTJTRANS table: CUSTJRANS Name Null? Type CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) CUSTNO TRANSDATE TRANSAMT 11 01-JAN-07 1000 22 01-FEB-07 2000 33 01-MAR-07 3000 Dates are stored in the default date format dd-mon-rr in the CUSTJTRANS table. Which three SQL statements would execute successfully? (Choose three.) A.


[New Version Aug 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q145-Q156]

Q1. - (Topic 2) Examine the structure and data in the PRICE_LIST table: Name Null Type PROD_ID NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PROD_PRICE 100 $234.55 101 $6,509.75 102 $1,234 You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE. Which SQL statement would give the required result? A. SELECT TO


[New Version Aug 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q133-Q144]

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


[New Version Jul 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q121-Q132]

Q1. - (Topic 2) View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables. You want to update the EMPLOYEES table as follows:4 ? 4; -Update only those employees who work in Boston or Seattle (locations 2900 and 2700). -Set department_id for these employees to the department_id corresponding to London  (location_id 2100). -Set the employees' salary in location_


[New Version Jul 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q109-Q120]

Q1. - (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. It g


[New Version Jun 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q97-Q108]

Q1. - (Topic 1) Here is the structure and data of the CUST_TRANS table: Exhibit: Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table. Which three SQL statements would execute successfully? (Choose three.) A. SELECT transdate + '10' FROM cust_trans; B. SELECT * FROM cust_trans WHERE transdate = '01-01-07' C. SELECT transamt FROM cust_trans WHERE custn


[New Version Jun 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q85-Q96]

Q1. - (Topic 1) Which is the valid CREATE [TABLE statement? A. CREATE TABLE emp9$# (emp_no NUMBER(4)); B. CREATE TABLE 9emp$# (emp_no NUMBER(4)); C. CREATE TABLE emp*123 (emp_no NUMBER(4)); D. CREATE TABLE emp9$# (emp_no NUMBER(4). date DATE); View AnswerAnswer: A Explanation: Schema Object Naming Rules Every database object has a name. In a SQL statement, you represent the name of an 


[New Version Jun 2021] Certleader Oracle 1Z0-051 Exam Dumps[Q73-Q84]

Q1. - (Topic 1) See the Exhibit and examine the structure of the CUSTOMERS table: Using the CUSTOMERS table, you need to generate a report that shown the average credit limit for customers in WASHINGTON and NEW YORK. Which SQL statement would produce the required result? A. SELECT cust_city, AVG(cust_credit_limit) FROM customers WHERE cust_city IN ('WASHINGTON','NEW YORK')