有難い1z0-071受験準備 & 合格スムーズ1z0-071模擬問題集 | 100％合格率の1z0-071日本語版サンプル試験を怖く感じるのはかなり正常です。特にOracleの1z0-071のような難しい試験です。励ましだけであなたの試験への自信を高めるのは不可能だと知っていますから、我々は効果的なソフトを提供してあなたにOracleの1z0-071試験に合格させます。あなたはデモで我々のソフトの効果を体験することができます。あなたはデモから我々のOracleの1z0-071ソフトを開発する意図とプロを感じることができます。 Oracle Database SQL 認定 1z0-071 試験問題 (Q239-Q244):質問 # 239
Examine the contents of the EMP table:
What is the result?
A. It will return the six employees earning the highest salaries. In descending order.
B. It will return the five employee's earning the lowest salaries. In ascending order.
C. It will return the five employees earning the highest salaries. In descending order.
D. It will return the six employees earning the lowest salaries. In ascending order.
正解：B
質問 # 240
You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null.
Which two SQL statements would create the required table? (Choose two.)
質問 # 241
Which three statements are true about GLOBAL TEMPORARY TABLES?
A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
B. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.
C. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
D. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
E. A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
正解：B、C、E
解説：
Global temporary tables (GTTs) in Oracle have unique properties related to session-based visibility and data persistence:
* B. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted: True, TRUNCATE is session-specific for GTTs and will remove all rows inserted by the session that issues the TRUNCATE command.
* D. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions: The structure of a GTT is persistent and shared across sessions, but the data within is session-specific.
* E. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted: The data in GTTs is private for the session, and when the session ends, the data is deleted automatically.
References:
* Oracle Database Concepts and SQL Language Reference 12c, especially the sections on temporary tables.
質問 # 242
View the Exhibit and examine the description of the ORDERS table.
Which two WHERE clause conditions demonstrate the correct usage of conversion functions? (Choose two.) WHERE order_date_IN ( TO_DATE('OCT 21 2003','MON DD YYYY'), TO_CHAR('NOV 21
A. WHERE TO_CHAR(order_date,'MON DD YYYY') = 'JAN 20 2003'
B. 2003','MON DD YYYY') )
C. WHERE order_date > TO_DATE('JUL 10 2006','MON DD YYYY')
D. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),'MON DD YYYY')
正解：A、C
質問 # 243
Examine the description of the PRODUCT_DETAILS table:
Which two statements are true?
A. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.
B. PRODUCT_NAME cannot contain duplicate values.
C. PRODUCT_PRICE contains the value zero by default if no value is assigned to it.
D. PRODUCT_ID can be assigned the PRIMARY KEY constraint.
E. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.
F. EXPIRY_DATE cannot be used in arithmetic expressions.
