最高で1z1-071最新の2026問題集は100%試験合格率保証付きます [Q18-Q41]

質問18、 Examine the command to create the BOOKS table.

The BOOK_IDvalue 101does not exist in the table.
Examine the SQL statement:

Which statement is true?

質問19、 Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

質問20、 View the Exhibit and examine the structure of the ORDER_ITEMS table.

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

質問21、 View the Exhibits and examine the structures of the costs and promotions tables?
1.2.


Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_cost < ALL (SELECT MAX(promo_cost) FROM promotions GROUP BY (promo_end_datepromo_ begin_date)));
What would be the outcome of the above SQL statement?

質問22、 Which two statements are true regarding indexes? (Choose two.)

質問23、 Examine these SQL statements which execute successfully:

Which two statements are true after execution?

質問24、 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 last promo in the ‘INTERNET’ category.
Which query would give you the required output?

質問25、 View the exhibit and examine the description of the PRODUCT_INFORMATIONtable.

Which SQL statement would retrieve from the table the number of products having LIST_PRICEas NULL?

質問26、 Which two statements are true regarding a SAVEPOINT? (Choose two.)

質問27、 Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEES_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:
UPDATE employees
SET (job_id, salary) =
(SELECT job_id, salary
FROM employees
WHERE employee_id = 200)
WHERE employee id=100;
Which two statements are true?

質問28、 View the Exhibits and examine PRODUCTS and SALES tables.
Exhibit 1

Exhibit 2

You issue the following query to display product name the number of times the product has been sold:

What happens when the above statement is executed?

質問29、 Examine the description of the EMPLOYEES table:

Which two queries return the highest salary in the table?

質問30、 Which statement is true about an inner join specified in a query’s WHERE clause?

質問31、 You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session?
Which query can be used?

質問32、 View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statements:

What will be the result?
Exhibit 1.

Exhibit 2.

質問33、 View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER_ID is the primary key in the ORDERS table and the foreign key of the ORDER_ITEMS table, whose constraint is defined with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?

質問34、 Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
——————-
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikilineni
Julia Nayer
You need to display customers’ second names where the second name starts with “Mc” or “MC”.
Which query gives the required output?

質問35、 View the Exhibit and examine the descriptions of the DEPT and LOCATIOMS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.
Which SQL statement would you execute to accomplish the task?

質問36、 View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

Evaluate this SQL statement:
SELECT TO_CHAR (list_price, ‘$9,999’)
From product_information;
Which two statements are true regarding the output? (Choose two.)

質問37、 View the Exhibit and examine the structure of the ORDER_ITEMS table.

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

質問38、 Examine the description of the ENPLOYES table:

Which query requires explicit data type conversion?

質問39、 Examine this query:
SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3;
What is returned upon execution?

質問40、 You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output?

質問41、 Examine the SQL statement used to create the TRANSACTION table.
SQL > CREATE TABLE transaction
(trn_id char(2) primary key,
Start_date date DEFAULT SYSDATE,
End_date date NOT NULL);
The value ‘A1’ does not exist for trn_id in this table.
Which SQL statement successfully inserts a row into the table with the default value for START_DATE?