View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)

You executed this SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the result?

• A.The values in the FIRST_NAME column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
• B.The values in the all columns would be returned in descending order.
• C.The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
• D.The values in the FIRST_NAME column would be returned in ascending order for all employees having the same value in the DEPARTMENT_ID column.
• E.The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the BOOKS_TRANSACTIONS table:

Examine this partial SQL statement:
SELECT * FROM books_transactions
Which two WHERE conditions give the same result?

• A.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');
• B.WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101', 'A102');
• C.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = A101' OR member_id = 'A102'));
• D.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');
• E.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR member_id IN ('A101', 'A102'));

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about sequences created in a single instance Oracle database? (Choose two.)

• A.When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
• B.DELETE <sequencename> would remove a sequence from the database.
• C.The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
• D.CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
• E.When a database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.

Comment: *

Name: *

Email: *

Verification: *

Which three are true?

• A.LAST_DAY returns the date of the last day of the current ,month onlyu.
• B.ADD_MONTHS works with a character string that can be implicitlyt converted to a DATE data type.
• C.ADD_MONTHS adds a number of calendar months to a date.
• D.CEIL returns the largest integer less than or equal to a specified number.
• E.CEIL requires an argument which is a numeric data type.
• F.LAST_DAY return the date of the last day the previous month only.
• G.LAST_DAY returns the date of the last day of the month for the date argument passed to the function.

Comment: *

Name: *

Email: *

Verification: *

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 LIKE 'D_';
• B.SELECT * FROM customers WHERE city = '%D_';
• C.SELECT * FROM customers WHERE city = 'D_%';
• D.SELECT * FROM customers WHERE city LIKE 'D_%';

Comment: *

Name: *

Email: *

Verification: *