When dealing with attributes in the Database Configuration application for Oracle or SQL Server databases, 'INDEXED' and 'TEXT' are common search types. 'INDEXED' allows for faster search and retrieval of data by creating indexes on the database columns. 'TEXT' search type is typically used for searching through large text fields efficiently. These two types are practical and widely implemented in database systems to enhance performance and search capabilities.