问题:Which two statements about views are true? ()...
查看答案
问题:Evaluate the SQL statement DROP TABLE DEPT: Which four state...
问题:Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...
问题:The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4)...
问题:单选题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 ...
问题:单选题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...
问题:单选题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...
问题:单选题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: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?()A 0B 1C 0.00D An error statement...
问题:单选题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...
问题:单选题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 ...
问题:多选题Which four are types of functions available in SQL? ()AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题:You would like to display the system date in the format "Mon...
问题:Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
问题:多选题Which two statements are true about WHERE and HAVING clauses? ()AA WHERE clause can be used to restrict both rows and groups.BA WHERE clause can be used to restrict rows only.CA HAVING clause can be used to restrict both rows and groups.DA HAVING claus...
问题:多选题From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for ().AUpdatingBViewingCDeletingDInsertingETruncating...
问题:Which four are correct guidelines for naming database tables...
问题:You need to create a view EMP_VU. The view should allow the...
问题:The EMP table contains these columns: LAST_NAME VARCHAR2 (25...