1Z0-061 Exam Questions

Which two statements are true regarding single row functions? (Choose two.)

Which two statements are true regarding working with dates? (Choose two.)

View the Exhibit and examine the description for the CUSTOMERS table. You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where CUST_INCOME_LEVEL has NUL...

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

View the Exhibit and examine the structure of the PROMOTIONS table. You have to generate a report that displays the promo name and start date for all promos that started after the...

Which are /SQL*Plus commands? (Choose all that apply.)

Examine the description of the EMP_DETAILS table given below: Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table? (Choose two.)

See the exhibit and examine the structure of the CUSTOMERS and GRADES tables: You need to display names and grades of customers who have the highest credit limit. Which two SQL sta...

You need to calculate the number of days from 1st Jan 2007 till date: Dates are stored in the default format of dd-mm-rr. Which two SQL statements would give the required output? (...

Which two are true about aggregate functions? (Choose two.)

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

Which statement is true regarding transactions? (Choose all that apply.)

See the Exhibits and examine the structures of PRODUCTS, SALES and CUSTOMERS table: You issue the following query: Which statement is true regarding the outcome of this query?

You work as a database administrator at ABC.com. You study the exhibit carefully. You want to create a SALE_PROD view by executing the following SQL statements: Which statement is...

Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)

Which three are true? (Choose three.)

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

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which DELETE statement is valid?

View the Exhibits and examine the structures of the PROMOTIONS and SALES tables. Evaluate the following SQL statements: Which statement is true regarding the output of the above qu...

Examine the structure of the EMPLOYEES table: Which UPDATE statement is valid?

View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables. Evaluate the following SQL statements: Which statement is true regarding the above compound query...

The PRODUCTS table has the following structure: Evaluate the following two SQL statements: Which statement is true regarding the outcome?

Which statements are correct regarding indexes? (Choose all that apply.)

You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit: Which two SQL statements would execute successfully? (Choose two.)

Examine these statements: CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do?

Examine the structure of the MARKS table: Which two 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...

Evaluate the following two queries: Which statement is true regarding the above two queries?

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables. The CUSTOMERS table contains the current location of all currently active customers. The CUST_H...

You created an ORDERS table with the following description: You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint...

Which object privileges can be granted on a view?

View the Exhibit and examine the structure of the CUSTOMERS table. you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country...

The STUDENT_GRADES table has these columns: Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?

View the Exhibit and examine the data in the PROMOTIONS table. You need to display all promo categories that do not have 'discount' in their subcategory. Which two SQL statements g...

See the Exhibit and examine the structure of the PROMOTIONS table: Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5...

You work as a database administrator at ABC.com. You study the exhibit carefully. and examine the structure of CUSTOMRS AND SALES tables: Evaluate the following SQL statement: Whic...

Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)

Examine the structure of the EMPLOYEES table: Which INSERT statement is valid?

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

Which is an iSQL*Plus command?

You work as a database administrator at ABC.com. You study the exhibit carefully. Using the PROMOTIONS table, you need to display the names of all promos done after January 1, 2001...

See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and ITEMS tables: The PROD_ID column is the foreign key in the SALES table, which references the PRODUCT...

You need to display the date 11-Oct-2007 in words as `Eleventh of October, Two Thousand Seven'. Which SQL statement would give the required result?

Which statement is true regarding the INTERSECT operator?

You work as a database administrator at ABC.com. You study the exhibit carefully and examine the structure of CUSTOMRS AND SALES tables. Evaluate the following SQL statement: Which...

The STUDENT_GRADES table has these columns: STUDENT_ID. NUMBER(12) SEMESTER_END. DATE GPA. NUMBER(4, 3) The registrar has asked for a report on the average grade point average (GPA...

You work as a database administrator at ABC.com. You study the exhibit carefully. Evaluate the following query: The above query produces an error on execution. What is the reason f...

Which statement is true regarding synonyms?

Which one is a system privilege?

What is true about sequences?