Create Next App

Exam contains 287 questions

Page 3 of 48

Question 13 🔥

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

Which database solution meets these requirements?

A. SELECT TO_CHAR(1890.55,'$99G999D00')FROM DUAL;

Highly voted

B. SELECT TO_CHAR(1890.55,'$9,999V99')FROM DUAL;

Highly voted

C. SELECT TO_CHAR(1890.55,'$0G000D00')FROM DUAL;

Highly voted

D. SELECT TO_CHAR(1890.55,'$99G999D99')FROM DUAL;

Highly voted

E. SELECT TO_CHAR(1890.55,'$9,999D99')FROM DUAL;

Highly voted

Discussion of the question

Question 14 🔥

Evaluate the SQL statement -DROP TABLE DEPT:Which four statements are true of the SQL statement? (Choose four)

Which database solution meets these requirements?

A. You cannot roll back this statement.

Highly voted

B. All pending transactions are committed.

Highly voted

C. All views based on the DEPT table are deleted.

Highly voted

D. All indexes based on the DEPT table are dropped.

Highly voted

E. All data in the table is deleted, and the table structure is also deleted.

Highly voted

F. All data in the table is deleted, but the structure of the table is retained.

Highly voted

G. All synonyms based on the DEPT table are deleted.

Highly voted

Discussion of the question

Question 15 🔥

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

Which database solution meets these requirements?

A. 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

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

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 positional notation cannot be used in the ORDER BY clause with SET operators A

Highly voted

Discussion of the question

Question 16 🔥

You are granted the CREATE VIEW privilege. What does this allow you to do?

Which database solution meets these requirements?

A. Create a table view.

Highly voted

B. Create a view in any schema.

Highly voted

C. Create a view in your schema.

Highly voted

D. Create a sequence view in any schema.

Highly voted

E. Create a view that is accessible by everyone.

Highly voted

F. Create a view only of it is based on tables that you created.

Highly voted

Discussion of the question

Question 17 🔥

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 18 🔥

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)

Which database solution meets these requirements?

A. It releases the storage space used by the table.

Highly voted

B. It does not release the storage space used by the table.

Highly voted

C. You can roll back the deletion of rows after the statement executes.

Highly voted

D. You can NOT roll back the deletion of rows after the statement executes.

Highly voted

E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

Highly voted

F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_051

Exam contains 287 questions

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

Company

Product

Resources

Follow us