当前分类: 1Z0-007
问题:Examine the structures of the EMPLOYEES and TAX tables. EMPL...
查看答案
问题:单选题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 two are attributes of /SQL*Plus? ()...
问题:Which two statements about creating constraints are true? ()...
问题:单选题Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()A USER_TAB_PRIVS_MADEB USER_TAB_PRIVSC USER_COL_PRIVS_MADED USER_COL_PRIVS...
问题:多选题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...
问题:Which two statements about sequences are true? ()...
问题:单选题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_...
问题:单选题What is true about joining tables through an equijoin?()A You can join a maximum of two tables through an equijoin.B You can join a maximum of two columns through an equijoin.C You specify an equijoin condition in the SELECT or FROM clauses of a SELECT...
问题:Which three statements correctly describe the functions and...
问题:What are two reasons to create synonyms?()...
问题:What is true about the WITH GRANT OPTION clause?()...
问题:单选题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...
问题:多选题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...
问题:单选题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)...
问题:You created a view called EMP_DEPT_VU that contains three co...
问题:单选题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 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...
问题:单选题EMPLOYEES and DEPARTMENTS data: EMPLOYEES DEMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_I 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith ...