1z1-061 무료 덤프문제 온라인 액세스

There is a simple view SCOTT.DEPT_VIEW on the table SCOTT.DEPT.
This insert fails with an error:
SQL> insert into dept_view values('SUPPORT','OXFORD'); insert into dept_view values('SUPPORT','OXFORD')
* ERROR at line 1:
ORA-01400: cannot insert NULL into ("SCOTT"."DEPT"."DEPTNO")
What might be the problem?

• A.The view was created as WITH CHECK OPTION.
• B.The INSERT violates a constraint on the view.
• C.The view was created as WITH READ ONLY.
• D.The INSERT violates a constraint on the detail table.

View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.
The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are composite PRIMARY KEY in the ORD_ITEMS table.
Which two CREATE INDEX statements are valid? (Choose two.)

• A.CREATE INDEX ord_idx2ON ord_items(ord_no);
• B.CREATE INDEX ord_idx3ON ord_items(item_no);
• C.CREATE INDEX ord_idx1ON ord(ord_no);
• D.CREATE INDEX ord_idx4ON ord, ord_items(ord_no, ord_date, qty);

Which three statements are true regarding the data types in Oracle Database 10g/11g?
(Choose three.)

• A.The minimum column width that can be specified for a VARCHAR2 data type column is one
• B.A TIMESTAMP data type column stores only time values with fractional seconds
• C.The value for a CHAR data type column is blank-padded to the maximum defined column width
• D.Only One LONG column can be used per table
• E.The BLOB data type column is used to store binary data in an operating system file

Which two statements are true regarding constraints?

• A.All constraints can be defined at the column level as well as the table level.
• B.A foreign key cannot contain null values.
• C.A constraint can be disabled even if the constraint column contains data.
• D.A column with the unique constraint can contain null values.
• E.A constraint is enforced only for the insert operation on a table.

Examine the structure of the orders table:

You want to find the total value of all the orders for each year and issue the following command:

Which statement is true regarding the outcome?

• A.It executes successfully but does not give the correct output.
• B.It executes successfully and gives the correct output.
• C.It gives an error because the data type conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.
• D.It gives an error because the TO_CHAR function is not valid.