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

（A）WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));

（B）WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

（C）WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101','A102');

（D）WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');

（E）WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

（A）UPDATE emp80
SET department_id=90
WHERE department_id=80;

（B）DELETE FROM emp80
WHERE department_id=90;

（C）SELECT *
FROM emp80
WHERE department_id=90;

（D）SELECT *
FROM emp80
WHERE department_id=80;

（A）qty_sold BETWEEN '101' AND '110': uses implicit conversion

（B）CONCAT(qty_sold, invoice_date): requires explicit conversion

（C）qty_sold ='05549821 ': requires explicit conversion

（D）invoice_date = '15-march-2019': uses implicit conversion

（E）invoice_date> '01-02-2019': uses implicit conversion

（A）sorted by DEPARTMENT_NAME and AVGSAL

（B）sorted by DEPARTMENT_NAME

（C）Sorted by MAXSAL

（D）sorted by DEPARTMENT_NAME and MAXSAL

（E）sorted by AVGSAL

（A）It can be used in SQL Developer and SQL*Plus.

（B）It displays values for variables used only in the WHERE clause of a query.

（C）It displays values for variables prefixed with &&.

（D）It can be used only in SQL*plus.

（E）It displays values for variables created by the DEFINE command.

（A）The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.

（B）STUDENT ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.

（C）The ER must have a many to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.

（D）PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.

（E）An associative table must be created with a composite key of STUDENT_ID and PROJRCT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

（A）It processes NULLS in the selected columns.

（B）It ignores NULLS.

（C）INTERSECT is of lower precedence than UNION or UNION ALL.

（D）Multiple INTERSECT operators are not possible in the same SQL statement.

（A）a table

（B）a unique identifier

（C）an activity

（D）an attribute

（E）an entity

（F）a relationship

（A）The foreign key constraint will be enabled and IMMEDIATE.

（B）The primary key constraint will be enabled and IMMEDIATE.

（C）The primary key constraint will be enabled and DEFERRED.

（D）The foreign key constraint will be enabled and DEFERRED.

（E）The foreign key constraint will be disabled.

（A）A primary key constraint is manadatory.

（B）A create table statement can specify the maximum number of rows the table will contain.

（C）The same table name can be used for tables in different schemas.

（D）A system privilege is required.

（E）Creating an external table will automatically create a file using the specified directory and file name.

（A）DELETE FROM emp80
WHERE department_ id = 90;

（B）SELECT
FROM emp80
WHERE department. id = 80;

（C）SELECT
FROM emp80
WHERE department_ id = 90;

（D）UPDATE emp80
SET department. 1d =80;
WHERE department_ id =90;

（A）The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed.

（B）The second ROLLBACK command replays the delete.

（C）The second ROLLBACK command undoes the insert.

（D）The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.

（E）The second ROLLBACK command does nothing.

（A）Log in to a database.

（B）Truncate a table in another schema.

（C）Access flat files via a database, which are stored in an operating system directory.

（D）Execute a procedure in another schema.

（E）Use the WITH GRANT OPTION clause.

（F）Query any table in a database.

（A）MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id= p.prod_id)
WHEN MATCHED THEN
UPDATE SET n.price= p.cost*.01
DELETE WHERE (p.cost<200);

（B）MERGE INTO new_prices n
USING products p
ON (p.prod_id =n.prod_id)
WHEN NOT MATCHED THEN
INSERT (n.prod _id, n.price) VALUES (p.prod_id, cost*.01)
WHERE (p.cost<200);

（C）MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id= p.prod_id)
WHEN MATCHED THEN
DELETE WHERE (p.cost<200)

（D）MERGE INTO new_prices n
USING (SELECT * FROM products) p
WHEN MATCHED THEN
UPDATE SET n.price= p.cost* 01
WHEN NOT MATCHED THEN
INSERT(n.prod_id, n.price) VALUES(p.prod_id, cost*.01)
WHERE(p.cost<200);