Which category of SQL statements is used to add, remove, and modify database structures?
You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column.The results include:All customers and their orders -✑ Customers who have no ordersWhich type of join do these results represent?
Data in a database is stored in:
You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column.You execute the following statement:DELETE FROM Student -What is the result?
You need to establish a set of permissions that you can routinely assign to new users.What should you create?
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
