问题:The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4)...
查看答案
问题:多选题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...
问题:Examine the description of the EMPLOYEES table: EMP_ID NUMBE...
问题:Which SQL statement would you use to remove a view called EM...
问题:单选题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 constraint can be defined only at the column level?()...
问题:多选题Which four are types of functions available in SQL? ()AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题:The STUDENT_GRADES table has these columns: STUDENT_ID NUMBE...
问题:Which four are correct guidelines for naming database tables...
问题:单选题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,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?()A Selection, p...
问题:多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMEN...
问题:单选题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 ORDERS table has these columns: ORDER_ID NUMBER(4) NOT N...
问题:Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
问题:Which object privileges can be granted on a view?()...
问题:Evaluate the SQL statement DROP TABLE DEPT: Which four state...
问题:单选题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...