1Z0-047 무료 덤프문제 온라인 액세스

Which view would you use to display the column names and DEFAULT values for a table?

• A.USER_COLUMNS
• B.USER TAB COLUMNS
• C.DBA_COLUMNS
• D.DBA_TABLES

Which statements are true regarding the usage of the WITH clause in complex correlated subqueries? (Choose all that apply.)

• A.It can be used only with the SELECT clause.
• B.The WITH clause can hold more than one query.
• C.If the query block name and the table name were the same, then the table name would take precedence.
• D.The query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block.

Evaluate the following command:
CREATE TABLE employees (employee_id NUMBER(2) PRIMARY KEY, last_name VARCHAR2(25) NOT NULL, department_id NUMBER(2), job_id VARCHAR2(8), salary NUMBER(10,2)); You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization: CREATE OR REPLACE VIEW sales_staff_vu AS SELECT employee_id, last_name job_id FROM employees WHERE job_id LIKE 'SA_%' WITH CHECK OPTION;
Which statements are true regarding the above view? (Choose all that apply.)

• A.It allows you to insert details of all new staff into the EMPLOYEES table.
• B.It allows you to delete the details of the existing sales staff from the EMPLOYEES table.
• C.It allows you to insert the IDs, last names and job ids of the sales staff from the view if it is used in multitable INSERT statements.
• D.It allows you to update the job ids of the existing sales staff to any other job id in the EMPLOYEES table.

Which two statements are true regarding constraints? (Choose two.)

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

View the Exhibit and examine the structure of the CUST table.
Evaluate the following SQL statements executed in the given order:
ALTER TABLE cust
ADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_id) DEFERRABLE INITIALLY DEFERRED;
INSERT INTO cust VALUES (1 /RAJ1); --row 1
INSERT INTO cust VALUES (1 ,'SAM); --row 2
COMMIT;
SET CONSTRAINT cust_id_pk IMMEDIATE;
INSERT INTO cust VALUES (1 /LATA1); --row 3
INSERT INTO cust VALUES (2 .KING1); --row 4
COMMIT;
Which rows would be made permanent in the CUST table?

• A.row 4 only
• B.rows 1 and 4
• C.rows 3 and 4
• D.rows 2 and 4