logo

CuriousTab

Oracle Certification (Certification) Question and Answers-Page 2

Oracle Certification problems


Share: 
  • 1. What are the different types of SQL statements ?

  • Tags: Database Administrator

  •           Discuss     

  • 2. How many joining conditions are required to join 4 tables in SQL?

  • Options
  • A. 1
  • B. 2
  • C. 3
  • D. 4

  • Tags: Analyst, Database Administrator, IT Trainer

  •           Discuss     

  • 3. What command would you use to create a backup control file?

  • Tags: Database Administrator

  •           Discuss     

  • 4. What is an Oracle index?

  • Tags: Database Administrator

  •           Discuss     

  • 5. What is the default return value of a function?

  • Options
  • A. int
  • B. char
  • C. string
  • D. None of the above

  • Tags: Database Administrator

  •           Discuss     

  • 6. what will be the output of the following code? class Value { public int i = 15; } public class Test { public static void main(String argv[]) { Test t = new Test(); t.first(); } public void first() { int i = 5; Value v = new Value(); v.i = 25; second(v, i); System.out.println(v.i); } public void second(Value v, int i) { i = 0; v.i = 20; Value val = new Value(); v = val; System.out.println(v.i + " " + i); } }

  • Options
  • A. 15 0 2
  • B. 15 0 0
  • C. 15 20 0
  • D. 15 0 20

  • Tags: Analyst, IT Trainer, Project Manager, Software Architect

  •           Discuss     

  • 7. MOV extension refers usually to what kind of files?

  • Options
  • A. Audio
  • B. Movies or other Videos
  • C. Images
  • D. Documents

  • Tags: AIEEE, Bank Exams, Database Administrator, Bank Clerk, Analyst, IT Trainer

  •           Discuss     

  • 8. Explain Data Control Language

  • Tags: Database Administrator

  •           Discuss     

  • 9. Which among the following keys are used to identify each row of the table uniquely?

  • Options
  • A. Primary key
  • B. Unique key
  • C. Partial key
  • D. None of the above

  • Tags: Database Administrator

  •           Discuss     

  • 10. What is the difference between oracle,sql and sql server?

  • Tags: Database Administrator

  •           Discuss     


First 2 3 4 5