Description of the practice
Exercise 1
Section A
You load the database file [login to view URL] found together with the statement of the practice. To do this you must first create the user who made the export. If you were not so, would grant additional permissions to users importer and the operation would be more complex.
It asks:
Create a user named 'T15'. This should use the default tablespace 'users' fee should be unlimited and must have a temporary tablespace called 'temp'. Show SQL used to create the user with all the above requirements:
Give the user permissions so you can create sessions, tables, users, scripts, views, and materialized views. Show SQL used:
Section B
The first step to retrieve the data load will be available from backup file supplied. To do .dmp file upload must use the following syntax;
IMP user/password = [login to view URL] LOG FILE = [login to view URL]
Note here the instruction used to import data with the parameters used in your system:
It asks that record the number of records containing each of the tables listed in the grid below:
Table Name Number of records
1 Person
2 Users
3 City
4 Download
5 Song
Section C
Since there are variations in databases designed in the first practice, you want to get back the diagram. For the purpose of avoiding having to update it manually, and already have the version ER graphic, you want to generate this chart using reverse engineering options incorporating SQLDeveloper.
Follow the steps below to get updated diagram (it is assumed that you have installed in Spanish):
Since SQLDeveloper menu 'File' option 'Data modeler' option 'Import' option 'Data Dictionary'.
In the Wizard window, select the user T15. Enter your login password as prompted. Tap the button 'Next'. As prompted to choose a scheme, check the 'T15'. Tap on the button 'Next'.
As window appears where you can choose objects to import, select all the tables. Tap on the button 'Next'. Tap on the button 'term'.
ER diagram generated, minimally sorting tables to avoid excessive crosses the lines of relationships.