Create Next App

Exam contains 339 questions

Page 7 of 57

Question 37 🔥

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)LAST_NAME VARCHAR2 (25)JOB_ID VARCHAR2(10)You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?

Which database solution meets these requirements?

A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_' ESCAPE '\';

Highly voted

B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

Highly voted

C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\";

Highly voted

D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

Highly voted

Discussion of the question

Question 38 🔥

See the Exhibit and examine the structure of ORD table:Exhibit:Evaluate the following SQL statements that are executed in a user session in the specified order:CREATE SEQUENCE ord_seq;SELECT ord_seq.nextval -FROM dual;INSERT INTO ord -VALUES (ord_seq.CURRVAL, 25-jan-2007, 101);UPDATE ord -SET ord_no= ord_seq.NEXTVAL -WHERE cust_id =101;What would be the outcome of the above statements?

Which database solution meets these requirements?

A. All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101.

Highly voted

B. The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified.

Highly voted

C. The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified.

Highly voted

D. All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20.

Highly voted

Discussion of the question

Question 39 🔥

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which MERGE statement is valid?

Which database solution meets these requirements?

A. MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

Highly voted

B. MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT valueS(e.employee_id, e.first_name ||', '||e.last_name);

Highly voted

C. MERGE INTO new_employees cUSING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET F.name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

Highly voted

D. MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees valueS(e.employee_id, e.first_name ||', '||e.last_name);

Highly voted

Discussion of the question

Question 40 🔥

Which three SQL statements would display the value 1890.55 as $1, 890.55?

Which database solution meets these requirements?

A. Option A

Highly voted

B. Option B

Highly voted

C. Option C

Highly voted

D. Option D

Highly voted

Discussion of the question

Question 41 🔥

Which two statements are true about constraints? (Choose two.)

Which database solution meets these requirements?

A. The UNIQUE constraint does not permit a null value for the column.

Highly voted

B. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

Highly voted

C. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

Highly voted

D. The NOT NULL constraint ensures that null values are not permitted for the column.

Highly voted

Discussion of the question

Question 42 🔥

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