1Z0-047 Exam Questions
226 real 1Z0-047 exam questions with expert-verified answers and explanations. Page 3 of 5.
- Question #107
View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. Evaluate the following SQL statement: ALTER TABLE emp DROP CO...
- Question #109
In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
- Question #110
View the Exhibit and examine the structure of the ORDERS table. NEW_IDRDERS is a new table with the columns ORD_ID, ORD_DATE, CUST_ID, and ORD_TOTAL that have the same data types a...
- Question #111
Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement?
- Question #112
View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables. ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wh...
- Question #113
View the Exhibit and examine the structure of ORD and ORD_ITEMS tables. In the ORD table, the PRIMARY KEY is ORD_NO and in the ORD_ITEMS tables the composite PRIMARY KEY is (ORD_NO...
- Question #114
The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR. Which statement would create a synonym ORD so that HR can execute t...
- Question #115
View the Exhibit and examine the description of the EMPLOYEES table. You want to know the EMPLOYEE_ID and FIRST_NAME of all the records in the EMPLOYEES table wherein the JOB_ID co...
- Question #117
Which two statements are true regarding subqueries? (Choose two.)
- Question #118
View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT employee_id, last_name, jobjd, manager_id, LEVEL FROM employees ST...
- Question #119
Which mandatory clause has to be added to the following statement to successfully create an external table called EMPDET? CREATE TABLE empdet (empno CHAR(2), ename CHAR(5), deptno...
- Question #120
View the Exhibit and examine the description of the EMPLOYEES and DEPARTMENTS tables. You want to display the LAST_NAME for the employees, LAST_NAME for the manager of the employee...
- Question #121
Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement?
- Question #122
View the Exhibit and examine the description of the PRODUCT_INFORMATION table. You want to display the expiration date of the warranty for a product. Which SQL statement would you...
- Question #123
View the Exhibit and examine the details of the EMPLOYEES table. Evaluate the following SQL statements: Statement 1: SELECT employee_id, last_name, job_id, manager_id FROM employee...
- Question #125
Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command? (Choose three.)
- Question #127
Which three tasks can be performed using regular expression support in Oracle Database? (Choose three.)
- Question #128
Which three statements are true regarding single-row functions? (Choose three.)
- Question #129
View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement: SELECT oi.order_id, product_jd, order_date FROM order_items oi...
- Question #130
Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
- Question #131
Evaluate the CREATE TABLE statement: CREATE TABLE products (product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15)); Which statement is true regarding th...
- Question #132
View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries? (Choose two.)
- Question #133
Which statement best describes the GROUPING function?
- Question #135
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. Evaluate the following MERGE statement: MERGE INTO orders_master o USING monthly_orders m ON (o.or...
- Question #136
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to...
- Question #137
View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table: ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIM...
- Question #140
Evaluate the following SQL statements that are issued in the given order: CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, enameVARCHAR2(15), salary NUMBER(...
- Question #141
Which statements are correct regarding indexes? (Choose all that apply.)
- Question #142
The details of the order ID, order date, order total, and customer ID are obtained from the ORDERS table. If the order value is more than 30000, the details have to be added to the...
- Question #143
View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?
- Question #145
View the Exhibit and examine the details of the EMPLOYEES table. Evaluate the following SQL statement: SELECT phone_number, REGEXP_REPLACE(phone_number,'([[: digit: ]]{3})\.([[: di...
- Question #146
You executed the following SQL statements in the given order: CREATE TABLE orders (order_id NUMBER(3) PRIMARY KEY, order_date DATE, customer_id number(3)); INSERT INTO orders VALUE...
- Question #147
View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SOL statement: SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alp...
- Question #148
View the Exhibit and examine the data in the CUST_DET table. You executed the following multitable INSERT statement: INSERT FIRST WHEN credit_limit >= 5000 THEN INTO cust_1 VALUES(...
- Question #149
Evaluate the following statements: CREATE TABLE digits (id NUMBER(2), description VARCHAR2(15)); INSERT INTO digits VALUES (1,'ONE); UPDATE digits SET description ='TWO'WHERE id=1;...
- Question #150
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables. You have a requirement from the supplies department to give a list containing PRODUCT_...
- Question #153
View the Exhibit and examine the description of the EMPLOYEES table. You want to display the EMPLOYE_ID, FIRST_NAME, and DEPARTMEN_ID for all the employees who work in the same dep...
- Question #154
Which statement is true regarding external tables?
- Question #155
View the Exhibit and examine the data in EMP and DEPT tables. In the DEPT table, DEPTNO is the PRIMARY KEY. In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY...
- Question #156
Which statement is true regarding external tables?
- Question #157
View the Exhibit and examine the structure of the EMPLOYEES table. You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two col...
- Question #158
In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
- Question #159
View the Exhibit and examine the structure for the ORDERS and ORDER_ITEMS tables. You want to display ORDER_ID, PRODUCT_ID, and TOTAL (UNIT_PRICE multiplied by QUANTITY) for all th...
- Question #160
Evaluate the following SELECT statement and view the Exhibit to examine its output: SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, statu...
- Question #161
View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table. Evaluate the following CREATE TABLE command: CREATE TABL...
- Question #163
View the Exhibit and examine the description of the CUSTOMERS table. You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that the value inserted in...
- Question #166
View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SOL statement: SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alp...
- Question #168
View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables. You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price (UNIT_PRICE multiplied by QUANT...
- Question #169
Given below is the list of meta character syntaxes and their descriptions in random order: Meta character syntax Description 1)^ a) Matches character not in the list 2) [^...] b) M...
- Question #170
View the Exhibit and examine the description of the ORDER_ITEMS and PRODUCT_INFORMATION tables. The ORDER_ITEM table has records pertaining to details for each product in an order....