搜索博文结果_ChinaUnix博客

博客首页博客专家往日推荐博客文集

热搜：服务器 Java LINUX WINDOWS HADOOP 高性能 CCNA FTP

博客首页〉搜索结果

按类别查询搜索结果

操作系统程序设计数据库热点技术综合架构与运维移动开发与应用 Web前端

关于关键词的检测结果，共 2020 条

【Oracle】 ocp 19c考题，科目082考试题(23)- space management within blocks managed ASSM

unix_5030 | 2022-02-14 16:32:37 | 阅读(250) | 评论(0)

23、Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)A. PCTFREE defaults to 10% for all blocks in all segments for all compression methodsB. ASSM assigns blocks to one of four fullne...【阅读全文】

【Oracle】 ocp 19c考题，科目082考试题(22)- drop columns

unix_5030 | 2022-02-10 15:20:30 | 阅读(280) | 评论(0)

22、Choose threeWhich three are true about dropping columns from a table?A) A column can be removed only if it contains no data.B) A column drop is implidtly committedC) A column that is referenced by another column in any other table cannot be dropped.D) A column must be set ...【阅读全文】

【Oracle】 oracle ocp 19c考题，科目082考试题(21)-read-only table

unix_5030 | 2022-01-26 16:42:33 | 阅读(400) | 评论(0)

21、Choose threeExamine 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 DATERows exist in this table with data...【阅读全文】

【Oracle】 ocp 19c考题，科目082考试题(16)-about dropping and unused columns

unix_5030 | 2022-01-19 14:24:57 | 阅读(220) | 评论(0)

16.Which three statements are true about dropping and unused columns in an Oracle database?(Choose three.)A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.B. An UNUSED column’s space is reclaimed automatically when the bloc...【阅读全文】

【Oracle】 ocp 19c考题，科目082考试题(13)-variable prompt

unix_5030 | 2022-01-13 17:43:23 | 阅读(200) | 评论(0)

13.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?...【阅读全文】

【Oracle】 ocp 19c考题，科目082考试题(12)-about self-join

unix_5030 | 2022-01-11 14:58:50 | 阅读(200) | 评论(0)

12.Which three statements are true about a self-join? (Choose three.)A. The ON clause must be usedB. The query must use two different aliases for the tableC. It must be an equi joinD. It must be an inner joinE. The ON clause can be usedF. It can be an outer join...【阅读全文】

【Oracle】 oracle ocp 19c考题11，科目082考试题 - about SET VERIFY ON command

unix_5030 | 2022-01-07 14:01:47 | 阅读(390) | 评论(0)

11.Which two statements are true about the SET VERIFY ON command? (Choose two.)A. It can be used only in SQL*PlusB. It displays values for variables used only in the WHERE clause of a queryC. It can be used in SQL Developer and SQL*PlusD. It displays values for variables created ...【阅读全文】

【Oracle】 oracle ocp 19c考题10，科目082考试题 - shared server dispatchers

unix_5030 | 2022-01-06 10:23:47 | 阅读(340) | 评论(0)

10.Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)A. writing inbound request to the common request queue from all shared server connectionsB. checking for outbound shared server responses on the common outbound response queueC. re...【阅读全文】

【Oracle】 oracle ocp 19c考题8，科目082考试题-logical and physical database structures

unix_5030 | 2021-12-28 17:22:18 | 阅读(460) | 评论(0)

Which three statements are true concerning logical and physical database structures? (Choose three.)A. All tablespaces may have one or more data filesB. The extents of a segment must always reside in the same datafileC. A smallfile tablespace might be bigger than a bigfile tablespace...【阅读全文】

【Oracle】 oracle ocp 19c考题，科目082考试题-temporary undo

unix_5030 | 2021-12-23 14:36:21 | 阅读(450) | 评论(0)

5.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?A. in the undo tablespaceB. in the SYSAUX tablespaceC. in the SGAD. in the PGAE. in the temporary tablespaceS...【阅读全文】

【Oracle】 oracle ocp 19c考题，科目082考试题-Oracle Net

unix_5030 | 2021-12-21 17:49:17 | 阅读(2100) | 评论(0)

3.Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)A. Connect Time Failover requires the use of Transparent Application Failover (TAF)B. Source Routing requires the use of a name server...【阅读全文】

【Oracle】 oracle ocp 19c考题，科目082考试题-INTERSECT operator

unix_5030 | 2021-12-15 10:51:55 | 阅读(410) | 评论(0)

Oracle OCP 19c 认证1Z0-082考试题库(第2题)2.Which statement is true about the INTERSECT operator used in compound queries?A. Multiple INTERSECT operators are not possible in the same SQL statementB. It processes NULLs in the selected columnsC. INTERSECT is of lower precedence than...【阅读全文】

【Oracle】 ocp 19c考题，科目082考试题-bigfile

unix_5030 | 2021-12-14 17:15:54 | 阅读(370) | 评论(0)

CREATE BIGFILE TABLESPACE big_tbsSIZE 20G;Which two statements are true about the BIG_TBS tablespace? (Choose two.)B. It must be bigger than the largest SMALLFILE tablespaceD. It will be a dictionary-managed tablespace by default来源：cuug【阅读全文】

【Oracle】 ash占用sysaux过大，或其他占用过大，怎么处理

brjl | 2021-10-01 14:22:09 | 阅读(790) | 评论(0)