082V1-201-300_在线真题试卷与模拟练习_082V1-201-300

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Choose the best answer.
Examine this statement which executes successfully:
（含图）
Which is true?

Choose the best answer. Your database instance is started with an SPFILE. -A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where is the value changed?

Choose the best answer. Which compression method is recommended for Direct-Path Insert operations?

Choose the best answer.
Examine the description of the SALES1 table:

（含图）
SALES2 is a table with the same description as SALES1.
Some sales data is contained erroneously in both tables.
You must display rows from SALES1 and SALES2 and wish to see the duplicates too.
Which set operator generates the required output?

Choose the best answer. Why would you use the TNSPING hr command?

Choose the best answer.
Examine this schema information:

（含图）
You must add a new column, MANAGER_ID, from the EMPLOYEES table, to the view, showing each employee's manager.
Which statement will do this?

Choose the best answer. You need to allow user ANDREW to: 1- Modify the TITLE and ADDRESS columns of your CUSTOMERS table. 2- GRANT that permission to other users. Which statement will do this?

Choose the best answer. Which statement is true about TRUNCATE and DELETE?

Choose the best answer. Table HR. EMPLOYEES contains a row where the EMPLOYEE_ID is 109. User ALICE has no privileges to access HR . EMPLOYEES. User ALICE starts a session. User HR starts a session and successfully executes these statements: GRANT DELETE ON employees TO alice; UPDATE employees SET salary = 24000 WHERE employee_id = 109; In her existing session ALICE then executes: DELETE FROM hr.employees WHERE employee_id = 109; What is the result?

Choose the best answer.
Examine the description of the EMPLOYEES table:

（含图）
Examine these requirements:
1- Display the last name, date of hire and the number of years of service for each employee.
2- If the employee has been employed 5 or more years but less than 10, display "5+ years of service".
3- If the employee has been employed 10 or more years but less than 15, display "10+ years of service".
4- If the employee has been employed 15 or more years, display "15+ years of service".
5- If none of these conditions matches, display "<5 years of service".
6- Sort the results by the HIRE_DATE column.
Which statement satisfies all the requirements?

Choose the best answer. User HR has CREATE SESSION, CREATE ANY TABLE and UNLIMITED TABLESPACE privileges. User SCOTT has CREATE SESSION, CREATE TABLE and UNLIMITED TABLESPACE privileges. HR successfully executes this statement: CREATE TABLE scott. products ( Prod_id NUMBER(2) , Prod_name VARCHAR2 (20)); HR attempts to execute: 1- INSERT INTO scott.products VALUES (1, 'LAPTOP') ; SCOTT attempts to execute: 2- SELECT ∗ FROM products; 3- INSERT INTO scott. products VALUES (2, 'HDD'); 4- CREATE SYNONYM prod FOR products; Which will execute successfully?

Choose the best answer.
Examine the data in the EMPLOYEES table:

（含图）
Which statement will compute the total annual compensation for each employee?

Choose the best answer. Which statement is true about using functions in WHERE and HAVING?

Choose two. Which two statements are true about UNDO and UNDO tablespaces?

Choose the best answer. As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes this command: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes this command: GRANT CREATE VIEW TO usr3; Which statement is true?

Choose the best answer.
Examine the description of the PRODUCTS table:

（含图）
Which query is valid?

The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted. you only want to display details of rows where START_DATE is within the last 25 months.
Which WHERE clause can be used?

Choose two.
Examine the description of the ORDER_ITEMS table:

（含图）
Examine this incomplete query:
SELECT DISTINCT quantity ∗ unit_price total_paid
FROM order_items
ORDER BY <clause>;
Which two can replace <clause> so the query completes successfully?

Choose two.
Examine the ORDER_ITEMS table:

（含图）
Which two queries return rows where QUANTITY is a multiple of ten?

Choose two.
You have been granted the CRE ATE ANY INDEX system privilege.
You want to create an index, owned by you, on a table in another schema to which you
Have been granted only the SELECT privilege.
Which two are true?

1 2 3 4 5