1Z0-061 Exam Questions
318 real 1Z0-061 exam questions with expert-verified answers and explanations. Page 3 of 7.
- Question #101
Which two statements are true regarding single row functions? (Choose two.)
- Question #102
Which two statements are true regarding working with dates? (Choose two.)
- Question #103
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...
- Question #104
Which two statements about sub queries are true? (Choose two.)
- Question #105
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...
- Question #106
Which are /SQL*Plus commands? (Choose all that apply.)
- Question #107
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.)
- Question #108
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...
- Question #109
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? (...
- Question #110
Which two are true about aggregate functions? (Choose two.)
- Question #111
See the structure of the PROGRAMS table: Which two SQL statements would execute successfully? (Choose two.)
- Question #112
Which statement is true regarding transactions? (Choose all that apply.)
- Question #113
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?
- Question #114
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...
- Question #115
Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)
- Question #116
Which three are true? (Choose three.)
- Question #117
Which two statements are true regarding views? (Choose two.)
- Question #118
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which DELETE statement is valid?
- Question #119
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...
- Question #120
Examine the structure of the EMPLOYEES table: Which UPDATE statement is valid?
- Question #121
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...
- Question #122
The PRODUCTS table has the following structure: Evaluate the following two SQL statements: Which statement is true regarding the outcome?
- Question #123
Which statements are correct regarding indexes? (Choose all that apply.)
- Question #124
You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit: Which two SQL statements would execute successfully? (Choose two.)
- Question #125
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?
- Question #126
Examine the structure of the MARKS table: Which two statements would execute successfully? (Choose two.)
- Question #127
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...
- Question #128
Evaluate the following two queries: Which statement is true regarding the above two queries?
- Question #129
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...
- Question #130
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...
- Question #131
Which object privileges can be granted on a view?
- Question #132
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...
- Question #133
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?
- Question #134
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...
- Question #135
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...
- Question #136
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...
- Question #137
Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
- Question #138
Examine the structure of the EMPLOYEES table: Which INSERT statement is valid?
- Question #139
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?
- Question #140
Which is an iSQL*Plus command?
- Question #141
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...
- Question #142
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...
- Question #143
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?
- Question #144
Which statement is true regarding the INTERSECT operator?
- Question #145
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...
- Question #146
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...
- Question #147
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...
- Question #148
Which statement is true regarding synonyms?
- Question #149
Which one is a system privilege?
- Question #150
What is true about sequences?