1Z0-007 题目列表
多选题Which four are correct guidelines for naming database tables? （）AMust begin with either a number or a letter.BMust be 1-30 characters long.CShould not be an Oracle Server reserved word.DMust contain only A-Z, a-z, 0-+, _, *, and #.EMust contain only A-Z, a-z, 0-9, _, $, and #.FMust begin with a letter.
单选题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) A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?（）AWHERE lower(country_address) = franceBWHERE lower(country_address) = 'france'CWHERE lower(country_address) IS 'france'DWHERE lower(country_address) = '%france%'EWHERE lower(country_address) LIKE %france%
单选题What does the TRUNCATE statement do?（）ARemoves the tableBRemoves all rows from a tableCShortens the table to 10 rowsDRemoves all columns from a tableERemoves foreign keys from a table
单选题Evaluate the SQL statement:SELECT ROUND(45.953, -1), TRUNC(45.936, 2)FROM dual;Which values are displayed?（）A46 and 45B46 and 45.93C50 and 45.93D50 and 45.9E45 and 45.93F45.95 and 45.93
单选题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) Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）ASELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;BSELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';CSELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;DSELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;ESELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
单选题Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A0B1C0.00DAn error statement
多选题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 DEPT table are dropped.EAll data in the table is deleted, and the table structure is also deleted.FAll data in the table is deleted, but the structure of the table is retained.GAll synonyms based on the DEPT table are deleted.
单选题Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEESORDER BY 2 DESC; What is true about them?（）AThe two statements produce identical results.BThe second statement returns a syntax error.CThere is no need to specify DESC because the results are sorted in descending order by default.DThe two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion
单选题Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl b. maxsal; What is the result of the statement?（）AThe statement produces an error at line 1.BThe statement produces an error at line 3.CThe statement produces an error at line 6.DThe statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.EThe statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
多选题Which two are attributes of /SQL*Plus? （）A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accesses 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.
单选题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?（）ASELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;BSELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;CSELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end;DSELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades;ESELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
单选题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?（）ASELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%'ESCAPE'/';BSELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';CSELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_'ESCAPE'/';DSELECT employee_id, last_name, job_id FROM employees WHERE job_id '%SA_';
多选题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.EConstraints prevent the deletion of a table if there are dependencies.FConstraints prevent the deletion of an index if there are dependencies.
多选题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 DEPT table are dropped.EAll data in the table is deleted, and the table structure is also deleted.FAll data in the table is deleted, but the structure of the table is retained.GAll synonyms based on the DEPT table are deleted.