首页  /  试题详情

多选题

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A、

The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST or ORACLE_BASE is set

B、

The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

C、

It supports diagnostics for Automatic Storage Management (ASM)

D、

It supports diagnostics for Oracle Clusterware

E、

It is held inside an Oracle database schema

查看答案
下载APP答题
由4l***04提供 分享 举报 纠错
题库推荐
OCP 19c 1z0-082第一部分241题
2024-07-16
共275道
OCP刷题082
2022-08-27
共324道
瑞-082
2021-11-29
共285道
1Z0 - 082
2022-09-15
共191道

相关试题

单选题 Which compression method is recommended for Direct - Path Insert operations?

A、

COLUMN STORE COMPRESS ADVANCED

B、

ROW STORE COMPRESS ADVANCED

C、

COLUMN STORE COMPRESS BASIC

D、

ROW STORE COMPRESS BASIC

单选题 Examine the description of the SATES1 table

c3e729b3e37c01b4260eb64bd4cb26e1.png

SALES2 is a table with the same description as SATES1 Some sales data is contained erroneously in both tables

You must display rows from sAlEs1 and SALES and wish to see the duplicates too Which set operator generates the required output?

A、

MINUS

B、

UNION ALL

C、

SUBTRACT

D、

UNION

E、

INTERSECT

单选题 Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

A、

the first NUMBER or VARCHAR2 column in the last select of the compound query

B、

the first NUMBER column in the first select of the compound query

C、

the first vARCHAR2 column in the first select of the compound query

D、

the first column in the first select of the compound query

单选题 Which statement is true about the INTERSECT operator used in compound queries?

A、

Multiple INTERSECT operators are not possible in the same SQL statement

B、

It processes NULLs in the selected columns

C、

INTERSECT is of lower precedence than UNION or UNION ALL

D、

It ignores NULLs

单选题 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?

A、

INTERVAL YEAR TO MONTH

B、

INTERVAL DAY TO SECOND

C、

TIMESTAMP WITH LOCAL TIMEZONE

D、

TIMESTAMP

E、

TIMESTAMP WITH TIMEZONE

单选题 Examine the description of the products table

238113815d5bb2b54d7bce2da85c96e0.png

A、

SELECT prod id, AVG(MAX (cost)) FROM products GROUP BY prod.

B、

SELECT prod id, MAX (AVG (cost)) FROM products GROUP BY prod id

C、

Select prod id, release date, SUM(cost) FROM products GROUP BY prod id

D、

SELECT prod id, release date, SUM(cost) FROM products GROUP BY prod id, release date

单选题 Examine the description of the CUSTOMERS table: 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?

A、

SELECT * FROM customers WHERE city LIKE ‘D_%’;

B、

SELECT * FROM customers WHERE city = ‘%D_’;

C、

SELECT * FROM customers WHERE city LIKE ‘D_’;

D、

SELECT * FROM customers WHERE city = ‘D_%’;

单选题 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? 

A、

SELECT &&col1, &&col2 FROM &table WHERE &&condition = &&cond;

B、

SELECT &col1, &col2 FROM &&table WHERE &condition;

C、

SELECT &col1, &col2 FROM “&table” WHERE &condition;

D、

SELECT ‘&&col1’, ‘&&col2’FROM &table WHERE ‘&&condition’ = ‘&cond’; SELECT &&col1, &&col2 FROM &table WHERE &&condition;

E、

SELECT &&col1, &&col2 FROM &table WHERE &&condition;