OCP考试082

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

Examine this command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true?

Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?

You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

choose one Examine the parameters for a database instance:

NAME TYPE VALUE

temp_undo_enabled boolean TRUE

undo_ management string AUTO

undo _retention Integer 900

undo _tablespace string UNDOTBS1

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

One of your databases supports an OLTP workload. The default undo tablespace is fixed size with: 1. RETENTION NOGUARANTEE 2. undo_retention is 12 minutes User scott get this error after a query on the sales table has run for more than 15 minutes: ORA-01555: snapshot too old Which three factors taken separately or in some combination might be the cause?

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed. Rows exist for employees 100 and 200. Examine this statement: Which two statements are true? (Choose two.)

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

choose three Which three statements are true about time zones,date data types,and timestamp data types in an oracle database?

Choose three. Which three statements are true about CURRENT_TIMESTAMP?

Which three statements are true about inner and outer joins? (Choose three.)

Examine this description of the TRANSACTIONS table: Which two SQL statements execute successfully? (Choose two.)

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)

View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers. Customers with no credit limit should have “Not Available” displayed. Which SQL statement would produce the required result?

Which statement is true about aggregate functions?

Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

1 3 4 5 6 7 16

更多题库