移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 Which view should a user query to display the columns associated with the constraints on a table owned by the user?()

A

USER_CONSTRAINTS

B

USER_OBJECTS

C

ALL_CONSTRAINTS

D

USER_CONS_COLUMNS

E

USER_COLUMNS

单选题 You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. aDATE_ORDERED column to contain the date the order was placed. When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead. Which statement accomplishes this? ()

A

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

B

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

C

CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

D

CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

E

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);

F

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

单选题 Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?()

A

SELECT ename, salary*12 'Annual Salary' FROM employees;

B

SELECT ename, salary*12 Annual Salary FROM employees;

C

SELECT ename, salary*12 AS Annual Salary FROM employees;

D

SELECT ename, salary*12 AS INITCAP(ANNUAL SALARY) FROM employees

单选题 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 last_name ='Carrey');

多选题 Which three SELECT statements display 2000 in the format "$2,000.00"? ()

A

SELECT TO_CHAR(2000, '$#,###.##') FROM dual;

B

SELECT TO_CHAR(2000, '$0,000.00') FROM dual;

C

SELECT TO_CHAR(2000, '$9,999.00') FROM dual;

D

SELECT TO_CHAR(2000, '$9,999.99') FROM dual;

E

SELECT TO_CHAR(2000, '$2,000.00') FROM dual;

F

SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;

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

多选题 Which two statements about subqueries are true? ()

A

A subquery should retrieve only one row.

B

A subquery can retrieve zero or more rows.

C

A subquery can be used only in SQL query statements.

D

Subqueries CANNOT be nested by more than two levels.

E

A subquery CANNOT be used in an SQL query statement that uses group functions.

F

When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

单选题 What is true about updates through a view? ()

A

You cannot update a view with group functions.

B

When you update a view group functions are automatically computed.

C

When you update a view only the constraints on the underlying table will be in effect.

D

When you update a view the constraints on the views always override the constraints on the underlying tables.

多选题 Which three statements about subqueries are true?()

A

A single row subquery can retrieve only one column and one row.

B

A single row subquery can retrieve only one row but many columns.

C

A multiple row subquery can retrieve multiple rows and multiple columns.

D

A multiple row subquery can be compared by using the “>” operator.

E

A single row subquery can use the IN operator.

F

A multiple row subquery can use the “=” operator.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第