搜索答案
登录 注册
首页  /  试题详情

多选题 You currently have an active transaction in your session and have been granted select access
To VSTRANSACTIONIn which three situations will re-executing this query still return a row but with a different XID
Indicating a new transaction has started?
Select xid, status FROM v$transcation;
In your session returns:
XID STATUS
-------------------------------
0A007000A070000 ACTIVE

A、 after successfully executing a TRUNCATE statement followed by a DML statement
B、 after successfully executing a CREATE TABLE AS Select statement followed by a SELECT
FOR UPDATE statement
C、 after successfully executing a CREATE TABLE statement followed by a CREATE INDEX
Statement
D、 after successfully executing a commit or ROLLBACK followed by a DML statement
E、 after successfully executing a DML statement following a failed DML statement
F、 after successfully executing a commit or ROLLBACK followed by a Select statement
查看答案

微信扫一扫
扫一扫下载APP
微信小程序答题 下载APP答题
由4l***se提供 分享 举报 纠错
相关题库推荐
OCP-082-90
2022-10-20
共97道

相关试题

单选题 Examine the description of the SATES1 table
Name Null type
-----------------------------------------------------
SALES_ID NOT NULL NUMBER
STORE_ID NOT NULL NUMBER
ITMES_ID NUMBER
UANTITY NUMBER
SALES_DATE DATE
SALES2 is a table with the same description as sAleS1
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

单选题 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
SELECT prod_id
FROM costs
WHERE promo_id IN
(SELECT promo_id
FROM promotions
WHERE promo_cost < ALL
(SELECT MAX(promo_cost)
FROM promotions
GROUP BY (promo end date - promo begin date)));
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

单选题 Your database instance is started with an SPFILE
A PFILE is also available
You execute this command
ALTER SYSTEM SET DB CACHE SIZE=100K
Where is the value changed?

A、in the SPFILE and PFTIE

B、in the SPFILE, PFILE, and memory

C、only in the SPFILE

D、in the SPFILE and in memory

E、only in memory

单选题 Examine the description of the EMPLOYEES table
NIS DATE FORMAT is set to DD-MON-YY
Which query requires explicit data type conversion?

A、SELECT join date FROM employees WHERE join date >'10-02-2018';

B、SELECT join date || ' '|| salary FROM employees

C、SELECT salary + '120.50' FROM employees

D、SELECT SUBSTR( join_date, 1, 2)-10 FROM employees

E、SELECT join date + '20' FROM employees

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

E、the first column in the last selects of the compound query

单选题 Examine the description of the products table
Name Null type
-----------------------------------------------------
PROD_ID NOT NULL NUMBER
PROD_NAME VARCHAR2(40)
COST NUMBER(8,2)
PRLEASE_DATE DATE
Which query is valid?

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

单选题 In the spfile of a single instance database, LOCAL LISTENER is set to LISTENER 1.
The TNSNAMES ORA file in SORACLE 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

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