当前分类： 1Z0-007
问题：多选题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...
查看答案
问题：单选题A data manipulation language statement （）.A completes a transaction on a tableB modifies the structure and data in a tableC modifies the data but not the structure of a tableD modifies the structure but not the data of a table...
问题：In which scenario would TOP N analysis be the best solution?...
问题：单选题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 types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题：单选题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-...
问题：单选题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...
问题：单选题The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）A SELECT EN...
问题：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 ...
问题：You need to change the definition of an existing table. The...
问题：The EMPLOYEES table contains these columns: LAST_NAME VARCHA...
问题：You need to design a student registration database that cont...
问题：单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is...
问题：Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
问题：单选题Which describes the default behavior when you create a table?（）A The table is accessible to all users.B Tables are created in the public schema.C Tables are created in your schema.D Tables are created in the DBA schema.E You must specify the schema whe...
问题：单选题Which syntax turns an existing constraint on? （）A ALTER TABLE table_name ENABLE constraint_name;B ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;C ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;D ALTER TABLE table_name ...
问题：单选题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...
