20:00

PDF|

Guide for Oracle Database 12c: SQL Fundamentals

Quiz Oracle Database 12c: SQL Fundamentals

Free Test
/ 10

Quiz

1/10
Examine the structure proposed for the transactions table:


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 12


Which two statements are true regarding the creation and storage of data in the above table structure?
Select the answer
2 correct answers
A.
The CUST_STATUS column would give an error.
B.
The TRANS_VALIDITY column would give an error.
C.
The CUST_STATUS column would store exactly one character.
D.
The CUST_CREDIT_LIMIT column would not be able to store decimal values.
E.
The TRANS_VALIDITY column would have a maximum size of one character.
F.
The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds,
and fractions of seconds

Quiz

2/10
Evaluate the following SQL statement:


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 2


Which statement is true regarding the outcome of the above query?
Select the answer
1 correct answer
A.
It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
B.
It produces an error because positional notation cannot be used in the order by clause with set
operators.
C.
It executes successfully but ignores the order by clause because it is not located at the end of the
compound statement.
D.
It produces an error because the order by clause should appear only at the end of a compound query-
that is, with the last select statement.

Quiz

3/10
View the Exhibit and examine the structure of the product, component, and PDT_COMP tables.
In product table, PDTNO is the primary key.
In component table, COMPNO is the primary key.
In PDT_COMP table, <PDTNO, COMPNO) is the primary key, PDTNO is the foreign key referencing
PDTNO in product table and COMPNO is the foreign key referencing the COMPNO in component table.
You want to generate a report listing the product names and their corresponding component names, if the
component names and product names exist.
Evaluate the following query:
SQL>SELECT pdtno, pdtname, compno, compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING (compno)
WHERE compname IS NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct output?


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 3
Select the answer
1 correct answer
A.
JOIN; JOIN
B.
FULL OUTER JOIN; FULL OUTER JOIN
C.
RIGHT OUTER JOIN; LEFT OUTER JOIN
D.
LEFT OUTER JOIN; RIGHT OUTER JOIN

Quiz

4/10
View the Exhibit for the structure of the student and faculty tables.


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 4


You need to display the faculty name followed by the number of students handled by the faculty at the
base location.
Examine the following two SQL statements:


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 5


Which statement is true regarding the outcome?
Select the answer
1 correct answer
A.
Only statement 1 executes successfully and gives the required result.
B.
Only statement 2 executes successfully and gives the required result.
C.
Both statements 1 and 2 execute successfully and give different results.
D.
Both statements 1 and 2 execute successfully and give the same required result.

Quiz

5/10
View the Exhibits and examine products and sales tables.


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 6




Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 7


You issue the following query to display product name and the number of times the product has been sold:


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 8


What happens when the above statement is executed?
Select the answer
1 correct answer
A.
The statement executes successfully and produces the required output.
B.
The statement produces an error because item_cnt cannot be displayed in the outer query.
C.
The statement produces an error because a subquery in the from clause and outer-joins cannot be
used together.
D.
The statement produces an error because the group by clause cannot be used in a subquery in the
from clause.

Quiz

6/10
You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID
must be unique and not null. Which two SQL statements would create the required table?


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 9
Select the answer
2 correct answers
A.
Option A
B.
Option B
C.
Option C
D.
Option D
E.
Option E
F.
Option F

Quiz

7/10
View the Exhibit and examine the structure of the products table.


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 10


Using the products table, you issue the following query to generate the names, current list price, and
discounted list price for all those products whose list price falls below $10 after a discount of 25% is
applied on it.


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 11


The query generates an error. What is the reason for the error?
Select the answer
1 correct answer
A.
The parenthesis should be added to enclose the entire expression.
B.
The double quotation marks should be removed from the column alias.
C.
The column alias should be replaced with the expression in the where clause.
D.
The column alias should be put in uppercase and enclosed within double quotation marks in the where
clause.

Quiz

8/10
You need to create a table for a banking application. One of the columns in the table has the following
requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and subtracted with
date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?
Select the answer
1 correct answer
A.
DATE
B.
NUMBER
C.
TIMESTAMP
D.
INTERVAL DAY TO SECOND
E.
INTERVAL YEAR TO MONTH

Quiz

9/10
Which three tasks can be performed using SQL functions built into Oracle Database?
Select the answer
3 correct answers
A.
Displaying a date in a nondefault format
B.
Finding the number of characters in an expression
C.
Substituting a character string in a text expression with a specified string
D.
Combining more than two columns or expressions into a single column in the output

Quiz

10/10
View the Exhibit and examine the description of SALES and PROMOTIONS tables.


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 13


You want to delete rows from the sales table, where the PROMO_NAME column in the promotions table
has either blowout sale of everyday low prices as values.
Which three delete statements are valid?


Certification Exam Oracle Database 12c: SQL Fundamentals Oracle Oracle-1Z0-061 14
Select the answer
3 correct answers
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Looking for more questions?Buy now

Oracle Database 12c: SQL Fundamentals Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Oracle Database 12c: SQL Fundamentals practice test! Further deepen your knowledge on Oracle Simulator; by unlocking the full version of our Oracle Database 12c: SQL Fundamentals Simulator you will be able to take tests with over 305 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 305 questions.

BUY NOW

What to expect from our Oracle Database 12c: SQL Fundamentals practice tests and how to prepare for any exam?

The Oracle Database 12c: SQL Fundamentals Simulator Practice Tests are part of the Oracle Database and are the best way to prepare for any Oracle Database 12c: SQL Fundamentals exam. The Oracle Database 12c: SQL Fundamentals practice tests consist of 305 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Oracle Database 12c: SQL Fundamentals database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Oracle Database 12c: SQL Fundamentals Simulator will also give you an idea of the time it will take to complete each section of the Oracle Database 12c: SQL Fundamentals practice test . It is important to note that the Oracle Database 12c: SQL Fundamentals Simulator does not replace the classic Oracle Database 12c: SQL Fundamentals study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Oracle Database 12c: SQL Fundamentals exam.

BUY NOW

Oracle Database 12c: SQL Fundamentals Practice test therefore represents an excellent tool to prepare for the actual exam together with our Oracle practice test . Our Oracle Database 12c: SQL Fundamentals Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Oracle Database 12c: SQL Fundamentals Simulator and how our unique Oracle Database 12c: SQL Fundamentals Database made up of real questions:

Info quiz:

  • Quiz name:Oracle Database 12c: SQL Fundamentals
  • Total number of questions:305
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Oracle Database 12c: SQL Fundamentals exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Oracle Database 12c: SQL Fundamentals Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Oracle Database 12c: SQL Fundamentals Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Oracle Database 12c: SQL Fundamentals practice tests which consist of 305 questions and also provide study material to pass the final Oracle Database 12c: SQL Fundamentals exam with guaranteed success. Our Oracle Database 12c: SQL Fundamentals database contain hundreds of questions and Oracle Tests related to Oracle Database 12c: SQL Fundamentals Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW