1Z0-061 Exam Questions

You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration of the...

Which three tasks can be performed using SQL functions built into Oracle Database?

View the Exhibit and examine the data in the employees table: You want to display all the employee names and their corresponding manager names. Evaluate the following query: Which...

View the Exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the sales table, where the PROMO_NAME column in the promotions table has e...

Evaluate the following query: What would be the outcome of the above query?

Examine the structure of the transactions table: You want to display the date, time, and transaction amount of transactions that where done before 12 noon. The value zero should be...

View the Exhibit and examine the structure of the customers table. Using the customers table, you need to generate a report that shows the average credit limit for customers in Was...

Examine the data in the ename and hiredate columns of the employees table: You want to generate a list of user IDs as follows: You issue the following query: What is the outcome?

Evaluate the following SQL commands: The command to create a table fails. Identify the two reasons for the SQL statement failure?

View the Exhibit and examine the structure of the SALES table. The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold...

View the Exhibit and examine the structure of the customers table. Using the customers table, you need to generate a report that shows an increase in the credit limit by 15% for al...

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

Examine the structure and data of the CUST_TRANS table: Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table. Which three SQL statements would execute succ...

View the Exhibit and examine the structure of the customers table. NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and...

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?

Examine the data in the ORD_ITEMS table: Evaluate the following query: Which statement is true regarding the outcome of the above query?

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

You need to create a table with the following column specifications: 1. Employee ID (numeric data type) for each employee 2. Employee Name (character data type) that stores the emp...

Examine the structure of the sales table: Evaluate the following create table statement: Which two statements are true about the creation of the SALES1 table?

Which two statements are true regarding subqueries?

Examine the structure of the products table: You want to display the names of the products that have the highest total value for UNIT_PRICE * QTY_IN_HAND. Which SQL statement gives...

Which statement is true regarding the UNION operator?

View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the promotions table, and the required output format. Which two queries give the correct resul...

View the Exhibit and examine the structures of the employees and departments tables. You want to update the employees table as follows: - Update only those employees who work in Bo...

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

View the Exhibit and examine the data in the costs table. You need to generate a report that displays the IDs of all products in the costs table whose unit price is at least 25% mo...

View the Exhibits and examine the structures of the products, sales, and customers tables. You need to generate a report that gives details of the customer's last name, name of the...

View the Exhibit and examine the structure of the products table. Evaluate the following query: What would be the outcome of executing the above SQL statement?

You issued the following command: SQL> DROP TABLE employees; Which three statements are true?

Examine the create table statements for the stores and sales tables. SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_...

Examine the data in the CUST_NAME column of the customers table. You need to display customers' second names where the second name starts with "Mc" or "MC." Which query gives the r...

You want to create a sales table with the following column specifications and data types: SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set to 1 when no val...

Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00, -1), -1) FROM DUAL; What would be the outcome?

You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if thi...

Examine the data in the PROMO_BEGIN_DATE column of the promotions table: You want to display the number of promotions started in 1999 and 2000. Which query gives the correct output...

You want to display the date for the first Monday of the next month and issue the following command: What is the outcome?

View the Exhibit and examine the structure of the promotions table. You need to generate a report of all promos from the promotions table based on the following conditions: 1. The...

Examine the structure of the employees table. You want to display the maximum and minimum salaries of employees hired 1 year ago. Which two statements would get the correct output?

Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each i...

You issue the following command to drop the products table: SQL> DROP TABLE products; Which three statements are true about the implication of this command?

Evaluate the following SQL statement: Which statement is true regarding the above query if one of the values generated by the subquery is null?

Examine the structure of the employees table: There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID. You want to display the name, joining date, and manager for a...

Which statement is true regarding the default behavior of the order by clause?

View the Exhibits and examine the structures of the products and sales tables. Which two SQL statements would give the same output?

The customers table has the following structure: You need to write a query that does the following tasks: 1. Display the first name and tax amount of the customers. Tax is 5% of th...

View the Exhibit and examine the structure of the CUSTOMERS table. You have been asked to produce a report on the customers table showing the customers details sorted in descending...

View the Exhibit and examine the data in the products table. You need to display product names from the products table that belong to the 'software/other' category with minimum pri...

You need to display the first names of all customers from the customers table that contain the character 'e' and have the character 'a' in the second last position. Which query wou...

Examine the structure of the customers table: CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using differen...

You need to generate a list of all customer last names with their credit limits from the customers table. Those customers who do not have a credit limit should appear last in the l...