当前分类： 1Z0-007
问题：单选题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...
查看答案
问题：Evaluate this SQL statement: SELECT e.employee_id, (.15* e.s...
问题：多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题：单选题Which are iSQL*Plus commands? （）A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME...
问题：多选题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 ...
问题：Evaluate the SQL statement DROP TABLE DEPT: Which four state...
问题：单选题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 ...
问题：Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...
问题：单选题You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employe...
问题：单选题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 ...
问题：单选题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...
问题：单选题Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）A The SELECT statement is syntactically accu...
问题：Evaluate these two SQL statements: SELECT last_name, salary...
问题：单选题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...
问题：多选题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-...
问题：单选题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: 1 SELECT a.emp_name, a.sal, a.de...
问题：单选题Which operator can be used with a multiple-row subquery?（）A =B LIKEC BETWEEND NOT INE ISF...
问题：单选题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...
