问题：单选题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 whether or not the base tables exist
查看答案
问题：单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）A Use the DESCRIBE command in the EMP_DEPT VU view.B Use the DEFINE VIEW command on the EMP_DEPT VU view.C Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
问题：单选题You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A MERGEB INSERTC UPDATED ADDE ENTERF You cannot enter the phone numbers for the existing employee records.
问题：多选题Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）AYou cannot roll back this statement.BAll pending transactions are committed.CAll views based on the DEPT table are deleted.DAll indexes based on the DEPT table are dropped.EAll data in the table is deleted, and the table structure is also deleted.FAll data in the table is deleted, but the structure of the table is retained.GAll synonyms based on the DEPT table are deleted.
问题：单选题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 The second statement returns a syntax error.C There is no need to specify DESC because the results are sorted in descending order by default.D The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
问题：单选题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) Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）A SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;B SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';C SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;D SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;E SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
问题：单选题You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）A CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );B CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );C CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );D CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );E CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );F CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );
问题：多选题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-Z, a-z, 0-9, _, $, and #.FMust begin with a letter.
问题：单选题A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?（）A difference, projection, joinB selection, projection, joinC selection, intersection, joinD intersection, projection, joinE difference, projection, product
问题：单选题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
问题：多选题Which two statements about sequences are true? （）AYou use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.BYou use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.CYou use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.DYou use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.EIf a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.FYou use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
问题：单选题Which is an /SQL*Plus command?（）A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME
问题：单选题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
问题：单选题Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A 17000.00B 17000*****C ****170.00D **17000.00E an error statement
问题：多选题Which two statements complete a transaction?（）ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVEPOINT C;DGRANT SELECT ON employees TO SCOTT;EALTER TABLE employees SET UNUSED COLUMN sal;FSelect MAX(sal) FROM employees WHERE department_id = 20;
问题：单选题Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement?（）A The statement produces an error at line 1.B The statement produces an error at line 3.C The statement produces an error at line 6.D The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.E The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
问题：多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion
问题：单选题The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results? （）A SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;B SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;C SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;D SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
问题：单选题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) 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) = franceB 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%
