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: 776   |  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?

ORACLE SQLORACLE PL/SQLORACLE DBA

Questions: 15  |  Attempts: 617   |  Last updated: Jan 7, 2013
  • Sample Question
    Which component of an instance holds session variables and arrays when you are NOT running in MTS mode?
Advertisement

Advertisement

Oracle SQL Questions & Answers


What happens when a DROP TABLE command is executed on a table?
The DROP TABLE command may be implemented on a table in which there are imminent deals. • The DROP TABLE command is utilized in the database management system called Oracle. • Drop-Table removes one or more table definitions and all infor
How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in the DEPT table?
You can refer to the ID column in the DEPT table to add a foreign key constraint on the dept_no column in the EMP table by using the command of an altar table with the added clause on the emp table. The reason for this being correct is that the alter
Which single SQL command would you use 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