当前分类： 1Z0-007
问题：Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
查看答案
问题：单选题Which /SQL*Plus feature can be used to replace values in the WHERE clause?（）A Substitution variablesB Replacement variablesC Prompt variablesD Instead-of variablesE This feature cannot be implemented through /SQL*Plus...
问题：单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）A SELECT ename, salary*12 ‘Annual Salary’ FROM employees;B SELECT ename, salary*12 “Annual Salary” FROM employees;C SELECT ename, salary*12 AS Annual Salary FRO...
问题：Which are /SQL*Plus commands? （）...
问题：单选题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...
问题：多选题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-...
问题：单选题For which action can you use the TO_DATE function?（）A Convert any date literal to a dateB Convert any numeric literal to a dateC Convert any character literal to a dateD Convert any date to a character literalE Format '10-JAN-99' to 'January 10 1999'...
问题：多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题：Evaluate the SQL statement DROP TABLE DEPT: Which four state...
问题：单选题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...
问题：单选题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...
问题：Which two statements accurately describe a role?（）...
问题：单选题Which is an iSQL*Plus command? （）A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME...
问题：What is true regarding subqueries?（）...
问题：单选题Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）A The DESCRIBE DEPT statement displays the structure of the DEPT table.B The ROLLBACK s...
问题：单选题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...
问题：单选题Which constraint can be defined only at the column level? （）A UNIQUEB NOT NULLC CHECKD PRIMARY KEYE FOREIGN KEY...
问题：Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 F...
问题：单选题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 ...
