Bonus Day 1
Quiz
| 1: | A user calls and says, “I can't sign on to the database, but everything was working fine yesterday. The error says invalid user/password. Can you help me?” What steps should you take? |
| A1: | At first you would think to yourself, “Yeah, sure, you just forgot your password.” But this error can be returned if a front-end application cannot connect to the database. However, if you know the database is functional, just change the password by using the ALTER USER command and tell the user the new password. |
| 2: | Why should tables have storage clauses and a tablespace destination? |
| A2: | In order for tables not to take the default settings for storage, you must include the storage clause. Otherwise, medium to large tables will fill up and take ... |
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
