当前分类: 1Z0-007
问题:多选题Which four are types of functions available in SQL? ()AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
查看答案
问题:Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
问题:单选题Which statement accomplish this? ()A CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);B CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR...
问题:单选题You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMEN...
问题: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 ...
问题:单选题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...
问题:单选题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 are true about aggregate functions? ()...
问题:多选题Which two tasks can you perform using only the TO_CHAR function? ()Aconvert 10 to 'TEN'Bconvert '10' to 10Cconvert 10 to '10'Dconvert 'TEN' to 10Econvert a date to a character expressionFconvert a character expression to a date...
问题:单选题The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY...
问题:单选题Which operator can be used with a multiple-row subquery?()A =B LIKEC BETWEEND NOT INE ISF...
问题:单选题Which object privileges can be granted on a view? ()A noneB DELETE, INSERT,SELECTC ALTER, DELETE, INSERT, SELECTD DELETE, INSERT, SELECT, UPDATE...
问题:单选题Which is an /SQL*Plus command?()A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME...
问题:Which statement creates a new user?()...
问题:多选题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(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?()A 0B 1C 0.00D An error statement...
问题:Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...