站内搜索
1Z0-007 问题列表
问题
单选题You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）A
You get an error because of a primary key violation.B
The data and structure of the EMPLOYEES table are deleted.C
The data in the EMPLOYEES table is deleted but not the structure.D
You get an error because the statement is not syntactically correct.
问题
多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.
问题
单选题Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）A
SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;B
SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;C
SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;D
SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );
问题
单选题You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）A
SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date '21-JAN-2001' ORDER BY purchase_date;B
SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date '21-JAN-2001' ORDER BY purchase date ASC;C
SELECT book_title FROM books WHERE price 500 or 900 AND purchase_date '21-JAN-2001' ORDER BY purchase date DESC;D
SELECT book_title FROM books WHERE (price 500 OR price 900) AND purchase_date '21-JAN-2001' ORDER BY purchase date DESC;
问题
多选题The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? （）ASELECT TOTAL(*) FROM customer;BSELECT COUNT(*) FROM customer;CSELECT TOTAL(customer_id) FROM customer;DSELECT COUNT(customer_id) FROM customer;ESELECT COUNT(customers) FROM customer;FSELECT TOTAL(customer_name) FROM customer;
问题
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A
Alice onlyB
Alice and ReenaC
Alice, Reena, and TimberD
Sue, Alice, Reena, and Timber
问题
单选题A data manipulation language statement （）.A
completes a transaction on a tableB
modifies the structure and data in a tableC
modifies the data but not the structure of a tableD
modifies the structure but not the data of a table
问题
单选题Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?（）A
SELECT dept_id, MIN(salary(, MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX (salary) 15000;B
SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000 GROUP BY dept_id;C
SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) 5000 AND MAX (salary) 15000;D
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN (salary) 5000 AND MAX(salary)E
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN (salary) 5000 AND MAX (salary) 15000;
问题
多选题Which three are DATETIME data types that can be used when specifying column definitions? （）ATIMESTAMPBINTERVAL MONTH TO DAYCINTERVAL DAY TO SECONDDINTERVAL YEAR TO MONTHETIMESTAMP WITH DATABASE TIMEZONE
问题
多选题Which three are DATETIME data types that can be used when specifying column definitions? （）ATIMESTAMPBINTERVAL MONTH TO DAYCINTERVAL DAY TO SECONDDINTERVAL YEAR TO MONTHETIMESTAMP WITH DATABASE TIMEZONE
问题
多选题Which three are true?（）AA MERGE statement is used to merge the data of one table with data from another.BA MERGE statement replaces the data of one table with that of another.CA MERGE statement can be used to insert new rows into a table.DA MERGE statement can be used to update existing rows in a table.
问题
单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）A
Use the DESCRIBE command in the EMP_DEPT VU view.B
Use the DEFINE VIEW command on the EMP_DEPT VU view.C
Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
问题
单选题In which scenario would TOP N analysis be the best solution?（）A
You want to identify the most senior employee in the company.B
You want to find the manager supervising the largest number of employees.C
You want to identify the person who makes the highest salary for all employees.D
You want to rank the top three sales representatives who have sold the maximum number of products.