Advertisement
Advertisement
Advertisement

Oracle SQL Quizzes & Trivia

Top Trending

Welcome to oracle quiz.... it is brought you by CHN11AJ112 batch members....it contains the intro and basics of ORACLE...

Questions: 30  |  Attempts: 756   |  Last updated: Jan 31, 2013
  • Sample Question
    The PLAYER table contains these columns: ID NUMBER(9) NAME VARCHAR(2) MANAGER_ID NUMBER(9) In this instance, managers are players and you need to display a list of players. Evaluate these two SQL statements: SELECT p.name, m.name FROMplayer p, player m WHEREm.id = p.manager_id; SELECT p.name, m.name FROMplayer p, player m WHEREm.manager_id = p.id; How will the results differ?
Advertisement

Advertisement

Oracle SQL Questions & Answers


Which statement is true when a DROP TABLE command is executed on a table?
There are two correct answers to this question, which are B. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed, and C. The DROP TABLE command can be executed on a table on which there
Which single command performs this? You have decided to permanently remove all the data from the student table, and you need the table structure in the future.
You have decided to permanently remove all the data from the STUDENT table and you need the table structure in the future. Which single command performs this?
More More oracle SQL Questions