Oracle 19c OCP 1Z0-082认证考试题库(51-60)

简介: .View the Exhibit and examine the description of the tables You execute this SQL statement Which three statements are true?

51.View the Exhibit and examine the description of the tables You execute this SQL statement


Which three statements are true?


A.The sales table has five foreign keys

B.The statement will execute successfully and a new row will be inserted into the SALES table

C.A product can have a different unit price at different times

D.A customer can exist in many countries.

E.The statement will fail if a row already exists in the SALES table for product 23

F. The statement will fail because a subquery may not be contained in a VALUES clause

答案: ABD


52.View the Exhibits and examine the structure of the costs and PROMOTIONS tables

You want to display prod_ids whose promotion cost is less than the highest cost prod_id in a promotion time interval

Examine this SQL statement


What will be the result?

A.It executes successfully and gives the required result.

B.It gives an error because the GROUP BY clause is not valid

C.It executes successfully but does not give the required result

D.It gives an error because the ALL keyword is not valid

答案: C

Prom_end_date-promo_begin_date不能保证产品在同一个时间段进行促销。


53.You must create a tablespace of non-standard block size in a new file system and plan to use this command


The standard block size is 8k but other non-standard block sizes will also be used

Which two are requirements for this command to succeed?

A.DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA

B.DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE

C.DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE

D.The operating system must use a 32k block size

E.DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE

F. The /u02 file system must have at least 100g space for the datafile

答案: AF


54.Which two statements are true about single row functions?

A.FLOOR: retums the smallest integer greater than or equal to a specified number

B.CEIL: can be used for positive and negative numbers

C.CONCAT: can be used to combine any number of values

D.TRUNC: can be used only with NUMBER data types

E.MOD: returns the remainder of a division operation

答案: BE

trunc可以用于日期


55.Examine the description of the PRODUCR STATUS table


The STATUS column contains the values ‘in stock’ or ‘OUT OF STOCK’ for each row

Which two queries will execute successfully?

A.SELECT prod_id || q ’ (‘s not available.’ from product status WHERE status = ‘OUT OF STOCK’

B.SELECT prod_id || q ’ (‘s not available.’ “CURRENT AVAILABILITY"FROM product status WHERE status = 'OUT OF STOCK ’

C.SELECT prod_id “CURRENT AVAILABILITY” || q ’ ('s not availablE.'from product status WHERE status = ‘OUT OF STOCK’

D.SELECT prod_id || q(‘s not availablE.’ 'current AVAILABILITY ’ FROM product status WHERE status = ‘OUT OF STOCK’

E.SELECT prod_id q 's not available” FROM product status WHERE status =“OUT OF STOCK”

F.SELECT prod_id || q" 's not available" FROM product_status WHERE status = ‘OUT OF STOCK’

答案: AB ???


56.Which two statements are true about Enterprise Manager(EM)Express?

A.By default, EM Express is available for a database after database creation using DBCA

B.You can shut down a database instance using EM Express.

C.EM Express uses a separate repository database to store target database metadata

D. You cannot start up a database instance using EM Express

E.You can use a single instance of EM Express to manage multiple databases running on the same server

答案: AD

EM Express 简化版的 em,只要用存储过程设置了端口号就可以访问。


57.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: LISTENER_1 =

(ADDRESS= (PROTOCOL= TCP)

(HOST =host1 abc. com) (PORT=1521)

)


Which statement is true?

A.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521on the same host as the database instances

B.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

C. LISTENER_1 must also be defined in the LISTENER. ORA file to enable dynamic service registration

D.The LREG process registers services dynamically with the LISTENER_1 listener E.Dynamic service registration cannot be used for this database instance

答案: A

local_listener时需要把定义增加到服务器端的tnsnames.ora中


58.Which two statements are true about UNDO and REDO?

A.The generation of UNDO generates REDO.

B.DML, modifies Oracle database objects and generates UNDO and REDO

C.DML modifies Oracle database objects and only generates UNDO.

D.The generation of REDO generates UNDO.

E.DML modifies Oracle database objects and only generates REDO


答案: AB

59.Examine the description of the CUSTOMERS table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000

Examine this partial query

SELECT cust_last_name, cust_credit_limit FROM customers

Which two WHERE conditions give the required result?

A.WHERE(INITCAP(cust_last_name) LIKE ‘A%’ OR INITCAP(cust_last_name) LIKE ‘B%’) AND cust_credit_limit < 1000

B.WHERE UPPER(cust_1ast_name IN (‘A%’, ‘B%’ ) AND cust_credit_limit < 1000

C.WHERE (UPPER(cust_last_name LIKE INITCAP(‘A’) OR UPPER(cust -Last-namE.LIKE INITCAP(‘B’))

AND ROUND(cust_credit_limit)< ROUND(1000);

D.WHERE( UPPER(cust_1ast_namE.LIKE 'A% OR UPPER(Cust_1ast_namE.LINK ‘B%’

AND ROUND(cust_credit_limit)< 1000

E.WHERE UPPER(cust_last_name) BETWEEN UPPER (‘A%’ AND ‘B%’ )

AND ROUND(cust_credit_limit)< 1000

答案: AD


60.Which two statements are true about the tools used to configure Oracle Net Services?


A.The lsnrctrl utility requires a listener. ora file to exist before it is started

B.The Oracle Net Configuration Assistant is only used when running the Oracle installer. C.Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

D.Oracle Net Manager can be used to centrally configure listeners on any database server target. E.Oracle Net Manager can be used to locally configure naming methods on a database server.

答案: C E


相关文章
|
2月前
|
Oracle 关系型数据库 网络安全
Oracle 19c 安装教程学习
Oracle 19c 安装教程学习
68 2
|
3月前
|
Oracle 关系型数据库 数据库
Oracle 19c OCP 认证考试 083 题库(第37题)- 2024年修正版
本文介绍Oracle 19c OCP认证题库中的1Z0-083科目,包含85道试题,需在150分钟内完成,通过分数为57%。重点解析了关于阈值、指标和警报的问题,并指出需通过Oracle指定的WDP机构培训后才能参加考试,考试科目包括082和083,通过后可获得OCP证书。CUUG作为金牌合作机构,提供详细咨询与帮助。
123 1
|
3月前
|
SQL Oracle 关系型数据库
Oracle 19c OCP 认证考试 082 题库(第26题)- 2024年修正版
这是关于Oracle 19c OCP认证考试(1Z0-082)的题库,包含90道题目,通过分数为60%,考试时间为150分钟。本文由CUUG原创整理,重点解析了全球临时表的特点和相关操作,并提供了正确答案及详细解释,帮助考生更好地理解和备考。
49 2
|
2月前
|
存储 Oracle 关系型数据库
Oracle数据库的应用场景有哪些?
【10月更文挑战第15天】Oracle数据库的应用场景有哪些?
185 64
|
4月前
|
存储 自然语言处理 Oracle
Oracle数据库字符集概述及修改方式
【8月更文挑战第15天】Oracle 数据库字符集定义了数据的编码方案,决定可存储的字符类型及其表示方式。主要作用包括数据存储、检索及跨系统传输时的正确表示。常见字符集如 AL32UTF8 支持多语言,而 WE8MSWIN1252 主用于西欧语言。修改字符集风险高,可能导致数据问题,需事先备份并评估兼容性。可通过 ALTER DATABASE 语句直接修改或采用导出-导入数据的方式进行。完成后应验证数据完整性。此操作复杂,须谨慎处理。
|
3天前
|
存储 Oracle 关系型数据库
数据库数据恢复—ORACLE常见故障的数据恢复方案
Oracle数据库常见故障表现: 1、ORACLE数据库无法启动或无法正常工作。 2、ORACLE ASM存储破坏。 3、ORACLE数据文件丢失。 4、ORACLE数据文件部分损坏。 5、ORACLE DUMP文件损坏。
33 11
|
4月前
|
数据采集 Oracle 关系型数据库
实时计算 Flink版产品使用问题之怎么实现从Oracle数据库读取多个表并将数据写入到Iceberg表
实时计算Flink版作为一种强大的流处理和批处理统一的计算框架,广泛应用于各种需要实时数据处理和分析的场景。实时计算Flink版通常结合SQL接口、DataStream API、以及与上下游数据源和存储系统的丰富连接器,提供了一套全面的解决方案,以应对各种实时计算需求。其低延迟、高吞吐、容错性强的特点,使其成为众多企业和组织实时数据处理首选的技术平台。以下是实时计算Flink版的一些典型使用合集。
|
16天前
|
Oracle 关系型数据库 数据库
Oracle数据恢复—Oracle数据库文件有坏快损坏的数据恢复案例
一台Oracle数据库打开报错,报错信息: “system01.dbf需要更多的恢复来保持一致性,数据库无法打开”。管理员联系我们数据恢复中心寻求帮助,并提供了Oracle_Home目录的所有文件。用户方要求恢复zxfg用户下的数据。 由于数据库没有备份,无法通过备份去恢复数据库。
|
22天前
|
存储 Oracle 关系型数据库
oracle数据恢复—Oracle数据库文件大小变为0kb的数据恢复案例
存储掉盘超过上限,lun无法识别。管理员重组存储的位图信息并导出lun,发现linux操作系统上部署的oracle数据库中有上百个数据文件的大小变为0kb。数据库的大小缩水了80%以上。 取出&并分析oracle数据库的控制文件。重组存储位图信息,重新导出控制文件中记录的数据文件,发现这些文件的大小依然为0kb。
|
9天前
|
存储 Oracle 关系型数据库
服务器数据恢复—华为S5300存储Oracle数据库恢复案例
服务器存储数据恢复环境: 华为S5300存储中有12块FC硬盘,其中11块硬盘作为数据盘组建了一组RAID5阵列,剩下的1块硬盘作为热备盘使用。基于RAID的LUN分配给linux操作系统使用,存放的数据主要是Oracle数据库。 服务器存储故障: RAID5阵列中1块硬盘出现故障离线,热备盘自动激活开始同步数据,在同步数据的过程中又一块硬盘离线,RAID5阵列瘫痪,上层LUN无法使用。