ORACLE DBA INTERVIEW
QUESTIONS AND ANSWERS
Page - 1
1. What should be done prior to installing Oracle (for the OS and the disks)?
Make sure enough contiguous disk space is available.When configuring SQLNET on the server what files must be set up? INITIALIZATION file, TNSNAMES.ORA file, SQLNET.ORA file
2. When configuring SQLNET on the client what files need to be set up?
SQLNET.ORA, TNSNAMES.ORA
3. What
is a database?
Database
is a collection of data. It contains information about one particular
enterprise. A database management system (DBMS) consists of a collection of
interrelated data and a set of programs to access that data.
4. What is data?
Data
is a collection of information stored in a database as one of several
different data types.
5. Define
DCL?
DCL
stands for Data Control Language. It consists of commands that control the
user access to the database objects.
6. What is a cursor?
A
cursor serves as a pointer that allows the application programming language
to deal with query results one row at a time. Although the cursor can
traverse all the rows of a query result, it focuses on only one row at a
time.
7. What are the two levels of data
independence?
There
are two levels of data independence are :
8. Define entity?
An entity is an
object with a physical existence.
9. Is SQL a procedural or non-procedural
language?
SQL
is non-procedural, meaning that the database decides how to execute the SQL
statement. The extensions discussed during this hour were procedural.
10. What
are the various types of databases?
Multimedia database, Spatial
database (Geographical Information System Database), Real–time or Active
Database, Data Warehouse or On–line Analytical Processing Database
|
No comments:
Post a Comment