当前分类： 1Z0-007
问题：单选题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)...
查看答案
问题：单选题Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPAR...
问题：单选题Which object privileges can be granted on a view? （）A noneB DELETE, INSERT,SELECTC ALTER, DELETE, INSERT, SELECTD DELETE, INSERT, SELECT, UPDATE...
问题：单选题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...
问题：多选题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...
问题：Which three are DATETIME data types that can be used when sp...
问题：多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the...
问题：单选题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_...
问题：单选题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...
问题：多选题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...
问题：单选题You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?（）A SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;B SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;C SELECT T...
问题：单选题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...
问题：多选题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...
问题：单选题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...
问题：单选题Which syntax turns an existing constraint on?（）A ALTER TABLE table_name ENABLE constraint_name;B ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;C ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;D ALTER TABLE table_name T...
问题：单选题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....
问题：单选题What is true of using group functions on columns that contain NULL values?（）A Group functions on columns ignore NULL values.B Group functions on columns returning dates include NULL values.C Group functions on columns returning numbers include NULL val...
问题：多选题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 ...
问题：Which two are attributes of /SQL*Plus? （）...
问题：单选题You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMEN...
