logo

CuriousTab

CuriousTab

Discussion


Home Certification Oracle Certification See What Others Are Saying!
  • Question
  • Difference between Candidate key and Primary key?


  • Correct Answer
  • Candidate Key ? A Candidate Key can be any column or a combination of columns that can qualify as unique key in database There can be multiple Candidate Keys in one table Each Candidate Key can qualify as Primary Key Primary Key ? A Primary Key is a column or a combination of columns that uniquely identify a record Only one Candidate Key can be Primary Key One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain 

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

    More questions

    • 1. If you wanted administrators to see a message when logging into the router, which command would you use?

    • Options
    • A. message banner motd
    • B. banner message motd
    • C. banner motd
    • D. message motd
    • Discuss
    • 2. At which layer of the OSI model would you assume the problem is if you type show interface serial 1 and receive the following message? Serial 1 is down, line protocol is down

    • Options
    • A. Physical layer
    • B. Data Link layer
    • C. Network layer
    • D. None
    • Discuss
    • 3. Which commands loads a new version of the Cisco IOS into a router?

    • Options
    • A. copy flash ftp
    • B. copy ftp flash
    • C. copy flash tftp
    • D. copy tftp flash
    • Discuss
    • 4. What is the command to copy a Cisco IOS to a TFTP server?
    • Discuss
    • 5. When a PC sends a packet to another PC in a remote network, what destination IP address and MAC address will be in the frame that it sends to its default gateway?
    • Discuss
    • 6. What is the administrative distance of OSPF?

    • Options
    • A. 90
    • B. 100
    • C. 110
    • D. 120
    • Discuss
    • 7. With which network type will OSPF establish router adjacencies but not perform the DR/BDR election process?

    • Options
    • A. Point-to-Point
    • B. Backbone area 0
    • C. Broadcast multi-access
    • D. Non-broadcast multi-access
    • Discuss
    • 8. A network administrator needs to configure a router with a distance-vector protocol that allows classless routing. Which of the following satisfies those requirements?

    • Options
    • A. IGRP
    • B. OSPF
    • C. RIPv1
    • D. EIGRP
    • Discuss
    • 9. You get a call from a network administrator who tells you that he typed the following into his router: Router (config) #router ospf 1 Router (config-router) # network 10.0.0.0. 255. 0.0.0 area 0 He tells you he still can't see any routes in the routing table. What configuration error did the administrator make?

    • Options
    • A. The wildcard mask is incorrect
    • B. The OSPF area is wrong
    • C. The OSPF Process ID is incorrect.
    • D. The AS configuration is wrong
    • Discuss
    • 10. Which proprietary Cisco STP extensions would put a switch port into err-disabled if a BPDU is received on this port?
    • Discuss


    Comments

    There are no comments.

Enter a new Comment