1 解决

11 浏览

• tomding 2021-02-23

Which two statements are true about a self join?

OCP-082

1 解决

60 浏览

• zhy158 2021-02-23

Which three statements are true about an SPFILE?

OCP-082

1 解决

124 浏览

• 颖颖就要嘤嘤嘤 2021-02-23

Which three statements are true about Data Manipulation Language(DML)?

OCP-082

1 解决

87 浏览

• 867220 2021-02-23

Which two statements are true about unexpired undo?

OCP-082

1 解决

40 浏览

• ko1010000 2021-02-23

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

OCP-082

1 解决

101 浏览

• 你的小公举 2021-02-23

Which three statements are true about Resumable Space Allocation in Oracle databases?

OCP-082

1 解决

59 浏览

• 信仰。 2021-02-23

You execute this command: CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/oracle/data/big_fl.dbfl' ESIZE 20G; Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG TBS tablespace?

OCP-082

1 解决

88 浏览

• eggyy 2021-02-23

Which three are benefits of using temp UNDO when performing DML on global temporary tables?

OCP-082

1 解决

132 浏览

• 萧萧 2021-02-23

Which three files are used by conventional path SOL*Loader when the TABLE option is not specified?

OCP-082

1 解决

171 浏览

• 白衣素袖 2021-02-23

Which three statements are true about performing DML operations on a view with nO INSTEAD OF triggers defined?

OCP-082

1 解决

119 浏览

• black97 2021-02-23

Which three statements are true about dynamic performance views?

OCP-082

1 解决

163 浏览

• 别跟我提钱 2021-02-23

Which two are true about transactions in the Oracle Database?

OCP-082

1 解决

81 浏览

• hxc 2021-02-23

Examine this query: SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL; What is the result?

OCP-082

1 解决

186 浏览

• guml 2021-02-23

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?

OCP-082

1 解决

174 浏览

• fengshan 2021-02-23

Examine the structure of the two tables: PRODUCTS Name Nul1? Type ------------------------------------ PROD_ID CHAR(2) PROD_NAME CHAR(4) EXP_DATE TIMESTAMP(6) -- NEW_PRODUCTS: Name Nul1? Type ------------------------------------ PROD_ID CHAR(2) PROD_NAME CHAR(4) EXP_DATE TIMESTAMP(6) Which two queries execute successfully?

OCP-082

1 解决

187 浏览

• 抹茶小姐姐 2021-02-23

The PRODUCT INFORMATION table has a UNIT_PRICE column of data type NUMBER(8,2). Evaluate this SQL statement: SELECT TO_CHAR(unit_price,'$9,999') FROM PRODUCT_INFORMATION; Which two statements are true about the output?

OCP-082

1 解决

152 浏览

• 退役熬夜冠军 2021-02-23

Examine this query: SELECT employee id,first name,salary FROM employees WHERE hire date > &1; Which two methods should you use to prevent prompting for a hire date value when this query is executed?

OCP-082

1 解决

153 浏览

• hhh 2021-02-23

Choose two Examine the data in the CUST NAME column of the CUSTOMERS table: CUST NAME Renske Ladwi Jason Mallin Samuel McCain Allan MCEwen Irene Mikkilineni zulia Nayer You want to display the CUST NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result?

OCP-082

1 解决

73 浏览

• wknu 2021-02-23

You issued this command: DROP TABLE hr.employees; Which three statements are true?

OCP-082

1 解决

87 浏览

• ToopBook 2021-02-23

Which four activities can be performed using SQL Developer?

OCP-082