Oracle Functions And Coding Quiz Questions

14 Questions | Total Attempts: 2517

SettingsSettingsSettings
Oracle Functions And Coding Quiz Questions - Quiz

Hello there! Today, we're here to test your knowledge in a fun and easy way through this Oracle Functions and Coding quiz. As you would already know, Oracle is an on-premises application that is designed to solve the most challenging business needs of organizations of all sizes and industries. If you have learned about this subject previously, then you must try this quiz to see how much you remember the concepts. You might also get to learn some new facts about Oracle today. So, get ready and start answering.


Questions and Answers
  • 1. 
    Evaluate this SQL*Plus command: START delaccount Which task will this command accomplish?
    • A. 

      It executes the DELACCOUNT PL/SQL routine.

    • B. 

      It runs the DELACCOUNT.SQL script file.

    • C. 

       It creates the DELACCOUNT file using the default file extension.

    • D. 

      It invokes the editor to edit the contents of the DELACCOUNT file.

  • 2. 
    Which /SQL*Plus feature can be used to replace values in the WHERE clause?
    • A. 

      Substitution variables

    • B. 

      Replacement variables

    • C. 

      Prompt variables

    • D. 

      This feature cannot be implemented through /SQL*Plus.

  • 3. 
    Evaluate this SQL statement: SELECT c.customer_id, o.order_id, o.order_date, p.product_name FROM customer c, curr_order o, product p WHERE customer.customer_id = curr_order.customer_id AND o.product_id = p.product_id ORDER BY o.order_amount; This statement fails when executed. Which change will correct the problem?
    • A. 

       Include the ORDER_AMOUNT column in the SELECT list.

    • B. 

      Use the table name in the ORDER BY clause.

    • C. 

      Remove the table aliases from the WHERE clause.

    • D. 

      Use the table aliases instead of the table names in the WHERE clause.

  • 4. 
    Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHARD2(10) START_DATE DATE END_DATE DATE. Which two aggregate functions are valid on the START_DATE column? (Choose two)
    • A. 

      SUM(start_date)

    • B. 

      AVG(start_date)

    • C. 

      COUNT(start_date)

    • D. 

      AVG(start_date, end_date)

    • E. 

      MIN(start_date)

  • 5. 
    Which two tasks can you perform by using the TO_CHAR function?
    • A. 

      Convert 10 to ‘TEN’

    • B. 

      Convert ‘10’ to 10

    • C. 

      Convert ‘10’ to ‘10’

    • D. 

      Convert ‘TEN’ to 10

  • 6. 
    In which case would you use a FULL OUTER JOIN?
    • A. 

      A. Both tables have NULL values.

    • B. 

      B. You want all unmatched data from one table.

    • C. 

      C. You want all matched data from both tables.

    • D. 

      D. You want all unmatched data from both tables.

    • E. 

      E. One of the tables has more data than the other.

  • 7. 
    Which operator can be used in an outer join condition?
    • A. 

      A. NOT

    • B. 

      B. OR

    • C. 

      C. IN

    • D. 

      D. AND

  • 8. 
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCNAR2(25) LAST_NAME VARCNAR2(25) Which statement inserts a row into the table?
    • A. 

      INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);

    • B. 

      INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);

    • C. 

      INSERT INTO employees (employee_id) VALUES (1000);

    • D. 

      INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);

  • 9. 
    Which action will cause an automatic rollback?
    • A. 

      Exiting from iSQL*Plus without first committing the chang

    • B. 

      System crash

    • C. 

      Subsequent DML statement

    • D. 

      GRANT statement

  • 10. 
    Which best describes an inline view?
    • A. 

      A schema object

    • B. 

      A subquery that can contain an ORDER BY clause

    • C. 

      Another name for a view that contains group functions

    • D. 

      A subquery that is part of the FROM clause of another query

  • 11. 
    The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?
    • A. 

      GRANT select ON dept TO ALL_USERS;

    • B. 

       GRANT select ON dept TO ALL;

    • C. 

      GRANT QUERY ON dept TO ALL_USERS

    • D. 

      GRANT select ON dept TO PUBLIC;

  • 12. 
    Which of the following are attributes of /SQL*Plus? 
    • A. 

      /SQL*Plus is the Oracle proprietary interface for executing SQL statements.

    • B. 

      /SQL*Plus commands are accesses from a browser.

    • C. 

      /SQL*Plus commands are used to manipulate data in tables.

    • D. 

      /SQL*Plus commands manipulate table definitions in the database.

  • 13. 
    Why do we use subquery?
    • A. 

      Create groups of data.

    • B. 

      Sort data in a specific order

    • C. 

      Convert data to a different format

    • D. 

      Retrieve data based on an unknown condition

  • 14. 
    Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > &&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?
    • A. 

      An error is returned.

    • B. 

      You are prompted to enter a new value.

    • C. 

      A report is produced that matches the first report produced.

    • D. 

      You are asked whether you want a new value or if you want to run the report based on the previous value.

Back to Top Back to top