The plaque commonly displayed the name of the ship, as well as its class and shipyard of origin. Many later plaques also displayed the ship's official motto, plus a list of notable Starfleet officers involved in the assembly of the vessel.
In real life, the list of "officers" is actually a list of notable production staff members from the various television sets. "Admiral" Gene Roddenberry is commonly listed as the Starfleet Chief of Staff.
When USS Voyager found the USS Equinox in 2376, CaptainJaneway noted that the Equinox's plaque had fallen, and advised that they should hang it back up. Similarly, after days of battling with the Equinox after they betrayed the Voyager crew, Voyager's dedication plaque fell down. Janeway noted that, after years of battles, it had never fallen down before, and in a symbolic gesture, they put it back "where it belonged." (VOY: "Equinox", "Equinox, Part II")
In the non-canonStar Trek: Titan premier novel, Captain Riker has a tough time selecting a proper quote for the USS Titan's dedication plaque. (It has never been implied, one way or the other, if it is standard procedure for a ship's captain to choose the quote on their own ship's plaque.)