Mock Test!!!!!

15 Questions

Settings
Mock Test Quizzes & Trivia

Hiii friends. . . . Here are few questions to test your skills. . . . All d best!


Questions and Answers
  • 1. 
    Which one of the following query is correct??
    • A. 

      Alter session set nls_date_format='dd-mon-yy hh:mi:ss';

    • B. 

      Alter session set nls-date-format='dd-mon-yy hh:mi:ss';

    • C. 

      Alter session set nls-date-format='dd-mon-yy hh:min:ss';

    • D. 

      Alter session set nls_date_format='dd-mon-yy hh:min:ss';

  • 2. 
    The primary function of ---- is to record all changes made to the data.
    • A. 

      Control log

    • B. 

      Table space

    • C. 

      Redo log

    • D. 

      Data file

  • 3. 
    Which one of the following are DDL commands ??
    • A. 

      Create,update,drop

    • B. 

      Create,alter,drop

    • C. 

      Insert,update,delete

    • D. 

      Create,rename,truncate

  • 4. 
    When a number is added or subtracted to a date,the result obtained is number of days.
    • A. 

      True

    • B. 

      False

  • 5. 
    Which are the basic unit of data storage in oracle database??
    • A. 

      View

    • B. 

      Table

    • C. 

      Schema

    • D. 

      Index

  • 6. 
    Basic form of SQL statement to read data out of a table is..
    • A. 

      Select * from table_name;

    • B. 

      Select * from table_name where column_name=’data’;

    • C. 

      Desc table_name;

    • D. 

      None of the above

  • 7. 
    The process of applying the redo log during a recovery operation is called ---
    • A. 

      Rolling backward

    • B. 

      Redo entries

    • C. 

      Rolling forward

    • D. 

      Redo records

  • 8. 
    Which of the following is not used in queries??
    • A. 

      >=

    • B. 

    • C. 

    • D. 

      None of the above

  • 9. 
    Characteristics of data files are..
    • A. 

      Modified or new data is not necessarily written to a datafile immediately

    • B. 

      A datafile can be associated with many databases

    • C. 

      When database runs out of space it can have some characteristics being set automatically

    • D. 

      All the above

  • 10. 
    IBM developed SQL and pronounced it as ---
    • A. 

      SQUEL

    • B. 

      SQUAL

    • C. 

      SEQUAL

    • D. 

      SEQUEL

  • 11. 
    The table name may be upto ---- char length.
    • A. 

      25

    • B. 

      40

    • C. 

      30

    • D. 

      35

  • 12. 
    Partial dependencies are removed in---
    • A. 

      BCNF

    • B. 

      1NF

    • C. 

      3NF

    • D. 

      2NF

  • 13. 
    Groups of one or more tables physically stores together to share common columns are called clusters.
    • A. 

      True

    • B. 

      False

  • 14. 
    Every determinant in BCNF should be a---
    • A. 

      Primary key

    • B. 

      Candidate key

    • C. 

      Foreign key

    • D. 

      Composite key

  • 15. 
    Choose the right query from below:
    • A. 

      Insert into subject values('java',interval '3-4' year to month);

    • B. 

      Insert into subject values('java',interval '3-4' day to seconds);

    • C. 

      Insert into subject values('java',interval 8 month);

    • D. 

      Insert into subject values('java',interval '8' month);