Oracle is one of the most widely used databases. A test for Oracle DBA will try
to analyse the technical knowledge and ability of the candidate to deal with
complicated issues with the database. This objective test is a collection of 30
tricky questions which a DBA has to face in his work life. Take this test to
prepare yourself before you appear for a test as Oracle DBA.
Test > Oracle DBA test
Here are few sample Oracle DBA test/quiz questions
DBA_DATA_FILES is used for?
Look at all the data files
Look at the characters of a data file
Both b and d
Look at the size of a data file
An ALL_ DICTIONARY view is used for
Displays all the information accessible to the current user
Displays all relevant information in the entire database
Displays all the information from the schema of the current user
All of above
Click here to
start Oracle DBA quiz/test
Latest answer: Both CLOB and NCLOB are used to store huge
character data in the database, CLOBs store single-byte character set
Latest answer: The BFILE datatype is used to store unstructured
binary data outside the database. The column of BFILE type stores file locator
that points the OS file which actually stores data...........
Latest answer: Varrays, variable length array is quite similar
to array of C++ or Java. It has fixed upper-bound size that has to be specified
while it is declared..........