当前分类: 1Z0-007
问题:Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
查看答案
问题:单选题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 DROP TABLE DEPT: Which four state...
问题:Which four are correct guidelines for naming database tables...
问题:单选题Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign ...
问题:多选题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...
问题:单选题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(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...
问题:多选题Which two statements about subqueries are true? ()AA single row subquery can retrieve data from only one table.BA SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's F...
问题:Which SQL statement would you use to remove a view called EM...
问题:Which are iSQL*Plus commands? ()...
问题:单选题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)...
问题:单选题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 statement describes the ROWID data type? ()A Binary data up to 4 gigabytes.B Character data up to 4 gigabytes.C Raw binary data of variable length up to 2 gigabytes.D Binary data stored in an external file, up to 4 gigabytes.E A hexadecimal strin...
问题:单选题Which operator can be used with a multiple-row subquery? ()A =B LIKEC BETWEEND NOT INE ISF...
问题:单选题What does the FORCE option for creating a view do? ()A creates a view with constraintsB creates a view even if the underlying parent table has constraintsC creates a view in another schema even if you don't have privilegesD creates a view regardless of...
问题:Which SQL statement generates the alias Annual Salary for th...