logo

CuriousTab

CuriousTab

Discussion


Home Certification Oracle Certification Comments

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


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

  • Correct Answer
  • 12 

    Explanation

    Maximim number of triggers that can be applied to a single table is 12

  • Tags: Database Administrator

    Oracle Certification problems


    Search Results


    • 1. 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
    • Discuss
    • 2. What is Primary Key in DBMS?
    • Discuss
    • 3. You are choosing a Windows 2000 operating system to use on a new computer at your company. This new computer will be a heavily used SQL server in your enterprise network environment. which operating system should you choose?

    • Options
    • A. Windows 2000 professional
    • B. Windows 2000 Server
    • C. Windows 2000 Advanced Server
    • D. Windows 2000 Datacenter Server
    • Discuss
    • 4. You use two sites on your Windows 2000 network. You decide you want to manually specify a particular domain controller in each site that will be used for intersite replication. What should you do?

    • Options
    • A. Create a site link to connect the two domain controllers
    • B. Designate the desired domain controller in each site as a bridge-head server
    • C. Configure the desired domain controller in each site to be a global catalog server
    • D. Create a new connection object for the desired domain controller in each site
    • Discuss
    • 5. What is the default optimization setting for the Server service on Windows 2000 Server computers?

    • Options
    • A. Minimize memory used
    • B. Balance
    • C. Maximize data throughput for file sharing
    • D. Maximize data throughput for network applications
    • Discuss
    • 6. Difference between Candidate key and Primary key?
    • Discuss
    • 7. Why do you need common fields in a Database?
    • Discuss
    • 8. 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"
    • Discuss
    • 9. 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
    • Discuss
    • 10. Define Executive Plan in Database SQL ?
    • Discuss


    Comments

    There are no comments.

Enter a new Comment