Online Access Free Oracle.1z1-071.v2022-04-29.q239 Practice Test (Page 28)

1z1-071 Exam Question 131

Which two are true about creating tables in an Oracle database?

A.A system privilege is required.

B.A create table statement can specify the maximum number of rows the table will contain.

C.A primary key constraint is manadatory.

D.Creating an external table will automatically create a file using the specified directory and file name.

E.The same table name can be used for tables in different schemas.

1z1-071 Exam Question 132

Examine the description of the EMPLOYEES table:

Which two queries return the highest salary in the table?

A.SELECT MAX (salary)
FROM employees;

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

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

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

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

1z1-071 Exam Question 133

Examine the structure of the BOOKS_TRANSACTIONStable:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?
SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM

A.BOOKS_TRANSACTIONS;
SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE"

B.BOOKS_TRANSACTIONS;
SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM

C.BOOKS_TRANSACTIONS;

D.FROM BOOKS_TRANSACTIONS;
SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM

1z1-071 Exam Question 134

View the Exhibit and examine the structure of CUSTOMERS table.
Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

A.SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;

B.SELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;

C.SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;

D.SELECT NVL(cust_credit_limit), 'Not Available') "NEW CREDIT"FROM customers;

1z1-071 Exam Question 135

Examine the description of the SALES table:

The SALES table has 55,000 rows.
Examine this statement:

Which two statements are true?

A.SALES1 is created with 1 row.

B.SALES1 is created with no rows.

C.SALES1 is created with 55,000 rows.

D.SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

E.SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.

Other Version: 113Oracle.Latestcram.1z1-071.v2022-05-31.by.martina.239q.pdf; 5753Oracle.1z1-071.v2021-12-09.q323; 115Oracle.Lead2passed.1z1-071.v2021-09-02.by.nelly.334q.pdf

Latest Upload: 105SAP.C_ABAPD_2507.v2025-09-12.q56; 104SAP.C_TS452_2022.v2025-09-12.q83; 171ACSM.020-222.v2025-09-11.q48; 157VMware.5V0-31.23.v2025-09-10.q73; 131Oracle.1z0-915-1.v2025-09-10.q24; 160Citrix.1Y0-231.v2025-09-10.q87; 138SAP.C-THR85-2505.v2025-09-09.q29; 168Adobe.AD0-E727.v2025-09-09.q76; 131Oracle.1Z0-1123-25.v2025-09-09.q20; 137SAP.C_SIGPM_2403.v2025-09-08.q20

1z1-071 Exam Question 131

1z1-071 Exam Question 132

1z1-071 Exam Question 133

1z1-071 Exam Question 134

1z1-071 Exam Question 135

Download PDF File