当前分类： 1Z0-007
问题：单选题The STUDENT_GRADES table has these columns STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?（）A SELECT student_id, gpa FROM student_g...
查看答案
问题：单选题Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE stateme...
问题：单选题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 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....
问题：单选题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 ...
问题：单选题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 are iSQL*Plus commands? （）A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME...
问题：多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题：Evaluate these two SQL statements:SELECT last_name, salary,...
问题：单选题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 ...
问题：Click the Exhibit button and examine the data from the ORDER...
问题：单选题In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）A Immediately after the SELECT clauseB Before the WHERE clauseC Before the FROM clauseD After the ORDER BY clauseE After the WHERE clause...
问题：单选题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 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 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 DROP TABLE DEPT: Which four state...
问题：多选题Which three are DATETIME data types that can be used when specifying column definitions? （）ATIMESTAMPBINTERVAL MONTH TO DAYCINTERVAL DAY TO SECONDDINTERVAL YEAR TO MONTHETIMESTAMP WITH DATABASE TIMEZONE...
