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

The EMPLOYEES table has these columns:
LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE
Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:
ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000);
What is true about your ALTER statement?

• A.Column definitions cannot be altered to add DEFAULT values.
• B.All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
• C.A change to the DEFAULT value affects only subsequent insertions to the table.
• D.Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds the highest grade point average (GPA) per semester?

• A.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
• B.SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
• C.SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
• D.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
• E.SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

Which are DML statements? (Choose all that apply)

• A.MERGE...
• B.CREAT..
• C.COMMIT...
• D.DROP...
• E.DELETE...
• F.UPDATE...

Examine the data in the EMPLOYEES and DEPARTMENTS tables:

Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:
CREATE TABLE departments
(department_id NUMBER PRIMARY KEY,
department_name VARCHAR2(30));
CREATE TABLE employees
(EMPLOYEE_ID NUMBER PRIMARY KEY,
EMP_NAME VARCHAR2(20),
DEPT_ID NUMBER REFERENCES
departments(department_id),
MGR_ID NUMBER REFERENCES
employees(employee id),
MGR_ID NUMBER REFERENCES
employees(employee id),
JOB_ID VARCHAR2(15).
SALARY NUMBER);
ON the EMPLOYEES,
On the EMPLOYEES table, EMPLOYEE_ID is the primary key.
MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.
DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.
On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.
Examine this DELETE statement:
DELETE
FROM departments
WHERE department id = 40;
What happens when you execute the DELETE statement?

• A.The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
• B.The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
• C.The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
• D.The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
• E.The statement fails because there are child records in the EMPLOYEES table with department ID 40.
• F.Only the row with department ID 40 is deleted in the DEPARTMENTS table.

The CUSTOMERS table has these columns:

The CUSTOMER_ID column is the primary key for the table.
You need to determine how dispersed your customer base is.
Which expression finds the number of different countries represented in the CUSTOMERS table?

• A.COUNT(UPPER(country_address))
• B.COUNT DISTINCT UPPER(country_address)
• C.COUNT(DIFF(UPPER(country_address)))
• D.COUNT(UNIQUE(UPPER(country_address)))
• E.COUNT(DISTINCT (UPPER(country_address)))