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

（A）SELECT salary + '120.50' FROM employees;

（B）SELECT join_ date'' salary FROM employees;

（C）SELECT join_ date + '20' EROM employees;

（D）SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;

（E）SELECT join _ date FROM employees WHERE join date > *10-02-2018';

（A）A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.

（B）A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.

（C）A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.

（D）A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #####

（E）A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.

（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);

（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）TIMESTAMP WITH TIMEZONE

（B）TIMESTAMP

（C）TIMESTAMP WITH LOCAL TIMEZONE

（D）INTERVAL YEAR TO MONTH

（E）INTERVAL DAY TO SECOND

（A）SELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);

（B）SELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;

（C）SELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;

（D）SELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);

（E）SELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

（A）GRANT UPDATE ON customers. title, customers.address TO andrew WITH GRANT OPTION;

（B）GRANT UPDATE ON customers. title, customers.address TO andrew;

（C）GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;

（D）GRANT UPDATE (title, address) ON customers TO andrew;

（E）GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION:

（F）GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;

（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）The data type of each column retuned by the second query must exactly match the data type of the corresponding column returned by the first query

（B）The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query

（C）The number, but not names, of columns must be identical for all SELECT statements in the query

（D）The names and number of columns must be identical for all SELECT statements in the query.

（E）The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query

（A）The primary key constraint on BMP_ID must have a name.

（B）The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.

（C）The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.

（D）One of the LONG columns must be changed to a VARCHAR2 or CLOB.

（E）The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.

（A）Rows from unrelated tables cannot be joined.

（B）Relating data from a table with data from the same table is implemented with a self join.

（C）Implementing a relationship between two tables might require joining additional tables.

（D）An inner join relates rows within the same table.

（E）Every relationship between the two tables must be implemented in a Join condition.

（A）a table

（B）a unique identifier

（C）an activity

（D）an attribute

（E）an entity

（F）a relationship