Oracle 19c OCP 1Z0-082认证考试题库（36-41）

36.Examine this commandWhich two statements are true?A.DML,  may  be  performed  on  tables  with  one  or  more  extents  in  this  data  file  during theexecution of this commandB.It overwrites any existing file with the name SALES02.DBF in /u02 by default.C.Tables with one or more extents in this data file may be queried during the execution of this commandD.Compressed objects in sales01.DBF will be uncompressed in SALES02.DBF after the move E.The "To" clause containing the new file name must be specified even if Oracle Managed Files (OMF)is used答案： AChttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/managing-data-files-and-temp-files.html#GUID-B0CB3536-EB2D-4319-9563-D698905E67D437.Which two statements are true about substitution variables?A.A substitution variable used to prompt for a column name must be enclosed in double quotation marks.B.A substitution variable prefixed with s always prompts only once for a value in a sessionC.A substitution variable used to prompt for a column name must be enclosed in single quotation marksD.A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the sessionE.A substitution variable can be used only in a SELECT statementF.A substitution variable can be used with any clause in a select statement答案： DF38.Examine this description of the TRANSACTIONS tableWhich two SQL statements execute successfully?A.SELECT customer_id CUSTID, transaction date TRANS_DATE, amount+ 100 DUES FROM transactionsB.SELECT customer_id AS "CUSTOMER-ID", transaction date AS DATE, amount + 100 “DUES” FROM transactionsC.SELECT customer_id AS ‘CUSTOMER-ID’, transaction date As DATE, amount + 100 ‘DUES’ FROM transactionsD.SELECT customer_id AS "CUSTOMER-ID ", transaction date As "DATE”, amount  +100 DUES FROM transactionsE.SELECT customer_id AS CUSTOMER-ID, transaction date As TRANS DATE, amount 100 " DUES AMOUNT " FROM transactions答案： ADCUSTOMER-ID和DATE要用引号39.Which two statements are true about the configuration and use of UNDO RETENTION with no GUARANTEED RETENTION?A.Unexpired UNDO is always retainedB.UNDO RETENTION specifies for how long Oracle attempts to keep unexpired UNDO C.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.D.UNDO RETENTION specifies how long all types of UNDO are retained E.Active UNDO is always retained答案： BE40.The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RRWhich two WHERE conditions demonstrate the correct usage of conversion functions? A.WHERE order_date=TO_DATE(ADD_MONTHS(SYSDATE, 6),'MON DD YYYY') B.WHERE TO_CHAR(order date, 'MON DD YYYY')= 'JAN 20 2019'C.WHERE order_date > TO_DATE(JUL 10 2018','NON DD YYYY')D.WHERE order_date=TO_CHAR(ADD_MONTHS(SYSDATE, 6),'MON DD YYYY)E.WHERE order_date IN (TO_DATE('oct 21 2018','mon DD YYYY '), TO_CHAR('Nov 21 2018', 'Mon DD YYYY'))答案： BCA不应该用to_dateD 日期和字符无法进行比较41.Examine the description of the EMPLOYEES table NLS_DATE_FORMAT is set to DD-MON-YYWhich query requires explicit_data type conversion?A.SELECT join_date FROM employees WHERE join_date >'10-02-2018'; B.SELECT join_date || ' '|| salary FROM employeesC.SELECT salary + '120.50' FROM employeesD.SELECT SUBSTR( join_date, 1, 2)-10 FROM employees E.SELECT join_date + '20' FROM employees答案： A