Oracle 1z0-061 問題集

質問 1：
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 the following query successfully?
SELECT * FROM ord;
A. CREATE SYNONYM ord FOR orders; This command is issued by OE.
B. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE.
C. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
D. CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Evaluate the SQL statement
DROP TABLE DEPT:
Which four statements are true of the SQL statement? (Choose four.)
A. All data in the table is deleted, and the table structure is also deleted.
B. You cannot roll back this statement.
C. All indexes based on the DEPT table are dropped.
D. All synonyms based on the DEPT table are deleted.
E. All pending transactions are committed.
F. All views based on the DEPT table are deleted.
G. All data in the table is deleted, but the structure of the table is retained.
正解：A,B,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
View the Exhibit and examine the structure of the promotions table.
You need to generate a report of all promos from the promotions table based on the following conditions:
1. The promo name should not begin with 'T' or 'N'.
2. The promo should cost more than $20000.
3. The promo should have ended after 1st January 2001.
Which where clause would give the required result?

A. WHERE promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%' AND
promo_cost > 20000 AND promo_end_date > '1-JAN-01'
B. WHERE (promo_name NOT LIKE '%T%' OR promo_name NOT LIKE '%N%')
AND(promo_cost >20000 AND promo_end_date > '1-JAN-01')
C. WHERE (promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%')OR
promo_cost >20000 OR promo_end_date > '1-JAN-01'
D. WHERE promo_name NOT LIKE 'T%' OR promo_name NOT LIKE 'N%' AND
promo_cost >20000 AND promo_end_date > '1-JAN-01'
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You issue the following command to alter the country column in the departments table:

Which statement is true?
A. It produces an error because column definitions cannot be altered to add default values.
B. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'.
C. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table.
D. It produces an error because the data type for the column is not specified.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements are true about the ALTER TABLE .... DROP COLUMN ....
command?
A. A column can be dropped only if another column exists in the table.
B. A parent key column in the table cannot be dropped.
C. The column in a composite PRIMARY KEY with the CASCADE option can be dropped.
D. A dropped column can be rolled back.
E. A column can be dropped only if it does not contain any data.
正解：A,B,C

質問 6：
Examine the structure proposed for the transactions table:

Which two statements are true regarding the creation and storage of data in the above table structure?
A. The TRANS_VALIDITY column would give an error.
B. The CUST_CREDIT_LIMIT column would not be able to store decimal values.
C. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds
D. The CUST_STATUS column would give an error.
E. The TRANS_VALIDITY column would have a maximum size of one character.
F. The CUST_STATUS column would store exactly one character.
正解：A,F
解説: (Topexam メンバーにのみ表示されます)

質問 7：
View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.

Evaluate the following two queries:
SQL>SELECT DISTINCT promo_category || to_char(promo_cost)"code"
FROM promotions
ORDER BY code;
SQL>SELECT DISTINCT promo_category || promo_cost "code"
FROM promotions
ORDER BY 1;
Which statement is true regarding the execution of the above queries?
A. Only the second query executes successfully.
B. Both queries execute successfully but give different results.
C. Only the first query executes successfully.
D. Both queries execute successfully and give the same result.
正解：A
解説: (Topexam メンバーにのみ表示されます)