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

A. A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

B. A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.

C. A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.

D. PRIMARY KEY and FOREIGNY constraints can be specified at the column and at the table level

E. A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parenttable must have the same names.

F. NOT NULL can be specified at the column and at the table level.

A. Insert statements can always be done on a table through a view.

B. Views cannot be used to add on modify rows in an underlying table if the defining query of the view contains aggregating functions.

C. Views cannot be used to query rows from an underlying table if the table has a PRIPOARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

D. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

E. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

F. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

A. SELECT promo_cost, promo_category FROM promotions ORDER BY 1

B. select DISTINCT promo_categoryIl 'has'||promol_cost as COSTS FROM promotions ORDER BY 1:

C. SELECT promo_category, DISTINCT promo_cost FROM promotiong ORDER BY 2:

D. SELECT DISTINCT promo_cost ||'in'IIDISTINCT promo_category promotions ORDER BY1:

E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

A. EXPIRY_ DATE cannot be used in arithmetic expressions.

B. PRODUCT_ PRICE contains the value zero by default if no value is assigned to it.

C. PRODUCT_ PRICE can be used in an arithmetic expression even if it has no value stored in it.

D. PRODUCT_ NAME cannot contain duplicate values.

E. PRODUCT_ ID can be assigned the PRIMARY KEY constraint.

F. EXPIRY_ DATE contains the SYSDATE by default if no date is assigned to it.

A. SELECT dept_id, join date, SUM(salary) FROM employees GROUP BY dept_id,join_date;

B. SELECT dept_id, AVG(NAX(salary)) FROM employees GROUP BY dept_id;

C. SELECT dept_id, MAX (AVG(salary)) FROM employees GROUP BY dept_id;

D. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

A. WHERE (UPPER(cust_last_name) LIKE 'A%' OR UPPER(cust_last_name) LIKE 'B%') AND ROUND(cust_credit_limit) < 1000;

B. WHERE UPPER(cust_last_name) IN ('A%', 'B%') AND cust_credit_limit < 1000:

C. WHERE (INITCAP(cust_last_name) LIKE 'A%' OR ITITCAP(cust_last_name) LIKE 'B%') AND cust_credit_limit < 1000

D. WHERE (UPPER(cust_last_name) like INITCAP ('A') OR UPPER(cust_last_name) like INITCAP('B')) AND ROUND(cust_credit_limit) < ROUND(1000) ;

E. WHERE UPPER(cust_last_name) BETWEEN UPPER('A%' AND 'B%') AND ROUND(cust_credit_limit) < 1000;

A. SELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

B. SELECT MAX (salary)
FROM employees
GROUP BY department_id;

C. SELECT MAX (salary)
FROM employees;

D. SELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

E. SELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

A. || has a higher order of precedence than +(addition)

B. NOT has a higher order of precedence than AND and OR in a condition.

C. Operators are evaluated before conditions.

D. + (addition) has a higher order of precedence than * (mliplpition)

E. AND and OR have the same order of precedence in a condition

A. It can be accessed only by the SYS user.

B. It can be used to display only constants or pseudo columns.

C. It can display multiple rows and columns.

D. It can be accessed by any user who has the SELECT privilege in any schema

E. It consists of a single row and single column of VARCHAR2 data type.

F. It can display multiple rows but only a single column.

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. CREATE SYNONYM PUBLIC.emp FOR hcm.employee_records;

B. CREATE SYNONYM SYS.emp FOR hcm.employee_records;

C. CREATE GLOBAL SYNONYM emp FOR hcm.employee_records;

D. CREATE SYNONYM emp FOR hcm.employee_records;

E. CREATE PUBLIC SYNONYM emp FOR hcm. employee_records;

A. 3 <null>

B. 2 <null>

C. 4 01-FEB-2019

D. 3 01-JAN-2019

E. 5 01-MAR-2019

F. 1 <null>

A. SELECT last_name,salary
FROM employees
FETCH FIRST 3 ROWS ONLY
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 (SELECT * FROM employees ORDER BY salary)

D. SELECT last_name, salary
FROM employees
WHERE ROWNUM<=3

E. SELECT last_name,salary
FROM employees
ORDER BY salary
FETCH FIRST 3 ROWS ONLY;

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

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

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

D. Roles are assigned to roles using the ALTER ROLE statement.

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

F. A single user can be assigned multiple roles.

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

A. 6

B. 12

C. 64

D. 3

A. FLOOR: returns the smallest integer greater than or equal to a specified number

B. CONCAT: can be used to combine any number of values

C. MOD: returns the quotient of a division operation

D. CEIL: can be used for positive and negative numbers

E. TRUNC: can be used with NUMBER and DATE values