Using SQL commands, describe how you would utilize the data dictionary to monitor database security.

What is the price of the least expensive item in the database?

How is the processing of SQL DDL statements (such as CREATE TABLE) different from the processing required by DML statements?

An in-memory database (IMDB) is a database management system that stores the entire database in _______. a. random access memory b. read-only memory c. distributed servers d. virtual memory

Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBN

Define second normal form. What types of problems might you encounter using tables that are not in second normal form?

SQL includes many numerical functions. Two of these functions are FLOOR and CEIL. Use the Internet to research these functions. Are the functions available in Oracle, SQLServer, and Access? Write a paragraph that discusses what the functions do and anydifferences and/or similarities between the functions in Oracle, SQL Server, and Access.Then perform the following tasks: a. Solmaris Condominium Group would like to know the impact of discounting its condofees by 3 percent. Write an SQL statement in Oracle that displays the condo ID, unitnumber, discounted condo fee, discounted condo fee with the CEIL function, anddiscounted condo fee with the FLOOR function. b. Based on your research, will the values in the three columns vary? If so, how? Usethe condo with the ID of 1 to explain your answer. Be sure to cite your references.