#93. Which data dictionary view(s) do you need to query to find the following information about a user? • Whether the user's account has expired • The user's default tablespace name • The user's profile name
#94. You need to create an index on the SALES table, which is 10 GB in size. You want your index to be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability. Which type of index would be best for this table?
#96. The current password file allows for five entries. New DBAs have been hired and five more entries need to be added to the file, for a total of ten. How can you increase the allowed number of entries in the password file?
#98. You need to shut down your database. You want all of the users who are connected to be able to complete any current transactions. Which shutdown mode should you specify in the SHUTDOWN command?