Is this exam completely free?

Examcademy offers a free preview for every exam, covering around 20% of the total questions. Full access is available with a paid upgrade.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! Examcademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our mock exams are built and reviewed with the help of AI and community contributions, staying aligned with real-world exam objectives.

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!

1z0-071Free trial

By oracle

Verified

25Q per page

Question 26

Which two queries execute successfully? (Choose two.)

A: SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL
B: SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;
C: SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;
D: SELECT INTERVAL '1' DAY + INTERVAL '1' MONTH FROM DUAL;
E: SELECT SYSDATE * INTERVAL '1' DAY FROM DUAL;

—

Question 27

Examine these statements which execute successfully:

Examine the result:

If LOCALTIMESTAMP was selected at the same time, what would it return?

A: 11-JUL-2019 6.00.00.00000000 AM -05:00
B: 11-JUL-2019 11.00.00.00000000 AM
C: 11-JUL-2019 6.00.00.00000000 AM
D: 11-JUL-2019 11.00.00.00000000 AM -05:00

—

Question 28

Examine these statements which execute successfully:

Which two are true? (Choose two.)

A: User FIN_CLERK can grant SELECT on SCOTT.EMP to user FIN_MANAGER.
B: Dropping user FINANCE will automatically revoke SELECT on SCOTT.EMP from user FIN_CLERK.
C: User FINANCE can grant CREATE SESSION to user FIN_MANAGER.
D: Revoking SELECT on SCOTT.EMP from user FINANCE will also revoke the privilege from user FIN_CLERK.
E: User FINANCE is unable to grant all on SCOTT.EMP to FIN_MANAGER.

—

Question 29

Which two are true about granting privileges on objects? (Choose two.)

A: An object privilege can be granted to other users only by the owner of that object.
B: The owner of an object acquires all object privileges on that object by default.
C: The WITH GRANT OPTION clause can be used only by DBA users.
D: An object privilege can be granted to a role only by the owner of that object.
E: A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table.

—

Question 30

Examine the description of the EMPLOYEES table:

Which two queries will execute successfully? (Choose two.)

A: SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id HAVING hire_date > '01-JAN-19';
B: SELECT dept_id, SUM(salary) FROM employees WHERE hire_date > '01-JAN-19' GROUP BY dept_id;
C: SELECT dept_id, MAX(SUM(salary)) FROM employees GROUP BY dept_id;
D: SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id, salary;
E: SELECT AVG(MAX(salary)) FROM employees GROUP BY salary;

—

Question 31

Which two statements are true about the rules of precedence for operators? (Choose two.)

A: The + binary operator has the highest precedence in an expression in a SQL statement.
B: The concatenation operator || is always evaluated before addition and subtraction in an expression.
C: Multiple parentheses can be used to override the default precedence of operators in an expression.
D: NULLS influence the precedence of operators in an expression.
E: Arithmetic operators with equal precedence are evaluated from left to right within an expression.

—

Question 32

Examine data in the BRICKS table:

Examine the BOXES table:

Which two queries only return CUBE? (Choose two.)

—

Question 33

Which two statements will return the names of the three employees with the lowest salaries? (Choose two.)

—

Question 34

Examine this query which executes successfully:

What will be the result?

A: It will return rows from both SELECT statements including duplicate rows.
B: It will return rows from both SELECT statements after eliminating duplicate rows.
C: It will return rows that are not common to both SELECT statements.
D: It will return rows common to both SELECT statements.

—

Question 35

You need to allow user ANDREW to:

Modify the TITLE and ADDRESS columns of your CUSTOMERS table.
GRANT that permission to other users.
Which statement will do this?

A: GRANT UPDATE ON customers.title, customers.address TO andrew;
B: GRANT UPDATE (title, address) ON customers TO andrew;
C: GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
D: GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;
E: GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;
F: GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;

—

Question 36

Which three statements are true about sequences in a single instance Oracle database? (Choose three.)

A: A sequence’s unallocated cached values are lost if the instance shuts down.
B: A sequence number that was allocated can be rolled back if a transaction fails.
C: A sequence can only be dropped by a DBA.
D: A sequence can issue duplicate values.
E: Sequences can always have gaps.
F: Two or more tables cannot have keys generated from the same sequence.

—

Question 37

Examine this description of the PRODUCTS table:

You successfully execute this command:

CREATE TABLE new_prices (prod_id NUMBER(2), price NUMBER(8,2))

Which two statements execute without errors? (Choose two.)

—

Question 38

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type number.

Which two queries execute successfully? (Choose two.)

A: SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;
B: SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers
C: SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
D: SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
E: SELECT TO_CHAR(NVL(cust_credit_iimit * .15, 'Not Available')) FROM customers;

—

Question 39

Examine this statement which executes successfully:

Which statement will violate the CHECK constraint?

—

Question 40

Which two are true about rollbacks? (Choose two.)

A: The ROLLBACK statement does not release locks resulting from table updates.
B: Data consistency is not guaranteed after a rollback.
C: A transaction interrupted by a system failure is automatically rolled back.
D: If the ROLLBACK statement is used without TO SAVEPOINT, then all savepoints in the transaction are deleted.
E: Data Control Language (DCL) statements, such as GRANT and REVOKE, can be rolled back.

—

Question 41

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

A: An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
B: A column that is set to UNUSED still counts towards the limit of 1000 columns per table.
C: A DROP COLUMN command can be rolled back.
D: A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
E: An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
F: Partition key columns cannot be dropped.

—

Question 42

Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)

A: Create a directory object for a flat file.
B: Create a directory object for an external table.
C: Read data from an external table and load it into a table in the database.
D: Execute DML statements on an external table.
E: Read data from a table in the database and insert it into an external table.
F: Query data from an external table.

—

Question 43

Which statement is true about aggregate functions?

A: Aggregate functions can be nested to any number of levels.
B: The AVG function implicitly converts NULLS to zero.
C: The MAX and MIN functions can be used on columns with character data types.
D: Aggregate functions can be used in any clause of a SELECT statement.

—

Question 44

Which three are true about multitable INSERT statements? (Choose three.)

A: They can insert each computed row into more than one table.
B: They can be performed on remote tables.
C: They can be performed on external tables using SQL*Loader.
D: They can be performed on views.
E: They can be performed only by using a subquery.
F: They can be performed on relational tables.

—

Question 45

Which three statements are true regarding single row subqueries? (Choose three.)

A: They must be placed on the left side of the comparison operator or condition.
B: They must be placed on the right side of the comparison operator or condition.
C: They must return a row to prevent errors in the SQL statement.
D: A SQL statement may have multiple single row subquery blocks.
E: They can be used in the HAVING clause.
F: They can be used in the WHERE clause.

—

Question 46

You own table DEPARTMENTS, referenced by views, indexes, and synonyms.
Examine this command which executes successfully:
DROP TABLE departments PURGE;
Which three statements are true? (Choose three.)

A: It will remove the DEPARTMENTS table from the database.
B: It will drop all indexes on the DEPARTMENTS table.
C: It will remove all views that are based on the DEPARTMENTS table.
D: It will remove all synonyms for the DEPARTMENTS table.
E: Neither can it be rolled back nor can the DEPARTMENTS table be recovered.
F: It will delete all rows from the DEPARTMENTS table, but retain the empty table.

—

Question 47

In your session NLS_DATE_FORMAT is set to DD-MON-RR.

Which two queries display the year as four digits? (Choose two.)

A: SELECT TO_DATE(SYSDATE, 'RRRR-MM-DD') FROM DUAL;
B: SELECT TO_CHAR(SYSDATE, MM/DD/YYYY) FROM DUAL;
C: SELECT TO_DATE(ADD_MONTHS(SYSDATE, 6), 'dd-non-yyyy') FROM DUAL;
D: SELECT TO_CHAR(ADD_MONTHS(SYSDATE, 6)) FROM DUAL;
E: SELECT TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;
F: SELECT TO_DATE(TO_CHAR(SYSDATE, 'MM/DD/YYYY'), 'MM/DD/YYYY') FROM DUAL;

—

Question 48

Which two are true about savepoints? (Choose two.)

A: After issuing a savepoint, you can roll back to the savepoint name within the current transaction.
B: They make uncommitted updates visible to sessions owned by other users.
C: You can commit updates done between two savepoints without committing other updates in the current transaction.
D: A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an error.
E: They make uncommitted updates visible to other sessions owned by the same user.
F: After issuing a savepoint, you cannot roll back the complete transaction.

—

Question 49

Examine these statements executed in a single Oracle session:

Which three statements are true? (Choose three.)

A: There is no row containing pencil.
B: The code for pen is 10.
C: There is no row containing fountain pen.
D: The code for pen is 1.
E: There is no row containing pen.
F: The code for fountain pen is 3.

—

Question 50

The ORDERS table has a column ORDER_DATE of data type DATE.

The default display format for a date is DD-MON-RR.

Which two WHERE conditions demonstrate the correct usage of conversion functions? (Choose two.)

A: WHERE order_date > TO_DATE(‘JUL 10 2018’, ‘ MON DD YYYY’)
B: WHERE order_date > TO_DATE(ADD_MONTH(SYSDATE, 6), ‘MON DD YYYY’)
C: WHERE order_date IN (TO_DATE(‘Oct 21 2018’, ‘Mon DD YYYY’), TO_CHAR(‘Nov 21 2018’, ‘Mon DD YYYY’))
D: WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), ‘MON DD YYYY’)
E: WHERE TO_CHAR(order_date. ‘MON DD YYYY’) = ‘JAN 20 2019’

—

Page 2 of 11 • Questions 26-50 of 267

←

1 2 3 4 5

→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!