1Z1-051 試験問題を無料オンラインアクセス

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 KEY in the ORD_ITEMS table.
Which two CREATE INDEX statements are valid? (Choose two.)

• A.CREATE INDEX ord_idx2
  ON ord_items(ord_no);
• B.CREATE INDEX ord_idx1
  ON ord(ord_no);
• C.CREATE INDEX ord_idx3
  ON ord_items(item_no);
• D.CREATE INDEX ord_idx4
  ON ord,ord_items(ord_no, ord_date,qty);

EMPLOYEES and DEPARTMENTS data:
EMPLOYEES

DEPARTMENTS

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID.
On the DEPARTMENTS table DEPARTMENT_ID is the primary key.
Evaluate this UPDATE statement.
UPDATE employees SET mgr_id = (SELECT mgr_id FROMemployees WHERE dept_id= (SELECT department_id FROM departments WHERE department_name = 'Administration')), Salary = (SELECT salary FROM employees WHERE emp_name = 'Smith') WHERE job_id = 'IT_ADMIN';
What happens when the statement is executed?

• A.The statement fails because there is more than one row matching the employee name Smith.
• B.The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.
• C.The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.
• D.The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.
• E.The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.
• F.The statement fails because there is no 'Administration' department in the DEPARTMENTS table.

See 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 all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

• A.SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT" FROM customers;
• B.SELECT NVL(cust_credit_limit*.15,'Not Available') "NEW CREDIT" FROM customers;
• C.SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT" FROM customers;
• D.SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT" FROM customers;

Which view should a user query to display the columns associated with the constraints on a table owned by the user?

• A.USER_OBJECTS
• B.USER_CONSTRAINTS
• C.USER_COLUMNS
• D.ALL_CONSTRAINTS
• E.USER_CONS_COLUMNS

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

• A.It can be used to restrict the number of columns used in a NATURAL join.
• B.It can be used to access data from tables through equijoins as well as nonequijoins.
• C.It can be used to join a maximum of three tables.
• D.It can be used to join tables that have columns with the same name and compatible data types.