Tagged Questions
1
vote
1answer
123 views
Size of an empty database
Continuing with my school-project, now I have to estimate the size of the database from here to 5 years. They give me a formula, so, in that formula, one of the values is the size of the empty ...
3
votes
2answers
1k views
Estimate a Database Size
I have to do some project, and need to estimate the DB size.
I'm gonna to use Oracle in the project, because will have a lot of transactions and size.
But in the "presentation" I need to specify, in 5 ...
2
votes
1answer
114 views
ARCHIVELOG mode
Can someone describe in 30 words what ARCHIVEMODE is for?
I found this:
'When you enable this mode redo logs will be archived instead of overwritten.'
but have no idea, what can I write more about ...
2
votes
2answers
865 views
Return many rows on a plsql Oracle10g
I'm doing a little project and I need to do a plsql to return many rows.
I have someting like:
Table(id, data1, data2, from)
And the user gives me the value of from and I have to return all that.
...
1
vote
1answer
2k views
Oracle SQL create view privileges
This is more of a theoritical question but I need help ASAP. Here it is:
With the appropriate use of SQL queries, grant as system
administrators the required access privileges to a database user ...
1
vote
2answers
361 views
database normalization 2nf, 3nf
I am doing homework about database normalization. I have to decompose the table into 3nf form showing the steps
here is the initial table:
...
4
votes
1answer
743 views
Calculate months between two dates
For a University course I've been given the following task
Suppose that we have an employee table like (first_name, last_name, salary, hire_date, ...). There is regulation which states that every ...
