1Z0-061 Exam Questions

Examine the description of the CUSTOMERS table: The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the...

What does the FORCE option for creating a view do?

A data manipulation language statement _____.

Evaluate the SQL statement: SELECT LPAD (salary, 10, '*') FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?

The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?

Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.)

Which best describes an inline view?

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: You want to create a report displaying employee last names, department names, and locations. Which query should you u...

The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8, 2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product_...

In which two cases would you use an outer join? (Choose two.)

Which SQL statements would display the value 1890.55 as $1, 890.55? (Choose three.)

Examine the structure of the SHIPMENTS table: You want to generate a report that displays the PO_ID and the penalty amount to be paid if the SHIPMENT_DATE is later than one month f...

View the Exhibit and examine the structure of the CUSTOMERS table. Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

View the Exhibit; examine 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 provid...

View the Exhibit and examine the data in the EMPLOYEES table. You want to generate a report showing the total compensation paid to each employee to date. You issue the following qu...

Examine the structure of the PROMOTIONS table: The management wants to see a report of unique promotion costs in each promotion category. Which query would achieve the required res...

Evaluate the following query: SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual; What is the correct output of the ab...

Examine the structure proposed for the TRANSACTIONS table: Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

Which two statements are true regarding tables? (Choose two.)

Which two statements are true regarding constraints? (Choose two.)

View the Exhibit and examine the structure of the PRODUCTS, SALES, and SALE_SUMMARY tables. SALE_VW is a view created using the following command: SQL>CREATE VIEW sale_vw AS SELECT...

Examine the following SQL commands: Which statement is true regarding the execution of the above SQL commands?

Which two statements are true regarding views? (Choose two.)

Which three statements are true regarding views? (Choose three.)

Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The SEQ1 sequence has generated numbers up to the...

Which two statements are true regarding indexes? (Choose two.)

SLS is a private synonym for the SH.SALES table. The user SH issues the following command: DROP SYNONYM sls; Which statement is true regarding the above SQL statement?

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...

View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query: Which statement is true regarding the above query?

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 wi...

View the Exhibit and examine the structure of the PRODUCTS table. You want to display only those product names with their list prices where the list price is at least double the mi...

View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table. Evaluate the following two queries: SQL>SELECT DISTINCT promo_category t...

Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.)

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 foll...

Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME --------------------- Lex De Haan Renske Ladwig Jose Manuel Urman Jason Mallin You want to extract only t...

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...

Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all that apply.)

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 ------...

Examine the structure of the TRANSACTIONS table: Name Null Type TRANS_ID NOT NULL NUMBER(3) CUST_NAME VARCHAR2(30) TRANS_DATE DATE TRANS_AMT NUMBER(10, 2) You want to display the t...

Examine the structure of the PROMOS table: You want to generate a report showing promo names and their duration (number of days). If the PROMO_END_DATE has not been entered, the me...

Examine the structure of the PROMOS table: You want to display the list of promo names with the message 'Same Day' for promos that started and ended on the same day. Which query gi...

Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table: Which two expressions give the same output? (Choose two.)

View the Exhibit and examine the structure and data in the INVOICE table. Which two SQL statements would execute successfully? (Choose two.)

You issue the following query: SQL> SELECT AVG(MAX(qty)) FROM ord_items GROUP BY item_no HAVING AVG(MAX(qty))>50; Which statement is true regarding the outcome of this query?

Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose all that apply.)

View the exhibit and examine the description for the SALES and CHANNELS tables. You issued the following SQL statement to insert a row in the SALES table: INSERT INTO sales VALUES...

View the Exhibit and examine the data in the PROJ_TASK_DETAILS table. The PROJ_TASK_DETAILS table stores information about tasks involved in a project and the relation between them...

Examine the data in the CUSTOMERS table: You want to list all cities that have more than one customer along with the customer details. Evaluate the following query: SQL>SELECT c1.c...

View the Exhibit and examine the structure of the SALES and PRODUCTS tables. In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You want to l...

Which three statements are true regarding subqueries? (Choose three.)