Online Access Free 1Z0-007 Practice Test

You are granted the CREATE VIEW privilege. What does this allow you to do?

• A.Create a table view.
• B.Create a sequence view in any schema.
• C.Create a view in your schema.
• D.Create a view only of it is based on tables that you created.
• E.Create a view in any schema.
• F.Create a view that is accessible by everyone.

The CUSTOMERS table has these columns:

The CUSTOMER_ID column is the primary key for the table.
Which two statements find the number of customers? (Choose two.)

• A.SELECT TOTAL(customer_id) FROM customers;
• B.SELECT COUNT(customers) FROM customers;
• C.SELECT COUNT(customer_id) FROM customers;
• D.SELECT TOTAL(*) FROM customers;
• E.SELECT TOTAL(customer_name) FROM customers;
• F.SELECT COUNT(*) FROM customers;

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER (12)
SEMESTER_END DATE
GPA NUMBER (4,3)
The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?

• A.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
• B.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC;
• C.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC;
• D.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end ASC, gpa ASC;
• E.SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC;

Examine the statement:
GRANT select, insert, update
ON student_grades
TO manager
WITH GRANT OPTION;
Which two are true? (Choose two.)

• A.It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
• B.It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
• C.It allows the MANAGER to pass the specified privileges on to other users.
• D.MANAGER must be a role.
• E.It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
• F.It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25)
Which three statements inserts a row into the table? (Choose three)

• A.INSERT INTO employees VALUES ('1000','John',NULL);
• B.INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John','');
• C.INSERT INTO employees (employee_id) VALUES (1000);
• D.INSERT INTO employees VALUES ( NULL, 'John','Smith');
• E.INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, 'John','Smith');
• F.INSERT INTO employees( first_name, last_name) VALUES('John','Smith');