ocp-082_在线真题试卷与模拟练习_ocp-082

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Examine this command:

Which two statements are true? (Choose two.)

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

Examine the following command:

CREATE TABLE (

Prod_id number(4),

Prod_name varchar2 (20),

Category_id number(30),

Quantity_on_hand number (3) INVISIBLE);

Which three statements are true about using an invisible column in t he PRODUCTS table?

Evaluate the following ALTER TABLEstatement: ALTER TABLE orders SET UNUSED (order_date); Which statement is true?

choose the best Answer Evaluate the Following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement?

choose two: Examine the structure of the DEPARTMENTS table You execute the following command: SQL> ALTER TABLE departments SET UNUSED (country); Which two statements are true?

Choose three Examine this description of the PRODUCTS table: Name NULL? TYPE ------------------------------------------------------------------------ PROD_ID NOT NULL VARCHAR2(6) QUANTITY NUMBER(8,2) PRICE NUMBER(10.2) EXPIRY_DATE DATE Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only Mode. Which three commands execute successfully on PRODUCTS?

Choose three Which three are true about dropping columns from a table?

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose

Two.)

Which three instance situations are possible with the Oracle Database server without Multi-tenant? (Choose three.)

Which two statements are true about the ORDER BY clause when used with a SQL statement Containing a SET operator such as UNION? (Choose two.)

Evaluate the following SQL statement: SQL> select cust_id, cust_last_name "Last name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30 Identify three ORDER BY clauses either one of which can complete the query.

Which four account management capabilities can be configured using Oracle profiles? (Choose Four.)

choose one Which statement is true about profiles?

choose one Which statement is true about the DEFAULT profile?

Choose three. Examine these statements: ALTER SYSTEM SET RESOURCE_LIMIT=FALSE SCOPE=BOTH; System altered. CREATE PROFILE dev_users LIMIT SESSIONS_PER_USER 3 IDLE_TIME 10 FAILED LOGIN ATTEMPTS 3 PASSWORD_VERIFY_FUNCTION ora12c_verify_function; Profile altered. ALTER USER hr PROFILE dev_users; User altered. Which three are true about the effects of executing these statements?

A user establishes a connection to a database instance by using an Oracle Net connection. You

want to ensure the following:

1.The user account must be locked after five unsuccessful login attempts.

2.Data read per session must be limited for the user.

3.The user cannot have more than three simultaneous sessions.

4 The user must have a maximum of 10 minutes session idle time before being logged off

automatically.

How would you accomplish this?

You are administering a database and you receive a requirement to apply t he following

restrictions:

1 A connection must be terminated after four unsuccessful login attempts by user.

2 A user should not be able to create more than four simultaneous sessions.

3 User session must be terminated after 15 minutes of inactivity.

4 Users must be prompted to change their passwords every 15 days.

How would you accomplish these requirements?

In your database, you want to ensure that idle sessions that are blocking active are automatically Terminated after a specified period of time. How would you accomplish this?

Which three statements are true regarding single-row functions? (Choose three.)

1 2 3 4 5 6 17

更多题库