×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
What can a permanent tablespace contain?
2.
Under which condition is it possible to connect to an Oracle database without providing a password?
3.
Which view displays the NLS initialization parameters that have been explicitly set?
4.
Can you drop objects from a read-only tablespace?
5.
You are responsible for managing disk space used for large sort operations. You are willing to allocate this
space as needed and not de-allocate until the database is shutdown. You would like to reduce contention on
data dictionary tables when this space is allocated. Where possible, you would like to avoid the overhead of
generating rollback information when this space is allocated. What kind of tablespace is appropriate?
space as needed and not de-allocate until the database is shutdown. You would like to reduce contention on
data dictionary tables when this space is allocated. Where possible, you would like to avoid the overhead of
generating rollback information when this space is allocated. What kind of tablespace is appropriate?
6.
When you created a tablespace, you overestimated the size of one of the datafiles. Several objects were stored
in the datafile. Some, but not all of the objects were dropped subsequently. To which point will you be able to
decrease the size of the datafile?
in the datafile. Some, but not all of the objects were dropped subsequently. To which point will you be able to
decrease the size of the datafile?
7.
Be default, a tablespace is _________ -managed and can contain_____
8.
Which category of data dictionary views does not have an owner column?
9.
A PL/SQL program unit was created. Where it is stored?
10.
When are the base tables of the data dictionary created?