Oracle 1Z0-047 問題集

質問 1：
View the Exhibit and examine the structure of the EMP table.
You executed the following command to add a primary key to the EMP table:
ALTER TABLE emp
ADD CONSTRAINT emp_id_pk PRIMARY KEY (emp_id)
USING INDEX emp_id_idx;
Which statement is true regarding the effect of the command?

A. The PRIMARY KEY is created and it would use an existing unique index.
B. The PRIMARY KEY is created along with a new index.
C. The PRIMARY KEY would be created in a disabled state because it is using an existing index.
D. The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
正解：A

質問 2：
View the Exhibit button and examine the structures of ORDERS and ORDER_ITEMS tables.
In the ORDERS table, ORDER_ID is the PRIMARY KEY and in the ORDER_ITEMS table, ORDER_ID and LINE_ITEM_ID form the composite primary key.
Which view can have all the DML operations performed on it?

A. CREATE VIEW V1
AS SELECT order_id, product_id
FROM order_items;
B. CREATE VIEW V3
AS SELECT o.order_id, o.customer_id, i.product_id
FROM orders o, order_items i
WHERE o.order_id=i. order_id;
C. CREATE VIEW V2
AS SELECT order_id, line_item_id, unit_price*quantity total
FROM order items;
D. CREATE VIEW V4(or_no, or_date, cust_id)
AS SELECT order_id, order_date, customer_id
FROM orders
WHERE order_date < 30-mar-2007'
WITH CHECK OPTION;
正解：D

質問 3：
Which CREATE TABLE statement is valid?
A. CREATE TABLE ord_details
(ord_no NUMBER(2) PRIMARY KEY,
item_no NUMBER(3) PRIMARY KEY,
ord_date date NOT NULL);
B. CREATE TABLE ord_details
(ord_no NUMBER(2) UNIQUE, NOT NULL,
item_no NUMBER(3),
ord_date date DEFAULT SYSDATE NOT NULL);
C. CREATE TABLE ord_details
(ord_no NUMBER(2),
item_no NUMBER(3),
ord_date date DEFAULT SYSDATE NOT NULL,
CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));
D. CREATE TABLE ord_details
(ord_no NUMBER(2) ,
item_no NUMBER(3),
ord_date date DEFAULT NOT NULL,
CONSTRAINT ord_uq UNIQUE (ord_no),
CONSTRAINT ord_pk PRIMARY KEY (ord_no));
正解：C

質問 4：
View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables. The query should display the employee IDs of all the employees who have held the job SA_MAN
at any time during their tenure.
Choose the correct SET operator to fill in the blank space and complete the following query.
SELECT employee_id
FROM employees
WHERE job_id = 'SA_MAN'
SELECT employee_id FROMjob_history
WHERE job_id='SA_MAN'

A. INTERSECT
B. UNION ALL
C. UNION
D. MINUS
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements are true regarding single-row functions? (Choose three.)
A. They can return multiple values of more than one data type.
B. They can modify the data type of the argument that is referenced.
C. They can be nested up to only two levels.
D. They can be used in SELECT, WHERE, and ORDER BY clauses.
E. They can accept only one argument.
F. They can accept a column name, expression, variable name, or a user-supplied constant as arguments.
正解：B,D,F

質問 6：
Which statement is true regarding synonyms?
A. The DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym has been created becomes invalid.
B. Synonyms are used to reference only those tables that are owned by another user.
C. A public synonym and a private synonym can exist with the same name for the same table.
D. Synonyms can be created for tables but not views.
正解：C