Free Access to Oracle.1Z0-082.v2023-10-20.q105 with Valid Practice Test (Page 17)

Question 76

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

A.The sales user must have a quota on the TEMP tablespace
B.The sales user must have their quota on the users tablespace removed
C.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
D.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
E.The sales user must have been granted the CREATE SESSION privilege
F.The sales user must have been granted the CREATE TABLE privilege

Question 77

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A.The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.
B.The number, but not names, of columns must be identical for all SELECT statements in the query.
C.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
D.The names and number of columns must be identical for all SELECT statements in the query.
E.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Question 78

Which three statements are true about views in an Oracle database? (Choose three.)

A.The WITH CHECK clause prevents certain rows from being displayed when querying the view
B.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
C.Data Manipulation Language (DML) can always be used on views
D.Tables in the defining query of a view must always exist in order to create the view
E.Views can be updated without the need to re-grant privileges on the view
F.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
G.The WITH CHECK clause prevents certain rows from being updated or inserted

Question 79

Which three statements are true about inner and outer joins? (Choose three.)

A.Outer joins can be used when there are multiple join conditions on two tables
B.Outer joins can only be used between two tables per query
C.An inner join returns matched rows
D.A full outer join must use Oracle syntax
E.A left or right outer join returns only unmatched rows
F.A full outer join returns matched and unmatched rows

Question 80

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

A.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
B.SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;
C.SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;
D.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
E.SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File