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

（A）It can be an outer join.

（B）It must be an inner join.

（C）The on clause can be used.

（D）The query must use two different aliases for the table.

（E）The on clause must be used.

（F）It must be an equijoin.

（A）A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

（B）An UNUSED column's space is remained automatically when the row containing that column is next queried.

（C）A column that is set to NNUSED still counts towards the limit of 1000 columns per table.

（D）An UNUSED column's space is remained automatically when the block containing that column is next queried.

（E）Partition key columns cannot be dropped.

（F）A DROP COLUMN command can be rolled back.

（A）DELETE can be granted on tables, views, and sequences.

（B）REFERENCES can be grantrd only on tables.

（C）INSERT can be granted only on tables and sequences.

（D）SELECT can be granted on tables, views, and sequences.

（E）ALTER can be granted only on tables and sequences.

（A）COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.

（B）COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.

（C）COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column

（D）A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

（E）It can only be used for NUMBER data types.

（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）TRUNCATE can use a where clause to determine which row(s) should be removed.

（B）the result of a delete can be undone by issuing a rollback

（C）truncate leavers any indexes on the table in an UNUSABLE STATE.

（D）delete can use a where clause to determine which row(s) should be removed.

（E）the result of a truncate can be undone by issuing a ROLLBACK.

（A）DELETE

（B）ALTER

（C）INDEX

（D）SELECT

（E）INSERT

（F）REFERENCES

（G）UPDATE

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

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

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

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

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

（F）SPLECT product_id, expiry_date * 2 FROM products;

（A）All existing rows in the EMPLOYEES table are deleted,

（B）The subquery is executed for every row in the EMPLOYEES table.

（C）The subquery is not a correlated subquery.

（D）The DELETE statement executes successfully even if the subquery selects multiple rows.

（E）The subquery is executed before the DELETE statement is executed.

（A）A SAVEPOINT does not issue a COMMIT

（B）Rolling back to a SAVEPOINT can undo a TRUNCATE statement.

（C）Rolling back to a SAVEPOINT can undo a DELETE statement

（D）Only one SAVEPOINT may be issued in a transaction.

（E）Rolling back to a SAVEPOINT can undo a CREATE INDEX statement.

（A）It will return rows that are not common to both select statements.

（B）It will return rows both select statements including duplicate rows.

（C）It will return rows common to both select statements.

（D）It will return rows from both select statements after eliminating duplicate rows.

（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）INTERVAL'11:60'HOUR TO MINUTE

（B）INTERVAL'720'MINUTE

（C）INTERVAL'0 12'DAY TO HOUR

（D）INTERVAL'12' HOUR

（E）INTERVAL '12:00'

（F）INTERVAL'0,5'DAY

（A）SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;

（B）SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level IS NOT NULL
AND due_amount IS NOT NULL;

（C）SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level !=NULL
AND due_amount !=NULL;

（D）SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level !=NULL
AND cust credit_level !=NULL;

（E）SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level <> NULL
AND due_amount <> NULL;

（A）You must have SELECT privileges on a table to view it in USER TABLES.

（B）ALL TABLES displays all tables owned by the current user.

（C）All users can query DBA TABLES successfully.

（D）You must have SELECT privileges on a table to view it in ALL _TABLES.

（E）You must have SELECT privileges on a table to view it in DBA TABLES.

（F）USER_ TABLES displays all tables owned by the current user.

（A）

（B）

（C）

（D）

（A）MOD: returns the quotient of a division operation

（B）CEIL: can be used for positive and negative numbers

（C）CONCAT: can be used to combine any number of values

（D）FLOOR: returns the smallest integer greater than or equal to a specified number

（E）TRUNC: can be used with NUMBER and DATE values

（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.