当前分类： 1Z0-007
问题：单选题In which scenario would an index be most useful?（）A The indexed column is declared as NOT NULL.B The indexed columns are used in the FROM clause.C The indexed columns are part of an expression.D The indexed column contains a wide range of values....
查看答案
问题：单选题Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SEL...
问题：单选题The STUDENT_GRADES table has these columns: 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;B SELECT (gpa)...
问题：多选题Which three statements correctly describe the functions and use of constraints? （）AConstraints provide data independence.BConstraints make complex queries easy.CConstraints enforce rules at the view level.DConstraints enforce rules at the table level.E...
问题：单选题The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）A SELECT employee_id, last_name, job_...
问题：多选题Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY departme...
问题：单选题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) Which statement produces the number of different departments that have employees with last name Smith?（）...
问题：多选题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 databas...
问题：单选题What is necessary for your query on an existing view to execute successfully?（）A The underlying tables must have data.B You need SELECT privileges on the view.C The underlying tables must be in the same schema.D You need SELECT privileges only on the u...
问题：You want to display the titles of books that meet these crit...
问题：多选题Which two are attributes of iSQL*Plus? （）AiSQL*Plus commands cannot be abbreviated.BiSQL*Plus commands are accessed from a browser.CiSQL*Plus commands are used to manipulate data in tables.DiSQL*Plus commands manipulate table definitions in the databas...
问题：多选题Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? （）AYou cannot roll back this statement.BAll pending transactions are committed.CAll views based on the DEPT table are deleted.DAll indexes based on the DEP...
问题：多选题Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error?（）Aremove the...
问题：Examine the description of the EMPLOYEES table: EMP_ID NUMBE...
问题：单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A SELECT 1, 2 FROM 3 WHERE last_name = '8';B SELECT 1, '2' FROM 3 WHERE ' last_name = '8';C SELECT 1, 2 FROM 3 WHERE last_name = '8';D SELECT...
问题：The DBA issues this SQL command: CREATE USER scott IDENTIFIE...
问题：多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENT...
问题：单选题Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? （）A SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;B SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;C SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM...
问题：Which two are attributes of /SQL*Plus? （）...
