1z1-071試験無料問題集「Oracle Database SQL 認定」

A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;

B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level != NULL;

D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;

A. the ACCESS PARAMETERS clause

B. the access driver TYPE clause

C. the REJECT LIMIT clause

D. the LOCATION clause

E. the DEFAULT DIRECTORY clause

A. It returns the number of rows in BRICKS plus the number of rows in COLORS.

B. You can add an ON clause with a join condition.

C. You can add a WHERE clause with filtering criteria.

D. It returnsthe same rows as SELECT * FROM bricks CROSS JOIN colors.

E. You can add a USING clause with a join condition.

A. SELCECT last_namo, (monthly_salary * 12) + (monthly_commission_pct * 12) AS annual_comp FROM employees

B. SECECT last_namo, (menthy_salary + monthly_commission_pct) * 12 AS annual_comp FROM employees;

C. SELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * NVL (monthly_commission_pct, 0)) AS annual_comp FROM employees

D. SELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * monthly_commission_pct) AS annual_comp FROM employees

A. only &mgr_id

B. none

C. &hiredate and &mgr_id

D. only &hiredate

A. The on clause can be used.

B. The query must use two different aliases for the table.

C. The on clause must be used.

D. It must be an equijoin.

E. It must be an inner join.

F. It can be an outer join.

A. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

B. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

C. INTERVAL YEAR TO MONTH columns support yearly intervals.

D. INTERVAL DAY TO SECOND columns support fractions of seconds.

E. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

F. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

A. All roles are owned by the SYS schema.

B. PUBLIC can be revoked from a user.

C. A role can contain a combination of several privileges and roles.

D. System privileges always set privileges for an entire database.

E. A user has all object privileges for every object in their schema by default.

F. PUBLIC acts as a default role granted to every user in a database

G. A role is owned by the user who created it.

A. They can contain HAVING clauses.

B. Two or more values are always returned from the subquery.

C. They can return multiple columns.

D. They can contain GROUP BY clauses.

E. They cannot contain subquery.

A. 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
);

B. SELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE 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
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

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

A. using single-row functions in the WHERE clause requires a subquery

B. False. Aggregate functions are intended to be used in the HAVING clause, which is specifically for filtering groups of rows after they have been aggregated, and they do not require a subquery to be used there.

C. using single-row functions in the HAVING clause requires a subquery

D. using aggregate functions in the HAVING clause requires a subquery

E. using aggregate functions in the WHERE clause requires a subquery

A. SELECT" FROM order_ items WHERE FLOOR (quantity / 10) = TRUNC (quantity / 10);

B. SELECT FROM order_ items WHERE quantity / 10 = TRUNC (quantity);

C. SELECT" FROM order_ _items WHERE quantity = ROUND (quantity, 1);

D. SELECT * FROM order_ items WHERE quantity = TRUNC (quantity, -1);

E. SELECT * FROM order_ items WHERE MOD (quantity, 10) = 0;

A. Implementing a relationship between two tables might require joining additional tables.

B. Rows from unrelated tables cannot be joined.

C. Relating data from a table with data from the same table is implemented with a self join.

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. 11-JUL-2019 6,00,00,000000 AM

B. 11-JUL-2019 6,00,00,00000000 AM - 05:00

C. 11-JUL-2019 11,00,00,00000000 AM

D. 11-JUL-2019 11,00,00,000000AM -05:00

A. The subquery is not a correlated subquery.

B. All existing rows in the EMPLOYEE table are deleted.

C. The subquery is executed for every row in the EMPLOYEES table.

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 single role can be assigned to multiple users.

B. A single user can be assigned multiple roles

C. Privileges are assigned to a role using the ALTER ROLE statement.

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

E. Roles are assigned to users using the ALTER USER statement

F. Roles are assigned to roles using the ALTER ROLE Statement

G. Privileges are assigned to a role using the GRANT statement.

A. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));

B. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

C. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');

D. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

E. WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101','A102');