Get real exam questions for 1Z0-061 Oracle Database 12c SQL Fundamentals. 100% Free.
Q1. 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. Abigail PA B. Abigail Pa C. Abigail IS D. An error message View AnswerAnswer: B Q2. View the Exhibit for the structure of the student and faculty tables. You need to display the faculty name followed b
Q1. 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 View AnswerAnswer: B,D,E Q2. View the Exhibit and examine the data in the
Q1. Which two statements are true regarding constraints? A. A foreign key cannot contain null values. B. A column with the unique constraint can contain null values. C. A constraint is enforced only for the insert operation on a table. D. A constraint can be disabled even if the constraint column contains data. E. All constraints can be defined at the column level as well as the table level.
Q1. Examine the structure of the orders table: You want to find the total value of all the orders for each year and issue the following command: Which statement is true regarding the outcome? A. It executes successfully and gives the correct output. B. It gives an error because the TO_CHAR function is not valid. C. It executes successfully but does not give the correct output. D. It gives a
Q1. 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.