A. no privileges B. only the SELECT privilege C. only the CONNECT privilege D. all the privileges of a default user
多项选择题Which two tasks can you perform using only the TO_CHAR function? ()
A. convert 10 to 'TEN' B. convert '10' to 10 C. convert 10 to '10' D. convert 'TEN' to 10 E. convert a date to a character expression F. convert a character expression to a date
单项选择题A data manipulation language statement ().
A. completes a transaction on a table B. modifies the structure and data in a table C. modifies the data but not the structure of a table D. modifies the structure but not the data of a table
单项选择题What does the FORCE option for creating a view do? ()
A. creates a view with constraints B. creates a view even if the underlying parent table has constraints C. creates a view in another schema even if you don't have privileges D. creates a view regardless of whether or not the base tables exist
单项选择题Which are iSQL*Plus commands? ()
A. INSERT B. UPDATE C. SELECT D. DESCRIBE E. DELETE F. RENAME
单项选择题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) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?()
A. WHERE lower(country_address) = "france" B. WHERE lower(country_address) = 'france' C. WHERE lower(country_address) IS 'france' D. WHERE lower(country_address) = '%france%' E. WHERE lower(country_address) LIKE %france%