最新的Oracle Database: SQL Fundamentals I - 1Z1-051免費考試真題
問題1
A SELECT statement can be used to perform these three functions:
-Choose rows from a table.
-Choose columns from a table
-Bring together data that is stored in different tables by creating a link between them.
Which set of keywords describes these capabilities?
-Choose rows from a table.
-Choose columns from a table
-Bring together data that is stored in different tables by creating a link between them.
Which set of keywords describes these capabilities?
正確答案: B
說明：（僅 VCESoft 成員可見）
問題2
Examine the structure of the PROMOS table:
You want to generate a report showing promo names and their duration (number of days).
If the PROMO_END_DATE has not been entered, the message 'ONGOING' should be displayed. Which queries give the correct output? (Choose all that apply.)
You want to generate a report showing promo names and their duration (number of days).
If the PROMO_END_DATE has not been entered, the message 'ONGOING' should be displayed. Which queries give the correct output? (Choose all that apply.)
正確答案: A,C,E
問題3
Which three statements/commands would cause a transaction to end? (Choose three.)
正確答案: A,B,E
問題4
Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all that apply.)
正確答案: B,D
說明：（僅 VCESoft 成員可見）
問題5
Which statement describes the ROWID data type?
正確答案: C
說明：（僅 VCESoft 成員可見）
問題6
Which view should a user query to display the columns associated with the constraints on a table owned by the user?
正確答案: A
說明：（僅 VCESoft 成員可見）
問題7
Evaluate the following SQL statement:
SQL> SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name FROM customers
WHERE country_id = 30;
Which ORDER BY clause are valid for the above query? (Choose all that apply.)
SQL> SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name FROM customers
WHERE country_id = 30;
Which ORDER BY clause are valid for the above query? (Choose all that apply.)
正確答案: A,B,E
說明：（僅 VCESoft 成員可見）
問題8
Examine the structure of the CUSTOMERS table: CUSTNO is the PRIMARY KEY in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names.
Which two methods can you use to get the required result? (Choose two.)
Which two methods can you use to get the required result? (Choose two.)
正確答案: B,C
