1Z0-061 Exam Questions

Examine the structure of the INVOICE table: Which two SQL statements would execute successfully? (Choose two.)

View the Exhibit and examine the description for the CUSTOMERS table. You want to update the CUST_INCOME_LEVEL and CUST_CREDIT_LIMIT columns for the customer with the CUST_ID 2360....

A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tabl...

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

You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command: PROMOTIONS is the public synonym for the public database...

Which is a valid CREATE TABLE statement?

Evaluate the following SQL statements: You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization. Which two state...

Which three statements/commands would cause a transaction to end? (Choose three.)

You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement: 1) The order ID will be unique and cannot have null values. 2...

Which three statements are true regarding sub queries? (Choose three.)

See the Exhibit and examine the structure of the PROMOSTIONS table: Which SQL statements are valid? (Choose all that apply.)

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?

For which action can you use the TO_DATE function?

Evaluate the following SQL statements: Which is the correct output of the above query?

See the Exhibit and examine the structure of ORD table: Evaluate the following SQL statements that are executed in a user session in the specified order: CREATE SEQUENCE ord_seq; S...

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

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

The SQL statements executed in a user session as follows: Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two....

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

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would...

View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables. You need to generate a report showing the promo name along with the customer name for all...

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

View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query statement: What would be the outcome of the above statement?

View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL statements are valid? (Choose all that apply.)

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

The PART_CODE column in the SPARES table contains the following list of values: Which statement is true regarding the outcome of the above query?

View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: The above query generates an error on execution. Which clause in the above...

Which statement is true regarding sub queries?

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

Evaluate the following SQL statement: SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM custome...

Which is the valid CREATE [TABLE statement?

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

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

What is true regarding sub queries?

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?

The following data exists in the PRODUCTS table: PROD_ID PROD_LIST_PRICE ---------------------------------------------- 123456 152525.99 You issue the following query: SQL> SELECT...

View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements: Which statement is true regarding the above two SQL statements?

Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)

Which two statements are true regarding sub queries? (Choose two.)

You need to calculate the number of days from 1st January 2007 till date . Dates are stored in the default format of dd-mon-rr. Which two SQL statements would give the required out...

Examine the structure and data in the PRIC E_LIST table: Name Null? Type ------------ ------------- ------------------- PROD_D NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PR...

Which statement is true regarding the COALESCE function?

View the Exhibit and examine the structure of ORD and ORD_ITEMS tables. The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are composite PRIMARY K...

View the Exhibit and examine the structure of the PROMOTIONS table. Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV' and 'internet...

You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL stateme...

View the Exhibit and examine the structure of the PROMOTIONS table. Using the PROMOTIONS table, you need to display the names of all promos done after January 1, 2001, starting wit...

Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)

View the Exhibit and examine the structure of CUSTOMERS and SALES tables. Evaluate the following SQL statement: UPDATE (SELECT prod_id, cust_id, quantity_sold, time_id FROM sales)...

You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'. Which WHERE clause could be used in the SELECT statement to g...

Which three statements are true about multiple-row sub queries? (Choose three.)