Create Next App

Exam contains 339 questions

Page 5 of 57

Question 25 🔥

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?

Which database solution meets these requirements?

A. SELECT TO_CHAR(TO_DATE('19-Mar-2001, DD-Mon-YYYY), fmDdspth "of" Month YYYY fmHH:MI:SS AM’) NEW_DATE . FROM dual;

Highly voted

B. SELECT TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), Ddspth "of" Month YYYY fmHH:MI:SS AM’) NEW_DATE FROM dual;

Highly voted

C. SELECT TO_CHAR(TO_DATE(’19-Mar-2001’, ‘DD-Mon-YYYY’), ‘fmDdspth "of" Month YYYY HH:MI:SS AM) NEW_DATE FROM dual;

Highly voted

D. SELECT TO_CHAR(TO_DATE(’19-Mar-2001’, ‘DD-Mon-YYYY), ‘fmDdspth "of" Month YYYYfmtHH:HI:SS AM') NEW_DATE FROM dual;

Highly voted

Discussion of the question

Question 26 🔥

Examine the structure proposed for the transactions table:Which two statements are true regarding the creation and storage of data in the above table structure?

Which database solution meets these requirements?

A. The CUST_STATUS column would give an error.

Highly voted

B. The TRANS_VALIDITY column would give an error.

Highly voted

C. The CUST_STATUS column would store exactly one character.

Highly voted

D. The CUST_CREDIT_LIMIT column would not be able to store decimal values.

Highly voted

E. The TRANS_VALIDITY column would have a maximum size of one character.

Highly voted

F. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds

Highly voted

Discussion of the question

Question 27 🔥

You need to create a table named ORDERS that contain four columns:1. AN ORDER_ID column of number data type2. A CUSTOMER_ID column of number data type3. AN ORDER_STATUS column that contains a character data type4. A DATE_ORDERED column to contain the date the order was placed.When a row is inserted into the table, if no value is provided when the order was placed, todays date should be used instead.Which statement accomplishes this?

Which database solution meets these requirements?

A. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

Highly voted

B. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

Highly voted

C. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

Highly voted

D. CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

Highly voted

E. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);

Highly voted

F. CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

Highly voted

Discussion of the question

Question 28 🔥

Which statement correctly describes SQL and /SQL*Plus?

Which database solution meets these requirements?

A. Both SQL and /SQL*plus allow manipulation of values in the database.

Highly voted

B. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

Highly voted

C. /SQL*Plus is a language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

Highly voted

D. SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database.

Highly voted

Discussion of the question

Question 29 🔥

For which action can you use the TO_DATE function?

Which database solution meets these requirements?

A. Convert any date literal to a date

Highly voted

B. Convert any numeric literal to a date

Highly voted

C. Convert any character literal to a date

Highly voted

D. Convert any date to a character literal

Highly voted

E. Format ’10-JAN-99’ to ‘January 10 1999’

Highly voted

Discussion of the question

Question 30 🔥

Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?

Which database solution meets these requirements?

A. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

Highly voted

B. It produces an error because positional notation cannot be used in the order by clause with set operators.

Highly voted

C. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

Highly voted

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.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_061

Exam contains 339 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us