Free Oracle 1z1-061 Exam Dumps Questions & Answers

Which two statements are true regarding the USING clause in table joins? (Choose two.)

• A.  It can be used to join a maximum of three tables.
• B.  It can be used to restrict the number of columns used in a NATURAL join.
• C.  It can be used to access data from tables through equijoins as well as nonequijoins.
• D.  It can be used to join tables that have columns with the same name and compatible data types.

Evaluate the following query:

What would be the outcome of the above query?

• A.  It produces an error because the data types are not matching.
• B.  It executes successfully and introduces an 's at the end of each PROMO_NAME in the output.
• C.  It produces an error because flower braces have been used.
• D.  It executes successfully and displays the literal "{'s start date was \} * for each row in the output.

In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:

What would be the outcome?

• A.  An error message
• B.  Abigail PA
• C.  Abigail IS
• D.  Abigail Pa

Which two statements are true regarding views? (Choose two.)

• A.  A view is created with the sub query having the DISTINCT keyword can be updated
• B.  A sub query that defines a view cannot include the GROUP BY clause
• C.  A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table
• D.  A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated

You create a sequence as follows:
create sequence seq1 start with 1;
After selecting from it a few times, you want to reinitialize it to reissue the numbers already generated.
How can you do this?

• A.  Use the command ALTER SEQUENCE SEQ1 CYCLE; to reset the sequence to its starting value.
• B.  You must drop and re-create the sequence.
• C.  You can't. Under no circumstances can numbers from a sequence be reissued once they have been used.
• D.  Use the command ALTER SEQUENCE SEQ1 START WITH 1; to reset the next value to 1.