Database Systems Questions

• A data dictionary doesn't provide information about:
• In SQL, the _____ command is used to recompile a view
• Which of the following is a type of DBMS software?
• In SQL, the CREATE TABLE is used
• The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
• Which command is used to select distinct subject (SUB) from the table (BOOK)?
• One approach to standardizing storing of data
• In SQL, which command is used to remove a stored function from the database?
• Versatile report generators can provide
• The modify operation is likely to be done after
• What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
• The _____ command is used to allocates an extent for the table in SQL
• Data encryption techniques are particularly useful for
• In order to use a record management system
• A logical schema
• The activity of a file
• Data items grouped together for storage purposes are called a
• A multiple-form file management system
• A file that is organized in uniform format is formally referred to as a _____ or a database file.
• It is more accurate to define a _____ as a variety of different record types that are treated as a single unit