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

（A）SELECT * FROM customers WHERE customer_ id = 0001;

（B）SELECT. FRON customers WE TO DATE (Insert _ date) = DATE '2019-01-01';

（C）SELECT * FROM customers WHERE customer id = '0001';

（D）SELECT * FROM customers WHERE TO_ CHAR (customer_ id) = '0001';

（E）SELECT. FROM customers WHERE insert_ date = DATE *2019-01-01';

（F）SELECT FROM customers WHERE insert date = '01-JAN-19';

（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）SELECT * FROM products
UNION
SELECT * FROM new_products;

（B）SELECT prod_id, prod_name FROM products
INTERSECT
SELECT 100, prod_name FROM newproducts;

（C）SELECT prod_id, exp_date FROM products
UNION ALL
SELECT prod_id, NULL FROM new_products;

（D）SELECT k FROM products
MINUS
SELECT prod_id FROM new_products;

（E）SELECT prod_id FROM products
UNION ALL
SELECT prod_id, prod_name FROM new_products;

（A）Roles are assigned to roles using the ALTER ROLE statement.

（B）A single role can be assigned to multiple users.

（C）Roles are assigned to users using the ALTER USER statement.

（D）Privileges are assigned to a role using the ALTER ROLE statement.

（E）A role is a named group of related privileges that can only be assigned to a user.

（F）Privileges are assigned to a role using the GRANT statement.

（G）A single user can be assigned multiple roles.

（A）Store the query in a script and pass the substitution value to the script when executing it.

（B）Execute the SET VERIFY ON command before executing the query.

（C）Execute the SET VERIFY OFF command before executing the query.

（D）Replace'&1' with'&&1' in the query.

（E）Use the DEFINE command before executing the query.

（F）Use the UNDEFINE command before executing the query.

（A）The HR. EMPLOYEES table may be moved to the recycle bin.

（B）Views referencing HR, EMPLOYEES are dropped.

（C）Sequences used to populate columns in the HR. EMPLOYEES table are dropped.

（D）ALL constraints defined on HR, EMPLOYEES are dropped.

（E）Synonyms for HR EMPLOYEES are dropped.

（F）All indexes defined on HR, EMPLOYEES are dropped.

（A）Only if the salary is 20000 or less and the employee id is 125 or higher,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MDR_HISTORY table.

（B）Regardless of salary,only if the employee id is less than 125,insert EMPLOYEE_ID,NANAGER_ID,SALARY into the MGR_HISTORY table.

（C）If the salary is more than 20000 and the employee is less than 125,insert EMPLOYEE_ID and SALARY into the SPECIAL_SAL table.

（D）Only if the salary is 20000 or less and the employee id is less than 125,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MGR_HISTORY table.

（E）If the salary is 20000 or less and the employee id is less than 125,insert EMPLOYEE_ID,HIRE_DATE,and SALARY into the SAL_HISTORY table.

（F）Regardless of salary and employee id,insert EMPLOYEE_ID,MANAGER_ID,and SALARY into the MGR_HISTORY table.

（A）It provides independence for logical data structures being manipulated from the underlying physical data storage

（B）It guarantees atomicity, consistency, isolation, and durability (ACID) features

（C）It requires that data be contained in hierarchical data storage

（D）It is used to define encapsulation and polymorphism for a relational table

（E）It is the only language that can be used for both relational and object-oriented databases

（F）It best supports relational databases

（A）They must be placed on the right side of the comparison operator or condition.

（B）They can be used in the clause.

（C）They must be placed on the left side of the comparison operator or condition.

（D）They must return a row to prevent errors in the SQL statement.

（E）They can be used in the HAVING clause.

（F）A SQL statement may have multiple single row subquery blocks.

（A）Each row returned by the subquery can be inserted into only a single target table.

（B）It cannot have an ELSE clause.

（C）A single WHEN condition can be used for multiple INTO clauses.

（D）Each WHEN condition is tested for each row returned by the subquery.

（E）The total number of rows inserted is always equal to the number of rows returned by the subquery

（A）CONCAT joins two or more character strings together.

（B）INSTR finds the offset within a character string, starting from position 0.

（C）CONCAT joins two character strings together.

（D）FLOOR returns the largest positive integer less than or equal to a specified number.

（E）INSTR finds the offset within a string of a single character only.

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

（A）SELECT LOWER (SUBSTR('Hello World', 2)) FROM DUAL;

（B）SELECT LOWER (SUBSTR('Hello World, 2, 1)) FROM DUAL;

（C）SELECT INITCAP(TRIM('H' FROM 'Hello World')) FROM DUAL;

（D）SELECT SUBSTR('Hello world', 2) FROM DUAL;

（E）SELECT LOWER(TRIM('H' FROM 'Hello World')) FROM DUAL;

（A）SELECT REPLACE (SUBSTR(cust_last_name,-3),'An','O') FROM customers;

（B）SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;

（C）SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;

（D）SELECT REPLACE (TRIM(TRALING'son' FROM cust_last_name),'An','O') FROM customers;