Which two are character manipulation f...

多项选择题Which two are character manipulation functions? （）

A.TRIM
B.REPLACE
C.TRUNC
D.TO_DATE
E.MOD
F.CASE

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 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, projection, join
B. Difference, projection, join
C. Selection, intersection, join
D. Intersection, projection, join
E. Difference, projection, product

点击查看答案

2.单项选择题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.

点击查看答案

3.单项选择题You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?（）

A. SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
B. SELECT last_name FROM EMP WHERE last name ='*A%'
C. SELECT last_name FROM EMP WHERE last name ='_A%';
D. SELECT last_name FROM EMP WHERE last name LIKE '*A%'

点击查看答案

4.多项选择题 The ORDERS table has these columns:

The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars?（）

A. SELECT customer_id, order_id, order_total   FROM orders   RANGE ON order_total (100 AND 2000) INCLUSIVE;
B. SELECT customer_id, order_id, order_total   FROM orders   HAVING order_total BETWEEN 100 and 2000;
C. SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total BETWEEN 100 and 2000;
D. SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total >= 100 and <= 2000;
E. SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total >= 100 and order_total <= 2000;

点击查看答案

5.单项选择题 Examine the data from the ORDERS and CUSTOMERS tables.
ORDERS
ORD_ID ORD_DATE CUST_ID
12-JAN-
100 15 10000
09-MAR-
101 40 8000
09-MAR-
102 35 12500
15-MAR-
103 15 12000
25-JUN-
104 15 6000
18-JUL-
105 20 5000
106 18-JUL- 35 7000
21-JUL-
107 20 6500
04-AUG-
109 10 8000
CUSTOMERS
CUST_ID CUST_NAME CITY
10 Smith Los Angeles
15 Bob San Francisco
20 Martin Chicago
25 Mary New York
30 Rina Chicago
35 Smith New York
40 Lind New York
Evaluate the SQL statement:
SELECT *
FROM orders
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_name = 'Smith');
What is the result when the query is executed?（）

A. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000
B. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000
C. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000
D. The query fails because the subquery returns more than one row.
E. The query fails because the outer query and the inner query are using different tables.

点击查看答案

6.单项选择题 Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.
EMPLOYEES
NOT NULL, Primary
EMPLOYEE_ID NUMBER
Key
VARCHAR2
EMP_NAME
(30)
VARCHAR2
JOB_ID
(20)
SALARY NUMBER
References
MGR_ID NUMBER
EMPLOYEE_ID
column
DEPARTMENT_ID NUMBER Foreign key to
DEPARTMENT_ID
column of
the DEPARTMENTS
table
DEPARTMENTS
NOT NULL,
DEPARTMENT_ID NUMBER
Primary Key
VARCHAR2
DEPARTMENT_NAME
|30|
References
MGR_ID column
MGR_ID NUMBER
of the
EMPLOYEES table
TAX
MIN_SALARY NUMBER
MAX_SALARY NUMBER
TAX_PERCENT NUMBER
For which situation would you use a nonequijoin query?（）

A. To find the tax percentage for each of the employees.
B. To list the name, job id, and manager name for all the employees.
C. To find the name, salary, and department name of employees who are not working with Smith.
D. To find the number of employees working for the Administrative department and earning less then 4000.
E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

点击查看答案

7.单项选择题 The STUDENT_GRADES table has these columns:

The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）

A. SELECT student_id, semester_end, gpa   FROM student_grades   ORDER BY semester_end DESC, gpa DESC;
B. SELECT student_id, semester_end, gpa   FROM student_grades   ORDER BY semester_end ASC, gpa ASC;
C. SELECT student_id, semester_end, gpa   FROM student_grades   ORDER BY semester_end, gpa DESC;
D. SELECT student_id, semester_end, gpa   FROM student_grades   ORDER BY gpa DESC, semester_end DESC;
E. SELECT student_id, semester_end, gpa   FROM student_grades   ORDER BY gpa DESC, semester_end ASC;

点击查看答案

8.单项选择题Which operator can be used with a multiple-row subquery?（）

A. =
B. LIKE
C. BETWEEN
D. NOT IN
E. IS
F. <>

点击查看答案

9.单项选择题 Examine the structure of the EMPLOYEES table:
Column name Data type Remarks
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
LAST_NAME VARCNAR2(30)
FIRST_NAME VARCNAR2(30)
JOB_ID NUMBER
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER
You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）

A. CREATE INDEX NAME _IDX (first_name, last_name);
B. CREATE INDEX NAME _IDX (first_name, AND last_name)
C. CREATE INDEX NAME_IDX ON (First_name, last_name);
D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);
F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

点击查看答案

10.多项选择题Which four are correct guidelines for naming database tables? （）

A. Must begin with either a number or a letter.
B. Must be 1-30 characters long.
C. Should not be an Oracle Server reserved word.
D. Must contain only A-Z, a-z, 0-+, _, *, and #.
E. Must contain only A-Z, a-z, 0-9, _, $, and #.
F. Must begin with a letter.

点击查看答案