Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Pass the Oracle PL 1z0-071 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-071 Premium Access

View all detail and faqs for the 1z0-071 exam

Go to Exam

401 Students Passed

87% Average Score

97% Same Questions

Viewing page 1 out of 10 pages

Viewing questions 1-10 out of questions

Questions # 1:

Which three are true about privileges and roles?

Options:

A role is owned by the user who created it.

System privileges always set privileges for an entire database.

All roles are owned by the SYS schema.

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

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

PUBLIC can be revoked from a user.

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

Questions # 2:

You need to calculate the number of days from 1st January 2019 until today.

Dates are stored in the default format of DD-MON-RR.

Which two queries give the required output?

Options:

SELECT SYSDATE-TO_DATE ('01-JANUARY-2019') FROM DUAL;

SELECT TO_DATE (SYSDATE, 'DD/MONTH/YYYY')-'01/JANUARY/2019' FROM DUAL;

SELECT ROUND (SYSDATE-TO_DATE ('01/JANUARY/2019')) FROM DUAL;

SELECT TO_CHAR (SYSDATE, 'DD-MON-YYYY')-'01-JAN-2019' FROM DUAL;

SELECT ROUND (SYSDATE- '01-JAN-2019') FROM DUAL:

Questions # 3:

Which two statements cause changes to the data dictionary?

Options:

DELETE FROM scott. emp;

GRANT UPDATE ON scott. emp TO fin manager;

AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

TRUNCATE TABLE emp:

SELECT * FROM user_ tab._ privs;

Questions # 4:

Which two are true about granting privilege on objects?

Options:

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

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

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

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

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

Questions # 5:

Examine this query:

SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3;

What is returned upon execution?

Questions # 6:

Which statement is true about aggregate functions?

Options:

The AVG function implicitly converts NULLS to zero

The MAX and MIN functions can be used on columns with character data types

Aggregate functions can be used in any clause of a SELECT statement

Aggregate functions can be nested to any number of levels

Questions # 7:

Which two are true about scalar subquery expressions?

Options:

You cannot correlate them with a table in the parent statement

You can use them as a default value for a column.

.You must enclose them in parentheses.

They can return at most one row.

They can return two columns.

Questions # 8:

Examine the description of the transactions table:

Which two SQL statements execute successfully?

Options:

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

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

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

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

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

Questions # 9:

Which three statements are true about Data Manipulation Language (DML)?

Options:

delete statements can remove multiple rows based on multiple conditions.

insert statements can insert nulls explicitly into a column.

insert into. . .select. . .from statements automatically commit.

DML statements require a primary key be defined on a table.

update statements can have different subqueries to specify the values for each updated column.

Questions # 10:

Examine this description of the PRODUCTS table:

You successfully execute this command:

CREATE TALE new_prices(prod_id NUBER(2),price NUMBER(8,2));

Which two statements execute without errors?

Options:

MERGE INTO new_prices n

USING(SELECT*FROM products)p

WHEN MATECHED THEN

UPDATE SET n.price=p.cost*.01

WHEN NOT MATCHED THEN

INSERT(n.prod_id,n.price)VALUES (p.prod_id,cost*01)

WHERE(p.cost<200);

MERGE INTO new_prices n

USING(SELECT*FROM product WHERE cost>150) p

ON (n.prod_id=p.prod_id)

WHEN NATCHED THEN

DELETE WHERE(p.cost<200)

WHEN NOT MATCHED THEN

INSERT (n.prod_id,n.price)VALUES (p.prod_id,p.cost*.01);

MERGE INTO new_prices n

USING (SELECT * FROM products WHERE cost>150) p

ON (n.prod_id=p.prod_id)

WHEN NATCHED THEN

UPDATE SET n.price=p.cost*.01

DELETE WHERE (p.cost<200);

MERGE INTO new_prices n

USING products p

WHEN NOT NATCHED THEN

INSERT (n.prod_id, n.price)VALUES (p.prod_id,cost*.01)

WHERE (p.cost <200);

Viewing page 1 out of 10 pages

Viewing questions 1-10 out of questions

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25

ADM-201

Agentforce-Specialist

CMMC-CCP

Data-Cloud-Consultant

PCNSE

PDI

PSE-Strata-Pro-24

Secure-Software-Design

Sharing-and-Visibility-Architect

Workday-Pro-Integrations

ZDTA