Create Next App

Exam contains 287 questions

Page 9 of 48

Question 49 🔥

Which statement is true regarding the UNION operator?

Which database solution meets these requirements?

A. The number of columns selected in all SELECT statements need to be the same

Highly voted

B. Names of all columns must be identical across all SELECT statements

Highly voted

C. By default, the output is not sorted

Highly voted

D. NULL values are not ignored during duplicate checking

Highly voted

Discussion of the question

Question 50 🔥

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

Which database solution meets these requirements?

A. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

Highly voted

B. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

Highly voted

C. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;

Highly voted

D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;

Highly voted

E. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;

Highly voted

F. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

Highly voted

Discussion of the question

Question 51 🔥

Which two statements are true regarding working with dates? (Choose two.)

Which database solution meets these requirements?

A. The default internal storage of dates is in the numeric format.

Highly voted

B. The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required

Highly voted

C. The default internal storage of dates is in the character format

Highly voted

D. The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century

Highly voted

Discussion of the question

Question 52 🔥

Evaluate this SQL statement:SELECT ename, sal, 12*sal+100 FROM emp;The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?

Which database solution meets these requirements?

A. No change is required to achieve the desired results.

Highly voted

B. SELECT ename, sal, 12*(sal+100) FROM emp;

Highly voted

C. SELECT ename, sal, (12*sal)+100 FROM emp;

Highly voted

D. SELECT ename, sal+100,*12 FROM emp;

Highly voted

Discussion of the question

Question 53 🔥

View the Exhibit and examine the structure of the CUSTOMERS table.NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the CUSTOMERS table.Evaluate the following INSERT statement:The INSERT statement fails when executed. What could be the reason?

Which database solution meets these requirements?

A. The VALUES clause cannot be used in an INSERT with a subquery

Highly voted

B. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table

Highly voted

C. The WHERE clause cannot be used in a sub query embedded in an INSERT statement

Highly voted

D. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match

Highly voted

Discussion of the question

Question 54 🔥

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