private void verifyDDL(String dbType) throws Exception {
    LOG.info("Checking DDL for {}", dbType);
    DDL ddl = DDLTestUtils.getDdl(dbType);
    printDDLMetrics(ddl);

    // check for unwanted alter tables
    Assert.assertEquals("Expected count of alter tables mismatch. Please include all constraint definitions in " +
            "the create table statement, only use alter table in exceptional cases, such as to work around a circular " +
            "FK dependency. Would another such case occur, please document it in the DDL's and adjust the " +
            "EXPECTED_ALTER_TABLE_COUNT in this test.",
        EXPECTED_ALTER_TABLE_COUNT,
        ddl.alterTables.size());

    // check for too long table/constraint names
    for (String tableName: ddl.tableNames()) {
      Assert.assertTrue("Table name exceeds the 30 character limit: " + tableName, tableName.length() <= 30);
    }
    for (Table table: ddl.tables.values()) {
      Assert.assertTrue("PK name exceeds the 30 character limit: " + table.primaryKey,
          !table.primaryKey.isPresent() || table.primaryKey.get().name().length() <= 30);
      for (Constraint constr: Sets.union(table.foreignKeys, table.uniqueConstraints)) {
        Assert.assertTrue("Constraint name exceeds the 30 character limit: " + constr, constr.name().length() <= 30);
      }
    }
    // check for unnamed PK's (skip quartz tables)
    for (Table table: ddl.tables.values()) {
      Assert.assertFalse("Unnamed PK exists for table: " + table.name,
          !table.name.startsWith("qrtz") && table.primaryKey.isPresent() && table.primaryKey.get().name().equals("<default>"));
      for (Constraint constr: Sets.union(table.foreignKeys, table.uniqueConstraints)) {
        Assert.assertTrue("Constraint name exceeds the 30 character limit: " + constr, constr.name().length() <= 30);
      }
    }

  }
To verify if DDL have certain characteristics:
<ul>
  <li>There are no unnamed constraints</li>
  <li>Alter tables are only used in exceptional cases</li>
  <li>Table and constraint name lenghts doesn't exceed 30 (a restriction imposed by Oracle)</li>
</ul>
ambari-server/src/test/java/org/apache/ambari/server/orm/db/DDLTests.java