QUESTION: 65

Evaluate the following query:
SQL> SELECT TRUNC (ROUND(156.00, -1),-1)
FROM DUAL;

What would be the outcome?

Answer(s): C

Reference:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions135.htm https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_2127.htm

Show Answer Next Question

QUESTION: 66

Examine the data in the CUST_NAME column of the CUSTOMERS table.

You need to display customers' second names where the second name starts with "Mc" or "MC". Which query gives the required output?

Option A
Option B
Option C
Option D

Answer(s): C

Show Answer Next Question

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.

Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.

Evaluate the following CREATE TABLE command:

CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;

Which statement is true regarding the above command?

The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.

Answer(s): A

Show Answer Next Question

QUESTION: 68

Which two statements are true regarding the USING and ON clauses in table joins?

Both USING and ON clauses can be used for equijoins and nonequijoins.
A maximum of one pair of columns can be joined between two tables using the ON clause.
The ON clause can be used to join tables on columns that have different names but compatible data types.
The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause.

Answer(s): C,D

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps (page: 18)

QUESTION: 65

Reference:

QUESTION: 66

QUESTION: 67

QUESTION: 68

1Z0-071 Exam Discussions & Posts