The Oracle 1Z0-061 Sample Question Set is designed to help you prepare for the Oracle Database 12c - SQL Fundamentals (1Z0-061) certification exam. To become familiar with actual Oracle Certification exam environment, we suggest you to try Sample Oracle 1Z0-061 Certification Practice Exam.
This sample Oracle 1Z0-061 certification practice exam is designed for evaluation purposes only. If you really want to test your knowledge to identify your weak areas and familiarize with actual exam format, we suggest you to practice with Premium Oracle 1Z0-061 Certification Practice Exam for Oracle Database 12c - SQL Fundamentals (1Z0-061) certification. Our team of Oracle Database experts have designed Questions-Answers for this premium practice exam by collecting inputs from recently certified candidates. Hence, We strongly recommend you to use Premium Oracle 1Z0-061 Certification Practice Exam to clear your actual Oracle 1Z0-061 Certification Exam with great score.
1Z0-061 Sample Questions:
01. Which two statements are true regarding constraints?
a) A table can have only one primary key and one foreign key.
b) A table can have only one primary key but multiple foreign keys.
c) Only the primary key can be defined at the column and table levels.
d) The foreign key and parent table primary key must have the same name.
e) Both primary key and foreign key constraints can be defined at both column and table levels.
02. In which three situations does a transaction complete?
a) When a DELETE statement is executed
b) When a ROLLBACK command is executed
c) When a PL/SQL anonymous block is executed
d) When a data definition language (DDL) statement is executed
e) When a TRUNCATE statement is executed after the pending transaction
03. Which two statements are true regarding single row functions?
a) MOD: returns the quotient of a division
b) TRUNC: can be used with number and date values
c) CONCAT: can be used to combine any number of values
d) SYSDATE: returns the database server current date and time
e) INSTR: can be used to find only the first occurrence of a character in a string
f) TRIM: can be used to remove all the occurrences of a character from a string
04. Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1)
What would be the outcome?
05. Which statement is true regarding the default behavior of the order by clause?
a) In a character sort, the values are case-sensitive.
b) NULL values are not considered at all by the sort operation.
c) Only those columns that are specified in the select list can be used in the order by clause.
d) Numeric values are displayed from the maximum to the minimum value if they have decimal positions.
06. You issue the following command to drop the products table:
SQL> DROP TABLE products;
Which three statements are true about the implication of this command?
a) All data along with the table structure is deleted.
b) A pending transaction in the session is committed.
c) All indexes on the table remain but they are invalidated.
d) All views and synonyms remain but they are invalidated.
e) All data in the table is deleted but the table structure remains.
07. Which three tasks can be performed using SQL functions built into Oracle Database?
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
08. Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
a) First normal form
b) Second normal form
c) Third normal form
d) Fourth normal form
09. Which two statements are true regarding the count function?
a) The count function can be used only for CHAR, VARCHAR2, and NUMBER data types.
b) Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.
c) Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.
d) Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.
e) A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.
10. Examine the types and examples of relationships that follow:
1. One-to-one a) Teacher to students
2. One-to-many b) Employees to Manager
3. Many-to-one c) Person to SSN
4. Many-to-many d) Customers to products
Which option indicates the correctly matched relationships?
a) 1-a, 2-b, 3-c, and 4-d
b) 1-c, 2-d, 3-a, and 4-b
c) 1-c, 2-a, 3-b, and 4-d
d) 1-d, 2-b, 3-a, and 4-c
Answer: b, e
Answer: b, d, e
Answer: b, d
Answer: a, b, d
Answer: a, b, c
Answer: b, d