Oracle Computer Technology Quiz Questions

20 Questions | Total Attempts: 64

SettingsSettingsSettings
Please wait...
Oracle Quizzes & Trivia

.


Questions and Answers
  • 1. 
     which sql statement generates the alias annual salary for the calculated column salary*12?
    • A. 

      Select ename,salary*12'annual salary' from employee

    • B. 

      Select ename,salary*12 as initcap(annual salary)from employee

    • C. 

      Select ename,salary*12"annual salary" from employee

    • D. 

      Select ename,salary*12 as annual salary from employee

  • 2. 
    in which scenario would an index be most useful? 
    • A. 

      When indexed columns are part of an expression

    • B. 

      When indexed xolumns are declared as not null

    • C. 

      When indexed column contains wide range of values

    • D. 

      The indexed columns are used in FROM clause

  • 3. 
     what are two reasons to create synonyms?
    • A. 

      Your table names are too long

    • B. 

      You have too many tables

    • C. 

      Your table have difficult names

    • D. 

      You have too many columns on the table

  • 4. 
    what is necessary for your query  on an existing view to execute successfully? 
    • A. 

      The underlying tables must be in the same schema

    • B. 

      The underlying tables must have data

    • C. 

      You need select privileges on the view

    • D. 

      You need select privileges only on underlying tables

  • 5. 
    your table contains these columns EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR(25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this sql statement SELECT EMPNAME,HIRE_DATE,SALARY FROM EMP ORDER BY HIRE_DATE; How will the results be sorted?
    • A. 

      Descending alphabetically

    • B. 

      Descending by date

    • C. 

      Randomly

    • D. 

      Ascending by date

    • E. 

      Ascending alphabetically

  • 6. 
    what does the force option for creating a view do? 
    • A. 

      Creates a view with constraints

    • B. 

      Creates a view in another schema

    • C. 

      Creates a view even if the underlying parents table has constraints

    • D. 

      Creates a view regardless of whether or not the base tables exists

  • 7. 
    which view should a user query to display the columns associted with the cons on tyable ownd by user 
    • A. 

      USER_COLUMNS

    • B. 

      USER_CONS_COLUMNS

    • C. 

      ALL_CONSTRAINTS

    • D. 

      USER_OBJECTS

  • 8. 
    which two statements complete a transaction?(choose two) 
    • A. 

      ROLLBACK TO SAVEPOINT C;

    • B. 

      SELECT MAX(SAL) FROM employees WHERE DEPARTMENT_ID=20;

    • C. 

      GRANT SELECT ON employees TO SCOTT;

    • D. 

      DESCRIBE employee;

    • E. 

      ALTER TABLE employee SET UNUSED COLUMNS SAL;

  • 9. 
    WHAT IS TRUE REGARDING Subqueries 
    • A. 

      The inner query must always return a value or outer query will return an error

    • B. 

      The inner query wil return values to the outer query

    • C. 

      The inner query always sorts the result of the outer query

    • D. 

      The outer query must return a value to the inner query

  • 10. 
    which two are attributes of single row functions? 
    • A. 

      Manipulate data items

    • B. 

      Accept only one argument and returns only one value

    • C. 

      Returns one result per row

    • D. 

      Cannot be nested

  • 11. 
    you can update a view with group functions? 
    • A. 

      True

    • B. 

      False

  • 12. 
    evaluate the sql statement ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; what will be displayed 
    • A. 

      0.00

    • B. 

      Error

    • C. 

      0

    • D. 

      1

  • 13. 
    which two are character manipulation  functions?(choose two) 
    • A. 

      TRUNC

    • B. 

      REPLACE

    • C. 

      TRIM

    • D. 

      MOD

    • E. 

      CASE

  • 14. 
    In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
    • A. 

      The line numbers reported match the line numbers you see in your text editor.

    • B. 

      SQL*Plus will automatically show the errors to you.

    • C. 

      To see the errors, enter SHOW ERRORS in SQL*Plus.

    • D. 

      If there are no syntax errors, you will receive the message "NO ERRORS."

  • 15. 
    Which of the following is NOT an Oracle-supported trigger?
    • A. 

      BEFORE

    • B. 

      AFTER

    • C. 

      DURING

    • D. 

      INSTEAD OF

  • 16. 
    Which SQL phrase is not supported by Oracle?
    • A. 

      ON DELETE CASCADE

    • B. 

      ON UPDATE CASCADE

    • C. 

      CREATE SEQUENCE[sequence name]

    • D. 

      DROP SEQUENCE[sequence name]

  • 17. 
    To obtain the structure of an Oracle table, the command to use is:
    • A. 

      STRUCTURE [TableName].

    • B. 

      DESCRIBE [TableName].

    • C. 

      DESCRIBE STRUCTURE [TableName].

    • D. 

      DESC TABLE [TableName].

  • 18. 
      To see the contents of the SQL*Plus buffer, type:
    • A. 

      Contents

    • B. 

      Buffer

    • C. 

      List

    • D. 

      Current

  • 19. 
    data pump import is a server based bulk data movement
    • A. 

      True

    • B. 

      False

  • 20. 
    Which syntax is used to recover the table from recycle bin? 
    • A. 

      RECYCLE BIN

    • B. 

      FLASHBACK TABLE.......TO DROP

    • C. 

      FLASHBACK TABLE........TO BEFORE DROP

    • D. 

      FLASHBACK TABLE ....FROM RECYCLEBIN