Examine the structure of the EMPLOYEES...

多项选择题 Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements inserts a row into the table? （）

A. INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
B. INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
C. INSERT INTO employees VALUES ('1000','JOHN','NULL');
D. INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
E. INSERT INTO employees (employee_id) VALUES (1000);
F. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which two statements are true about WHERE and HAVING clauses? （）

A. A WHERE clause can be used to restrict both rows and groups.
B. A WHERE clause can be used to restrict rows only.
C. A HAVING clause can be used to restrict both rows and groups.
D. A HAVING clause can be used to restrict groups only.
E. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
F. A HAVING clause CANNOT be used in subqueries.

点击查看答案

2.单项选择题In which case would you use a FULL OUTER JOIN?（）

A. Both tables have NULL values.
B. You want all unmatched data from one table.
C. You want all matched data from both tables.
D. You want all unmatched data from both tables.
E. One of the tables has more data than the other.
F. You want all matched and unmatched data from only one table.

点击查看答案

3.多项选择题 Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements inserts a row into the table? （）

点击查看答案

4.单项选择题 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.00
B. 17000*****
C. ****170.00
D. **17000.00
E. an error statement

点击查看答案

5.单项选择题 Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
NAME VARCHAR2 (60)
Which DELETE statement is valid?（）

A. DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
B. DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
C. DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
D. DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

点击查看答案

6.多项选择题 Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10,40)
ORSER BY dept_name;
The statement fails when executed. Which change fixes the error?（）

A. remove the ORDER BY clause
B. remove the table alias prefix from the WHERE clause
C. remove the table alias from the SELECT clause
D. prefix the column in the USING clause with the table alias
E. prefix the column in the ORDER BY clause with the table alias
F. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

点击查看答案

7.多项选择题Which three statements about subqueries are true? （）

A. A main query can have more than one subquery.
B. A subquery can have more than one main query.
C. The subquery and main query must retrieve data from the same table.
D. The subquery and main query can retrieve data from different tables.
E. Only one column or expression can be compared between the subquery and main query.
F. Multiple columns or expression can be compared between the subquery and main query.

点击查看答案

8.单项选择题 EXHIBIT, Emp Table

Exhibit A

Exhibit B

Examine the data from the EMP table.
Evaluate this SQL statement:
SELECT *
FROM emp
WHERE emp _ id = 3);
WHERE commission = (SELECT commission
FROM emp
What is the result when the query is executed?（）

A. Exhibit A
B. Exhibit B
C. The query returns no rows
D. The query fails because the outer query is retrieving more than one column
E. The query fails because both the inner and outer queries are retrieving data from the same table.

点击查看答案

9.多项选择题Which two statements about creating constraints are true?（）

A. Constraint names must start with SYS_C
B. All constraints must be defines at the column level
C. Constraints can be created after the table is created
D. Constraints can be created at the same time the table is created
E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

点击查看答案

10.单项选择题For which action can you use the TO_DATE function?（）

A. Convert any date literal to a date
B. Convert any numeric literal to a date
C. Convert any character literal to a date
D. Convert any date to a character literal
E. Format '10-JAN-99' to 'January 10 1999'

点击查看答案