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

（A）It returns the same date as CURRENT_DATE.

（B）It always returns the same value as SYSTIMESTAMP

（C）It returns a value of data type TIMESTAMP

（D）The date is in the time zone of DBTIMEZONE.

（E）The value varies depending on the setting of SESSIONTIMEZONE.

（F）The time is in the time zone of DBTIMEZONE.

（A）MERGE INTO employees e
USING new employees ne
ON (e.employee_id = ne.employee_id)
WHEN FOUND THEN
UPDATE SET e.name =ne.name, e.job_id=ne.job_id, e.salary =ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_id,ne.name,ne.job_id,ne.salary) ;

（B）MERGE INTO employees e
USING new_employees n
WHERE e.employee_id = ne.employee_id
WHEN FOUND THEN
UPDATE SET e.name=ne.name,e.job_id =ne.job_id, e.salary=ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_ id,ne.name,ne.job id,ne.salary) ;

（C）MERGE INTO employees e
USING new_employees n
ON (e.employee_id = ne.employee_id)
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name,ne.job_id,ne.salary);

（D）MERGE INTO employees e
USING new employees ne
WHERE e.employee_id = ne.employee_ id
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job_id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name, ne.job_id,ne.salary) ;

（A）UNION ALL

（B）UNION

（C）MINUS

（D）SUBTRACT

（E）INTERSECT

（A）The argument can be a column name, variable, literal or an expression.

（B）They can accept only one argument.

（C）They can be nested to any level.

（D）The date type returned can be different from the data type of the argument.

（E）They return a single result row per table.

（F）They can be used only in the where clause of a select statement.

（A）a unique identifier

（B）an attribute

（C）an entity

（D）label

（E）an optionality

（F）a cardinality

（A）SELECT shape FROM bricks JOIN boxes ON weight > min_weight;

（B）SELECT shape FROM bricks JOIN boxes ON weight BETWEEN min_weight AND max_weight;

（C）SELECT shape FROM bricks JOIN boxes ON weight >= min_weight AND weight < max_weight;

（D）SELECT shape FROM bricks JOIN boxes ON NOT (weight > max_weight);

（E）SELECT shape FROM bricks JOIN boxes ON weight < max_weight;

（A）PROMO_BEGIN_DATE-SYSDATE will return a number.

（B）TO_DATE(PROMO_BEGIN_DATE * 5) will return a date

（C）TO_NUMBER(PROMO_BEGIN_DATE)-5 will return number

（D）PROMO_BEGIN_DATE-5 will return a date.

（E）PROMO_BEGIN_DATE-SYSDATE will return an error.

（A）SELECT COALESCE('DATE',SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL) ;

（B）SELECT NVL('DATE',SYSDATE) FROM DUAL;

（C）SELECT COALESCE(O,SYSDATE) TRCH DUAL;

（D）SELECT COALESCR('DATE', SYSDATE) FROM DUAL;

（E）SELECT NVL('DATE',200) FROM (SELECT NULL AS "DATE" FROM DUAL);

（A）CREATE SYNONYM emp FOR hcm.employee_records;

（B）CREATE GLOBAL SYNONYM emp FOR hcm.employee_records;

（C）CREATE SYNONYM SYS.emp FOR hcm.employee_records;

（D）CREATE PUBLIC SYNONYM emp FOR hcm. employee_records;

（E）CREATE SYNONYM PUBLIC.emp FOR hcm.employee_records;

（A）SELECT TO_NUWBER(TO_DATE(INTERVAL '800' SECOND)) FROM DUAL;

（B）SELECT TO_DATE(INTERVAL '800' SECOND,'HH24:MM') FROM DUAL;

（C）SELECT TO_NUMBER(INTERVAL'800' SECOND, 'HH24:MM') FROM DUAL;

（D）SELECT TO_CHAR(INTERVAL '800' SECOND, 'HH24:MM') FROM DUAL;

（E）SELECT TO_DATE(TO_NUMBER(INTERVATL '800' SECOND)) FROM DUAL;

（A）They require the NOT EXISTS operator in the join condition.

（B）They require the EXISTS opnrator in the join condition.

（C）They can use INNER JOIN and LEFT JOIN.

（D）They are always equijoins.

（E）They have no join condition.

（F）They require table aliases.

（A）

（B）

（C）

（D）

（A）SELECT * FROM customers WHERE city ='D_%';

（B）SELECT * FROM customers WHERE city ='%D_';

（C）SELECT * FROM customers WHERE city LIKE'D %';

（D）SELECT * FROM customers WHERE city LIKE'D_';

（A）The DEPARTMENT_ID column is set to null for all tows in the table

（B）The DEPARTMENT_ID column can be recovered from the recycle bin

（C）A query can display data from the DEPARTMENT_ID column.

（D）The storage space occupied by the DEPARTMENT_ID column is released only after a COMMIT is issued.

（E）No updates can be made to the data in the DEPARTMENT_ID column.

（F）A new column with the name DEPARTMENT_ID can be added to the EMPLOYEES table.

（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）It returns matched and unmatched rows from both tables being joined.

（B）It includes rows that are returned by a Cartesian product.

（C）It includes rows that are returned by an inner join.

（D）The Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause.

（E）It returns only unmatched rows from both tables being joined.

（A）LAST_DAY returns the date of the last day of the current ,month onlyu.

（B）LAST_DAY return the date of the last day the previous month only.

（C）CEIL requires an argument which is a numeric data type.

（D）LAST_DAY returns the date of the last day of the month for the date argument passed to the function.

（E）ADD_MONTHS works with a character string that can be implicitlyt converted to a DATE data type.

（F）CEIL returns the largest integer less than or equal to a specified number.

（G）ADD_MONTHS adds a number of calendar months to a date.

（A）The statement will fail because subquery may not be I contained in a values clause.

（B）The statement will fail if a row already exists in the SALES table for product 23.

（C）A customer can exist in many countries.

（D）The SALES table has five foreign keys.

（E）The statement will execute successfully and a new row will be inserted into the SALES table.

（F）A product can have a different unit price at different times.