Free Oracle 1z1-071 Exam Dumps Questions & Answers

Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level.
Which query would give the required result?

• A.SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers.
• B.SELECT cust_income_level || ` ' || cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers.
• C.SELECT DISTINCT cust_income_level || ` ' || cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers.
• D.SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers

Which two statements are true about sequences crated in a single instance Oracle database?

• A.CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
• B.When the database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.
• C.The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
• D.When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
• E.DELETE <sequencename> would remove a sequence from the database.

Which three tasks can be performed by DDL statements? (Choose three.)

• A.creating multiple savepoints to enable partial rollback of a transaction
• B.preventing data retrieval from a table outside of office hours
• C.modifying a table to prevent data that violate certain conditions from being entered in a column
• D.providing an alternative name for a table
• E.preventing any data modification to a table

Which three statements are true reading subqueries? (Choose three.)

• A.The subquery and main query can retrieve data from different tables.
• B.The subquery and main query must retrieve date from the same table.
• C.A subquery can have more than one main query.
• D.A Main query can have many subqueries.
• E.Multiple columns or expressions can be compared between the subquery and main query.
• F.Only one column or expression can be compared between the subquery and main query.

Which two statements are true about a full outer join? (Choose two.)

• A.It returns only unmatched rows from both tables being joined.
• B.The Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause.
• C.It returns matched and unmatched rows from both tables being joined.
• D.It includes rows that are returned by a Cartesian product.
• E.It includes rows that are returned by an inner join.