站内搜索
1Z0-007 问题列表
问题
多选题Which two statements about sequences are true? （）AYou use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.BYou use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.CYou use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.DYou use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.EIf a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.FYou use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
问题
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, throughsubstitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）A
INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);B
INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));C
INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);D
INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);E
INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did);
问题
单选题Which statement correctly describes SQL and /SQL*Plus? （）A
Both SQL and /SQL*plus allow manipulation of values in the database.B
/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C
/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D
/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
问题
多选题Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE
问题
单选题Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）A
SELECT last_name, 12*salary* commission_pct FROM emp;B
SELECT last_name, 12*salary* (commission_pct,0) FROM emp;C
SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;D
SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
问题
单选题Which SQL statement returns a numeric value?（）A
SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;B
SELECT ROUND(hire_date) FROM EMP;C
SELECT sysdate-hire_date FROM EMP;D
SELECT TO_NUMBER(hire_date + 7) FROM EMP;
问题
单选题Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）A
No change is required to achieve the desired results.B
SELECT ename, sal, 12*(sal+100) FROM emp;C
SELECT ename, sal, (12*sal)+100 FROM emp;D
SELECT ename, sal+100,*12 FROM emp;
问题
单选题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;
问题
单选题Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）A
The DESCRIBE DEPT statement displays the structure of the DEPT table.B
The ROLLBACK statement frees the storage space occupies by the DEPT table.C
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.D
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
问题
多选题Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department_id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);CSELECT distinct department_id FROM employees WHERE salary ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);DSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);ESELECT last_name FROM employees WHERE salary ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);FSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
问题
多选题Which two statements are true about WHERE and HAVING clauses? （）AA WHERE clause can be used to restrict both rows and groups.BA WHERE clause can be used to restrict rows only.CA HAVING clause can be used to restrict both rows and groups.DA HAVING clause can be used to restrict groups only.EA WHERE clause CANNOT be used in a query if the query uses a HAVING clause.FA HAVING clause CANNOT be used in subqueries.
问题
单选题Which operator can be used with a multiple-row subquery?（）A
=B
LIKEC
BETWEEND
NOT INE
ISF
问题
多选题Which two are attributes of iSQL*Plus? （）A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accessed from a browser.C/SQL*Plus commands are used to manipulate data in tables.D/SQL*Plus commands manipulate table definitions in the database.E/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
问题
多选题Which two statements complete a transaction?（）ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVEPOINT C;DGRANT SELECT ON employees TO SCOTT;EALTER TABLE employees SET UNUSED COLUMN sal;FSelect MAX(sal) FROM employees WHERE department_id = 20;