Oracle認(rèn)證考試章節(jié)練習(xí)(2020.02.16)

來源：考試資料網(wǎng)

1 The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?（）

點(diǎn)擊查看答案

2 Which statement describes the ROWID data type?（）

點(diǎn)擊查看答案

3 Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）

點(diǎn)擊查看答案

4 What is true about the WITH GRANT OPTION clause?（）

點(diǎn)擊查看答案

5 Multiple RMAN sessions are connected to the database instance.
Examine the following output when backup commands are running in server sessions:

What could have helped you to correlate server sessions with channels?（）

點(diǎn)擊查看答案

6 Given：

What is the result？（）

點(diǎn)擊查看答案

7 Which are the two options to which a menu can be assigned?（） (Choose two.)

點(diǎn)擊查看答案

8 數(shù)據(jù)處理技術(shù)通常分為以下（）類型。

點(diǎn)擊查看答案&解析

9 The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）

點(diǎn)擊查看答案

10 Development of real-time event-driven applications using Coherence is supported b（）

點(diǎn)擊查看答案