当前分类： 1Z0-007
问题：Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
查看答案
问题：The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) P...
问题：单选题Evaluate the SQL statement:SELECT ROUND(45.953, -1), TRUNC(45.936, 2)FROM dual;Which values are displayed?（）A 46 and 45B 46 and 45.93C 50 and 45.93D 50 and 45.9E 45 and 45.93F 45.95 and 45.93...
问题：Evaluate the SQL statement DROP TABLE DEPT: Which four state...
问题：单选题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) POST...
问题：单选题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?（）A The two statements produce identical results.B ...
问题：In which case would you use a FULL OUTER JOIN?（）...
问题：多选题Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）AIt releases the storage space used by the table.BIt does not release the storage space used by the table.CYou can roll back the deletion of rows after the ...
问题：单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTM...
问题：单选题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, 'YYY') FROM dual;C SELECT TO...
问题：单选题What does the TRUNCATE statement do?（）A Removes the tableB Removes all rows from a tableC Shortens the table to 10 rowsD Removes all columns from a tableE Removes foreign keys from a table...
问题：单选题What does the FORCE option for creating a view do? （）A creates a view with constraintsB creates a view even if the underlying parent table has constraintsC creates a view in another schema even if you don't have privilegesD creates a view regardless of...
问题：单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view?（）A SELECT a.last_name, a.salary, a.department_...
问题：单选题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_...
问题：单选题Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A 0B 1C 0.00D An error statement...
问题：单选题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...
问题：多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题：多选题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-...
问题：单选题What is true regarding subqueries?（）A The inner query always sorts the results of the outer queryB The outer query always sorts the results of the inner queryC The outer query must return a value to the outer queryD The inner query returns a value to t...
