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

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

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

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

（D）SELECT join_ date||''|| salary FROM employees;

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

（A）All users have permissions to access all information in the data dictionary by default

（B）Base tables in the data dictionary have the prefix DBA_.

（C）The SYS user owns all base tables and user-accessible views in the data dictionary.

（D）The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

（E）All user actions are recorded in the data dictionary.

（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）It retains the indexes defined on the table.

（B）It retains the integrity constraints defined on the table.

（C）A FLASHBACK TABLE statement can be used to retrieve the deleted data.

（D）It drops any triggers defined on the table.

（E）It always retains the space used by the removed rows.

（F）A ROLLBACK statement can be used to retrieve the deleted data.

（A）It will return the six employees earning the lowest salaries, in ascending order.

（B）It will return the five employees earning the highest salaries, in descending order.

（C）It will return the five employees earning the lowest salaries, in ascending order.

（D）It will return the six employees earning the highest salaries, in descending order.

（A）SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;

（B）SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

（C）SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

（D）SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

（E）SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

（A）

（B）

（C）

（D）

（E）

（A）A VARCHAR2 column definition does not require the length to be specified.

（B）A BFILE stores unstructured binary data in operating system files.

（C）A BLOB stores unstructured binary data within the database.

（D）The default length for a CHAR column is always one character.

（E）A CHAR column definition does not require the length to be specified.

（F）A VARCHAR2 blank-pads column values only if the data stored is non-numeric and contains no special characters.

（A）SELECT last_name,salary
FROM (SELECT * FROM employees ORDER BY salary)

（B）SELECT last_name,salary
FROM employees
WHERE ROWNUM<=3
ORDER BY (SELECT salary FROM employees);

（C）SELECT last_name,salary
FROM employees
FETCH FIRST 3 ROWS ONLY
ORDER BY salary;

（D）SELECT last_name,salary
FROM employees
ORDER BY salary
FETCH FIRST 3 ROWS ONLY;

（E）SELECT last_name, salary
FROM employees
WHERE ROWNUM<=3

（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）SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;

（B）SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

（C）SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

（D）SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

（E）SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

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

（B）SELECT * FROM customers WHERE insert date ='01-JAN-19'

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

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