Examine the description of the CUSTOMERS table: (Exhibit) You want to display details of all customers

By Singh | December 31, 2022

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

A. SELECT * FROM customers WHERE city = `D_%’;

B. SELECT * FROM customers WHERE city LIKE `D_%’;

C. SELECT * FROM customers WHERE city LIKE `D_’;

D. SELECT * FROM customers WHERE city = `%D_’;

Correct Answer: B

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this
Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You want to increase
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to