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

Examine the structure and data of the CUSTJTRANS table:
CUSTJRANS Name Null? Type CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) CUSTNO
TRANSDATE TRANSAMT 11 01-JAN-07 1000 22 01-FEB-07 2000 33 01-MAR-07 3000
Dates are stored in the default date format dd-mon-rr in the CUSTJTRANS table. Which three SQL statements would execute successfully? (Choose three.)

• A.SELECT custno - 'A' FROM custjrans WHERE transamt > 2000:
• B.SELECT * FROM custjrans WHERE transdate='01-JANUARY-07':
• C.SELECT * FROM custjrans WHERE transdate = '01-01-07':
• D.SELECT transamt FROM custjrans WHERE custno > '11':
• E.SELECT transdate + '10' FROM custjrans;

Examine the statement:
Create synonym emp for hr.employees;
What happens when you issue the statement?

• A.You will have two identical tables in the HR schema with different names.
• B.An error is generated.
• C.You create a table called employees in the HR schema based on you EMP table.
• D.You create an alternative name for the employees table in the HR schema in your own schema.

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)
SET time_id = '22-MAR-2007'
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_last_name = 'Roberts' AND
credit_limit = 600);
Which statement is true regarding the execution of the above UPDATE statement?

• A.It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.
• B.It would execute and restrict modifications to only the columns specified in the SELECT statement.
• C.It would not execute because the SELECT statement cannot be used in place of the table name.
• D.It would not execute because two tables cannot be used in a single UPDATE statement.

Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all that apply.)

• A.It locks only the columns specified in the SELECT list.
• B.After it is enforced by a SELECT statement, no other query can access the same rows until a COMMIT or ROLLBACK is issued.
• C.It can be used in SELECT statements that are based on a single or multiple tables.
• D.It locks the rows that satisfy the condition in the SELECT statement.
• E.It can be used only in SELECT statements that are based on a single table.

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 products that were sold during their promo campaign and before 30th October 2007.
You issue the following query:

Which statement is true regarding the above query?

• A.It executes successfully and gives the required result.
• B.It produces an error because equijoin and nonequijoin conditions cannot be used in the same SELECT statement.
• C.It executes successfully but does not give the required result.
• D.It produces an error because the join order of the tables is incorrect.