首页  /  试题详情

单选题 In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
A size of 100 MB
AUTOEXTEND is off
UNDO_RETENTION is set to 15 minutes
It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens. What will happen when the next update is attempted by any transaction?

A、 It succeeds and the generated undo is stored in SYSTEM.
B、 It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’ “.
C、 It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
D、 It succeeds and the generated undo is stored in SYSAUX.
E、 It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
查看答案
下载APP答题
由4l***8g提供 分享 举报 纠错
相关题库推荐
082（61-80）
2022-02-15
共20道

相关试题

单选题 In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl No name server is used.
Which statement is true about ORCL?

A、It must be the value of the SERVICE_NAMES parameter on the client side
B、It must resolve to a valid connect descriptor in the server’s tnsnames.ora file
C、It must resolve to a valid connect descriptor in the client’s tnsnames.ora file
D、It must be the name of the database to whose instance HR wishes to connect
E、It must be the name of the server running the database to whose instance HR wishes to connect

单选题 In one of your databases, user KING is:
Not a DBA user
An operating system (OS) user Examine this command and its output:
SHOW PARAMETER OS_AUTHENT_PREFIX
NAME TYPE VALUE
---------------------------------------------------------------
Os_authen_prefix string
What must you do so that KING is authenticated by the OS when connecting to the database instance?

A、Set OS_AUTHEN_PREFIX to OPS$
B、Have the OS administrator add KING to the OSDBA group
C、Grant DBA to KING
D、Unset REMOTE_LOGIN_PASSWORD FILE
E、Alter user KING to be IDENTIFIED EXTERNALLY

多选题 The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

A、CONCAT (qty_sold, invoice_date) : requires explicit conversion
B、invoice_date = ’15-march-2019’ : uses implicit conversion
C、invoie_date > ’01-02-2019’ : uses implicit conversion
D、qty_sold BETWEEN ‘101’ AND ’110’ : uses implicit conversion
E、qty_sold = ‘0554982’ uses implicit conversion

单选题 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 prom_id in
(SELECT promo_id
FROM promotions
WHERE promo<ALL(SELECT MAX(promo_Cost)
FROM promotions
GROUP BY (promo_end_date-promo_begin_date)));
Exhibit 1
TABLE COSTS
Name Null Type
--------------------------------------------------------------
PROD_ID NOT NULL NUMBER
TIME_ID NOT NULL DATE
PROMO_ID NOT NULL NUMBER
CHANNE;_ID NOT NULL NUMBER
UNIT_COST NOT NULL NUMBER(10,2)
UNIT_PRICE NOT NULL NUMBER(10,2)
Exhibit 2
TABLE PROMOTIONS
Name Null Type
--------------------------------------------------------------
PROMO_ID NOT NULL NUMBER
PROMO_NAME NOT NULL VARCHAR2(30)
PROMO_SUBCATEGORY NOT NULL VARCHAR2(30)
PROMO_SUBCAEGORY_ID NOT NULL NUMBER
PROMO_CATEGORY NOT NULL VARCHAR2(30)
PROMO_CATEGORY_ID NOT NULL NUMBER
PROMO_COST NOT NULL NUMBER(10,2)
PROMO_BEGIN_DATE NOT NULL DATE
PROMO_END_DATE NOT NULL DATE
What will be the result?

A、It gives an error because the ALL keyword is not valid
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 executes successfully and gives the required result

单选题 Examine the description of the EMPLOYEES table:
Name null Type
---------------------------------------------------------------------
EMP_ID NOT NULL NUMBER
EMP_NAME VARCHAR2(40)
DEPT_ID NUMBER(2)
SALARY NUMBER(8,2)
JOIN_DATE DATE
Which query is valid?

A、SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
B、SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
C、SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
D、SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

单选题 Which statement is true regarding the INTERSECT operator?

A、The names of columns in all SELECT statements must be identical.
B、It ignores NULL values.
C、Reversing the order of the intersected tables alters the result.
D、The number of columns and data types must be identical for all SELECT statements in the query.

多选题 Which three are types of segments in an Oracle Database? (Choose three.)

A、undo
B、index
C、stored procedures
D、sequences
E、tables
F、clusters

单选题 Examine the description of the PROMOTIONS table:
Name null Type
---------------------------------------------------------------------------
PROMO_ID NOT NULL NUMBER(6)
PROMO_NAME NOT NULL VARCHAR2(30)
PROMO_CATEGORY NOT NULL VARCHAR2(30)
PROMO_COST NOT NULL NUMBER(10,2)
Management requires a report of unique promotion costs in each promotion category. Which query would satisfy this requirement?

A、SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1
B、SELECT promo_category, DISTINCT promo_cost FROM promotions
C、SELECT DISTINCT promo_cost, promo_category FROM promotions
D、SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;