Oracle 1Z1-082 Actual Free Exam Questions & Community Discussion
Examine the description of the product_details table:
Which two statements are true?
Which two statements are true?
Correct Answer: A,D
Vote an answer
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
Correct Answer: A,D
Vote an answer
Which three are types of segments in an Oracle Database? (Choose three.)
Correct Answer: A,C,F
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Which three statements are true about views in an Oracle database? (Choose three.)
Correct Answer: A,C,D
Vote an answer
Examine the description of the SALES1 table:
SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?
SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?
Correct Answer: E
Vote an answer
Which three failures do not require intervention for recovery? (Choose three.)
Correct Answer: A,C,E
Vote an answer
Which two statements are true about Database Instances and Real Application Clusters (RAC)?
Correct Answer: B,E
Vote an answer
In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
Correct Answer: B,C
Vote an answer
The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months.
Which where clause can be used?
Which where clause can be used?
Correct Answer: A
Vote an answer
Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.
(Choose three.)
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.
(Choose three.)
Correct Answer: A,C,D
Vote an answer
Which three statements are true about single-row functions? (Choose three.)
Correct Answer: A,D,E
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Examine the description of the members table:
Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?
Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?
Correct Answer: A,B
Vote an answer
Which two are true about conventional path SQL load? (Choose two.)
Correct Answer: C,D
Vote an answer
0
0
0
10