移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 In which scenario would index be most useful?()

A

The indexed column is declared as NOT NULL.

B

The indexed columns are used in the FROM clause.

C

The indexed columns are part of an expression.

D

The indexed column contains a wide range of values.

多选题 Which two are character manipulation functions? ()

A

TRIM

B

REPLACE

C

TRUNC

D

TO_DATE

E

MOD

F

CASE

单选题 The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?()

A

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';

B

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

C

SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;

D

SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

单选题 Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?()

A

SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

B

SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

C

SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

D

SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;

E

SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

单选题 You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?()

A

CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;

B

CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;

C

GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

多选题 What are two reasons to create synonyms?()

A

You have too many tables.

B

Your tables are too long.

C

Your tables have difficult names.

D

You want to work on your own tables.

E

You want to use another schema's tables.

F

You have too many columns in your tables.

单选题 Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set?()

A

The DESCRIBE DEPT statement displays the structure of the DEPT table.

B

The ROLLBACK statement frees the storage space occupies by the DEPT table.

C

The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

D

The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

单选题 You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?()

A

ALTER TABLE commercials MODIFY (description CHAR2(1000));

B

ALTER TABLE commercials CHANGE (description CHAR2(1000));

C

ALTER TABLE commercials CHANGE (description VARCHAR2(1000));

D

ALTER TABLE commercials MODIFY (description VARCHAR2(1000));

E

You cannot increase the size of a column if the table has rows.

单选题 Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. 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 the 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 than 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

最新资讯

首页 上一页 1 2 3 4 5 下一页 尾页 /

到第