최신 1z1-071 무료덤프 - Oracle Database SQL

A. SELECT *
FROM employees e
JOIN departments d
ON e.department_id=d.department_id
AND d.department_id=90;

B. SELECT *
FROM employees e
JOIN departments d
ON e.department_id=d.department_id
WHERE d.department_id=90;

C. SELECT *
FROM employees e
JOIN department d
WHERE e.department_id=d.department_id
AND d.department_id=90;

D. SELECT *
FROM employees e
JOIN departments d
ON d.departments_id=90
WHERE e.department_id=d.department_id;

A. The IN operator cannot be used in a condition that Involves an outer join.

B. A condition representing an outer join cannot be linked to another condition using the or logical operator.

C. An outer join is used to retrieve only the rows that do not meet the join condition.

D. The outer join operator (+) is used next to the column of the table without the matching rows.

E. The outer join operator (+) can be used on both sides of the join condition in an outer join.

A. When issuing a CREATE INDEX statement after a CREATE TABLE statement completed unsuccessfully in the same session

B. When issuing a DML statement after a DML statement filed in the same session.

C. When issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

D. When issuing a TRUNCATE statement after a SELECT statement was issued in the same session

E. When issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

F. When issuing the first Data Manipulation Language (OML) statement after a COMMIT or ROLLBACK statement was issued in the same session

A. DELETE FROM emp80
WHERE department_id=90;

B. UPDATE emp80
SET department_id=90
WHERE department_id=80;

C. SELECT *
FROM emp80
WHERE department_id=80;

D. SELECT *
FROM emp80
WHERE department_id=90;

A. A substitution variable can be used only in a SELECT statement.

B. A substitution variable prefixed with 6 prompts only once for a value in a session unless is set to undefined in the session.

C. A substitution variable can be used with any clause in a SELECT statement.

D. A substitution variable used to prompt for a column name must be endorsed in single quotation marks.

E. A substitution variable prefixed with & always prompts only once for a value in a session.

F. A substitution variable used to prompt for a column name must be endorsed in double quotation marks.

A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

B. SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;

C. SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

D. SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

E. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

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

B. The default length for a CHAR column is always one character.

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

D. A CHAR column definition does not require the length to be specified.

E. A BFILE stores unstructured binary data in operating system files.

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

A. All the dynamic performance views prefixed with V$ are accessible to all the database users.

B. The USER OBJECTS view can provide information about the tables and views created by the user only.

C. The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.

D. DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.

E. The USER SYNONYMS view can provide information about private synonyms.

A. WHERE UPPER(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) LIKE UPPER('MC%')

B. WHERE SUBSTR(cust_name, INSTR(cust_name,' ') + 1) LIKE 'Mc%' OR 'MC%'

C. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) LIKE 'Mc%'

D. WHERE SUBSTR(cust_name, INSTR(cust_name,' ') + 1) LIKE 'Mc%'

E. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) IN ('MC%','Mc%')

A. An alias name must not be used in a GROUP BY clause.

B. An alias name must not be used in an ORDER BY clause.

C. An alias name must always be specified in quotes.

D. An allas name must not contain space characters.

A. TIMESTAMP WITH LOCAL TIMEZONE

B. TIMESTAMP WITH TIMEZONE

C. TIMESTAMP

D. INTERVAL DAY TO SECOND

E. INTERVAL YEAR TO MONTH

A. SELECT * FROM customers WHERE insert_ date = DATE '2019-01-01';

B. SELECT * FROM customers WHERE TO_ CHAR (customer_ id) ='0001';

C. SELECT * FROM customers WHERE insert date ='01-JAN-19'

D. SELECT * FROM customers WHERE customer_ id = 0001 ;

E. SELECT * FROM customers WHERE customer id = '0001';

A. The WITH GRANT OPTION clause can be used only by DBA users

B. An object privilege can be granted to a role only by the owner of that object

C. The owner of an object acquires all object privilege on that object by default

D. A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table

E. An object privilege can be granted to other users only by the owner of that object