What do you guys think about Oracle 8i practice exams from Oracle Press?
Printable View
What do you guys think about Oracle 8i practice exams from Oracle Press?
TheSlob,
Personnally, I think that the Oracle Press tests are harder then the actual Oracle 8i tests. I have found that the STS test are much closer to the testing material. But the Oracle Press tests were good. Just my opinion.
antilles
I'd rather study too much and have to think on the practice tests than be stumped on the real test. Of course, that's just me.
Yes...I agree. Some of the practice exams like the STS & couchman etc. They all have errors to begin with so its takes alot of time just to figure out what the true answers are. I can't figure out the answers to some questions that I still trying toremember when I wrote the Sql exam. I missed by 3 and am fearful that I just won't be able to get it right again on the next one. I'm currently using an ILT textbook and even then its not truely clear. Can someone clarify the following:
If you connect as a system user (I interpret this as A DBA privledge ), you create a table and add constraints for the table, which dictctionary view would you look for the table and the constraints.
a. DBA-Tables and DBA-constraints
B. User_tables and User constraints
C. User objects & user tables
D. DBA-objects and DBA tables
If you examine A) this is the table and constraints that are accesible in the database. B) is the ones that are owned by the user including system.
So in a sense you could see both a & b. but because of ownership I would pick B over A. Is my logic right?????
could be either a or b
Thanks...I hope they allow for both I can't remember if it was (choose all that apply) or if it was just asking for one.
The other question I fell down on was something similar ie.
you are asked to store and access data with an ORacle database. What facilities can assist you in doing this (this one was a choose all etc.)
a. tables _ yes I am sure on this one
b. views - ? yes because views are based on table and they can be use to restrict access but you can store data using a view so I'm not too sure
c. synonyms
d. indexes
e. triggers
f. integrity constraints
g. priviledges - you can control database access so I think you can choose this????
h. roles - the same as priviledges.
What do you think???? I am almost attempted to choose all the objects that are listed in the ILT book ie. tables, views, synonyms, along with privledges and roles...
??? the only thing is the rest aren't used to store so then I thought maybe just leave it with tables.????
What do you say all you experts out there????
>you are asked to store and access data with an ORacle >database. What facilities can assist you in doing this (this >one .was a choose all etc.)
>a. tables _ yes I am sure on this one
>b. views - ? yes because views are based on table and they >can be use to restrict access but you can store data using a >view so I'm not too sure
>c. synonyms
>d. indexes
>e. triggers
>f. integrity constraints
>g. priviledges - you can control database access so I think >you can choose this????
>h. roles - the same as priviledges.
hE'S ASKING WHICH FACILITIES ASSIST YOU..
I WOULD SAY
PRIV
ROLES
INT CONSTRAINTS AS WELL(BECAUSE ACCESSING/ IS MADE EASIER WITH REPEATED SQL'S
VIEWS
I THINK THE ABOVE 4, TABLE HASTHE DATA STORED IN IT BY YOU, SO ASSIST I WOULDN'T KNOW...
CHEERIO
It is just B, not A for could this be one of those silly questions whose explanation is something like:Quote:
Originally posted by marist89
a. DBA-Tables and DBA-constraints
B. User_tables and User constraints
C. User objects & user tables
D. DBA-objects and DBA tables
could be either a or b
"A is not the correct answer, since there are no tables called DBA-Tables and DBA-constraints. The similar tables are DBA_Tables and DBA_constraints."
Using that same logic, B is incorrect because there is no object named "User constraints" either. I think something was lost in the copying of the question...Quote:
Originally posted by julian
It is just B, not A for could this be one of those silly questions whose explanation is something like:Quote:
Originally posted by marist89
a. DBA-Tables and DBA-constraints
B. User_tables and User constraints
C. User objects & user tables
D. DBA-objects and DBA tables
could be either a or b
"A is not the correct answer, since there are no tables called DBA-Tables and DBA-constraints. The similar tables are DBA_Tables and DBA_constraints."
That's right. I didn't pay attention to "User constraints" :-)Quote:
Using that same logic, B is incorrect because there is no object named "User constraints" either. I think something was lost in the copying of the question...
There is something wrong with the question.
oops....I meant User_tables and User_constraints so I think Julian is right on when its b. on your first advice. because of the silly logic in a.
Its werid how you don't always see these things...yet under normal working conditions you might pick it up that's why this test becomes silly sometimes. Either way I am now aware of what the possiblities could be.... I hope they've thrown this question out by now.