1z0-071 無料問題集「Oracle Database SQL」

（A）an error

（B）1 row

（C）0 rows

（D）2 rows

（A）SELECT product_id,(unit_price * 0.15 / (4.75 + 552.25)) FROM products;

（B）SELECT product_id, expiry_date * 2 from products;

（C）SELECT product_id,unit_price,5 "Discount", unit_price + surcharge-discount FROM products;

（D）SELECT product_id, unit_price, unit_price + surcharge FROM products;

（E）SELECT product_id,(expiry_date - delivery_date) * 2 FROM products;

（F）SELECT product_id,unit_price || 5 "Discount" , unit_price + surcharge - discount FROM products;

（A）The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

（B）The CURRENT_TIMESTAMP function returns data without time zone information

（C）A TIMESTAMP data type column contains information about year, month, and day

（D）A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

（E）The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

（A）When issuing a TRUNCATE statement after a SELECT statement was issued in the same session

（B）When issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

（C）When issuing a CREATE INDEX statement after a CREATE TABLE statement completed unsuccessfully in the same session

（D）When issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

（E）When issuing the first Data Manipulation Language (OML) statement after a COMMIT or ROLLBACK statement was issued in the same session

（F）When issuing a DML statement after a DML statement filed in the same session.

（A）Data selected by a view's defining query is deleted from its underlying tables when the view is dropped.

（B）The creator of a view to be dropped must have the drop any view privilege.

（C）CASCADE CONSTRAINTS must be specified when referential integrity constraints on other objects refer to primary or unique keys in the view to be dropped.

（D）Views referencing a dropped view become invalid.

（E）Read only views cannot be dropped.

（A）The Oracle join syntax supports natural joins.

（B）The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.

（C）The Oracle join syntax only supports right outer joins,

（D）The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

（E）The SQL:1999 compliant ANSI join syntax supports natural joins.

（F）The Oracle join syntax performs less well than the SQL:1999 compliant ANSI Join Answer.

（G）The Oracle join syntax supports creation of a Cartesian product of two tables.

（A）An uncommitted transaction is automatically committed when the user exits SQL*PLUS

（B）DDL statements automatically commit only data dictionary updates caused by executing the DDL.

（C）A session can see uncommitted updates made by the same user in a different session

（D）A DDL statement issued by a session with an uncommitted transation automaticall commits that transaction.

（E）DML statements always start new transactions.

（A）It retains the indexes defined on the table.

（B）A FLASHBACK TABLE statement can be used to retrieve the deleted data.

（C）It drops any triggers defined on the table.

（D）It retains the integrity constraints defined on the table,

（E）It always retains the space used by the removed rows.

（F）A ROLLBACK statement can be used to retrieve the deleted data.

（A）SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

（B）SELECT dept_id, MAX (AVG(salary)) FROM employees GROUP BY dept_id;

（C）SELECT dept_id, AVG(NAX(salary)) FROM employees GROUP BY dept_id;

（D）SELECT dept_id, join date, SUM(salary) FROM employees GROUP BY dept_id,join_date;

（A）Create a directory object for an external table.

（B）Create a directory object for a flat file.

（C）Read data from a table in the database and insert it into an external table.

（D）Read data from an external table and load it into a table in the database.

（E）Query data from an external table.

（F）Execute DML statements on an external table.

（A）The query optimizer never considers INVISIBLE Indexes when determining execution plans

（B）You can only create one INVISIBLE index on the same column list

（C）You use AlTER INDEX to make an INVISIBLE Index VISIBLE

（D）an INVISIBLE Index consumes no storage

（E）All INSERT, UPDATE, and DELETE statements maintain entries in the index

（A）When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

（B）Creating an external table creates a dump file that can be used only by an external table in the same database.

（C）Creating an external table creates a directory object.

（D）When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

（E）Creating an external table creates a dump file that can be used by an external table in the same or a different database.

（A）the DEFAULT DIRECTORY clause

（B）the REJECT LIMIT clause

（C）the ACCESS PARAMETERS clause

（D）the LOCATION clause

（E）the access driver TYPE clause