OCP19C-82

Which two statements are true? (Choose two.)

发布于 2021-04-25 04:04:28

【多选题】
A DML may be performed on tables with one or more extents in this data file during the execution of this command.
B The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
C The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
D If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
E The file is renamed and stored in the same location

关注者

0

被浏览

92

y0000z 2023-04-25

这家伙很懒，什么也没写！

此回答被采纳为最佳答案，开通VIP会员可查看

1 个回答

撰写答案

请登录后再发布答案，点击登录

关于作者

京东小含

这家伙很懒，什么也没写！

提问

回答

1354

被采纳

1289

关注TA

发私信

相关问题

1

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?

2

You have been tasked to create a table for a banking application. One of the columns must meet three requirements: Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

3

7.In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Which statement is true?

4

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed. The variables used in your query are never undefined in your session. Which query can be used?

5

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Which query can be used?

6

(Choose three.)

7

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?

8

ALTER TABLE orders SET UNUSED (order_date); Which statement is true?

9

ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement?

10

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

发布
问题

手机
浏览

扫码手机浏览

在线
客服