移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 A subquery can be used to ().

A

Create groups of data

B

Sort data in a specific order

C

Convert data to a different format

D

Retrieve data based on an unknown condition

单选题 Which SQL statement returns a numeric value?()

A

SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;

B

SELECT ROUND(hire_date) FROM EMP;

C

SELECT sysdate-hire_date FROM EMP;

D

SELECT TO_NUMBER(hire_date + 7) FROM EMP;

单选题 Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task? ()

A

SELECT student_ id, marks, ROWNUM Rank FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;

B

SELECT student_id, marks, ROWID Rank FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;

C

SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;

D

SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM <= 10;

E

SELECT student id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';

单选题 What is true about sequences?()

A

Once created, a sequence belongs to a specific schema.

B

Once created, a sequence is linked to a specific table.

C

Once created, a sequence is automatically available to all users.

D

Only the DBA can control which sequence is used by a certain table.

E

Once created, a sequence is automatically used in all INSERT and UPDATE statements.

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

A

TRIM

B

REPLACE

C

TRUNC

D

TO_DATE

E

MOD

F

CASE

单选题 Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER 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.

多选题 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',);

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

最新资讯

1 2 3 4 5 下一页 尾页 /

到第