logo

CuriousTab



Oracle Certification (Certification) Question and Answers-Page first

Oracle Certification problems


  • 1. What is Primary Key in DBMS?

  • Tags: Database Administrator, IT Trainer, Software Architect

  •           Discuss     

  • 2. Which dml command is used in conjunction with @@identity?

  • Options
  • A. INSERT and UPDATE
  • B. UPDATE and DELETE
  • C. SCOPE_IDENTITY and IDENT_CURRENT
  • D. Commit and rollback

  • Tags: Software Architect, Project Manager, Network Engineer, IT Trainer, Database Administrator, Analyst

  •           Discuss     

  • 3. What is the maximum number of triggers, can apply to a single table?

  • Options
  • A. 8
  • B. 10
  • C. 12
  • D. 14

  • Tags: Database Administrator

  •           Discuss     

  • 4. Difference between Candidate key and Primary key?

  • Tags: Software Architect, Project Manager, Network Engineer, IT Trainer, Database Administrator, Analyst

  •           Discuss     

  • 5. Why do you need common fields in a Database?

  • Tags: Project Manager, Software Architect

  •           Discuss     

  • 6. What is the output after compile and run the following code ? int Output = 10; boolean b = false; if((b == true) && ((Output += 10) == 20)) { System.out.println("We are equal " + Output); } else { System.out.println("Not equal! " + Output); }

  • Options
  • A. Compilation and output of "We are equal 10"
  • B. Compilation and output of "Not equal! 10"
  • C. Compilation error, attempting to perform binary comparison on logical data type
  • D. Compilation and output of "Not equal! 20"

  • Tags: Analyst

  •           Discuss     

  • 7. In the following pieces of code, B and D will compile without any error. True or false ? A: StringBuffer sb1 = "abcd"; B: Boolean b = new Boolean("abcd"); C: byte b = 255; D: int x = 0x1234; E: float fl = 1.2;

  • Options
  • A. TRUE
  • B. FALSE

  • Tags: Analyst, IT Trainer, Project Manager

  •           Discuss     

  • 8. Define Executive Plan in Database SQL ?

  • Tags: Database Administrator, Project Manager

  •           Discuss     

  • 9. Insert command falls in which sub-language of SQL ?

  • Options
  • A. DCL
  • B. DQL
  • C. DML
  • D. DDL

  •           Discuss     

  • 10. In R-DBMS, the data is organized in the form of _____.

  • Options
  • A. Hierarchical structure
  • B. Tabular structure
  • C. Linked structure
  • D. All of the above

  •           Discuss     


First 2 3 4 5