Oracle Database Sql Certified Associate Exam Questions & Answers

All 38 questions

1. Q1 View and examine the EMPLOYEES table structure.Table: EMPLOYEESName TypeEMP_ID NUMBER(6)EMP_NAME VARCHAR(20)EMP_STATUS CHARHIRE_DATE DATEFULLTIME_STATUS VARCHAR2SALARY NUMBERIdentify the true statements regarding the creation and…
2. Q2 View and examine the following available responses.Identify two true statements regarding a SAVEPOINT. (Choose two)
3. Q3 View and examine the following available responses.Identify the true statements about external tables. (Select two.)
4. Q4 View and examine the following SQL exhibit.Identify the situations where a new transaction always starts. (Choose three)
5. Q5 View and examine the SQL statement used to create the TRANSACTION table. Exhibit: 1CREATE TABLE transaction ( trn_id CHAR(2) PRIMARY KEY, start_date…
6. Q6 View and examine the description of the BOOKS_TRANSACTIONS table and exhibit.Table: BOOKS_TRANSACTIONS Name Null?? TypeTRANSACTION_ID NOT NULL VARCHAR2(6)TRANSACTION_TYPE NOT NULL VARCHAR2(3)BORROWED_DATE DATEBOOK_ID…
7. Q7 View and examine the following available responses.Identify the true statements about views. (Choose two.)
8. Q8 View and examine the following available responses.Indicate the responses which are equivalent to one another.
9. Q9 View and examine the following available responses.Identify the true statements regarding group functions. (Choose four.)
10. Q10 View and examine the following available responses.Examine this statement.MERGE INTO products pUSING promotions prON (p.promo_id = pr.promo_id)WHEN MATCHED THEN UPDATE SET p.price…
11. Q11 View and examine the following available responses.Indicate the statement that is true regarding the ordering of data in a SELECT statement.
12. Q12 View and examine the following SQL exhibit.Exhibit: 1SELECT TRUNC(ROUND(156.00, -1), -1)FROM DUAL;Identify the result of the query execution.
13. Q13 View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks would require subqueries? (Choose two)
14. Q14 View and examine the following available responses.Identify the true statements about multiple-row subqueries. (Choose three.)
15. Q15 View and examine the following SQL exhibit.The following command has been executed.Exhibit: 1 DROP TABLE employees:Identify the true statements. (Choose three)
16. Q16 View and examine the following SQL exhibits.Exhibit: 1SELECT last_name, salary, hire_dateFROM employeesORDER BY salary DESC;Exhibit: 2SELECT last_name, salary, hire_dateFROM employeesORDER BY 2 DESC;Indicate what…
17. Q17 View and examine the following available responses.Identify the true statements regarding the WITH GRANT OPTION clause. (Choose three)   
18. Q18 View and examine the following available responses.Given: You do not own the the objectsYou do not have the DROP ANY TABLE system…
19. Q19 View the exhibit and examine the description of the PRODUCT_INFORMATION table. Identify the SQL statement would retrieve from the table the number…
20. Q20 View and examine the structure of the ORDER_ITEMS table and the exhibit.Required: Display the PRODUCT_ID of the product that has the highest…
21. Q21 View and examine the following available responses.Identify the true statement TRUNCATE and DELETE.
22. Q22 View and examine the following available responses. Indicate the query which will create a projection of the ENAME and DEPTNO columns from…
23. Q23 View and examine the following SQL exhibit.Exhibit: 1INSERT ALL WHEN order_total < 10000 THEN INTO small_orders WHEN order_total > 10000 AND order_total…
24. Q24 Scenario: You are trying to insert a new employee record into the EMPLOYEES table. The HIRE_DATE column in the table is defined…
25. Q25 View and examine the following SQL exhibit.Exhibit: 1SELECT NVL(arg1, arg2)FROM dual;Identify the true statements regarding the NVL statement in the exhibit. (Choose two.)
26. Q26 View and examine the following scenario.Given: There are employees who receive more salary than employee with employee number 6.Required: Create a report…
27. Q27 View and examine the following available responses.Given: All fields and data referenced in the required statement are valid.Required: Select all fields from…
28. Q28 View and examine the following available responses.Identify the statements about single-row functions. (Choose three)     
29. Q29 View and examine the following available responses.Identify the situations where a transaction completes. (Choose three)
30. Q30 View and examine the following scenario.Given: The BOOKS_TRANSACTIONS table exists in your schema in this database. The following  SQL statement has been…
31. Q31 View and examine the structure of ORDERS and CUSTOMERS tables.Given: This UPDATE statement has been executed.Exhibit 1:1 UPDATE (2   SELECT order_date,…
32. Q32 View and examine the following available responses.Identify the true statements about INNER and OUTER JOIN. (Choose four.)
33. Q33 View and examine the following available responses.Identify the false selection about Oracle ALIASES.
34. Q34 View and examine the following available responses.Which statements are true about performing Data Manipulation Language (DML) operations on a view in Oracle?…
35. Q35 View and examine the following SQL exhibit.Exhibit: 1CREATE TABLE orders ( order_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE CHECK (ord_date <=…
36. Q36 View and examine the following available responses.Identify the true statements regarding the SQL WHERE and HAVING clauses. (Choose three)
37. Q37 Table: PRODUCTS Name Null?? TypePROD_ID NOT NULL VARCHAR2(6)QUANTITY NUMBER(8, 2)PRICE NUMBER(10, 2)EXPIRY_DATE DATEGiven:Rows exist in this table with data in all the…
38. Q38 View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement.Exhibit: 1 SELECT first_name, employee_id, NEXT_DAY(ADD_Months(hire_date, 6),…