Most commmonly Frequently asked questions for DBA



Last updated on August 25th, 2016 at 09:45 am

Here are some of the Frequently asked questions for DBA

1 which of the following is the first step in oracle’s recommended tuning
a tune the database
b tune the network
c tune the application
d all the above are equally important
2 increasing the size of the system global area in order to improve performance is an example of which step in the oracle tuning methodology
a tune the underlying platform
b tune database operations
c tune memory allocation
d tune the data design
3. response time is a measure of

a the time it takes for a single user to receive a result set back when working form within a application
b how much processing the system can do during a given amount of time
c how fast user’s pc can refresh the screen with new data
d how long it takes for oracle to find data without using an index

4. throughputs is a measure of

a the time it takes for a single user to receive a result set back when working from within the application
b how much processing the sytem can do during a given amount fo time
c how fast a user’s pc can refresh the screen with new data
d how long it takes for oracle to find data without using an index
5 an oracle instance is made up of
a sga and the init.ora
b sga and background process
c sga and data file , control files , and redo logs
d sga , alert log, trace file
6 an oracle database is made up of
a datafiles , redo logs, trace files
b datafiles , control files, and init.ora
c datafiles, redologs, and control files
d redologs, archived redo logs, and password files
7 which of the following oracle background process writes blocks from the database buffer caches to the datafile
a LGWR
b DBW0
c CKPT
d SMON

8 which of the following background processes detects faild user process and roll backs
a PMON
b DBW0
c SMON
d CKPT
9 which of the following views contains information about overall system statistics, both previously and currently connected
a v$sgastat
b v$statname
c v$sesstat
d v$systat
10. which dba view would show storatge, row, and block information for an table
a dba_tables
b dba_objects
c dba_table_size
d dba_tab_privs
11 which of the following components of SGA caches recently accessed data , index and rollback block
a shared pool
b database buffer cache
c large pool
d redo log buffer
12 which of the following components of the SGA records changes made to the database for recovery purpose
a shared pool
b database buffer cache
c large pool
d redo log buffer
13 the alert log contains information on all but which of the following
a instrance startup and shutdown
b creation of new database users
c redo log switches
d all of the above are in the alert log
14 which of the following is an appropriate way to manage the size of the alert log
a delete it following a good backup
b trim it by deleting the oldest entries first
c rename if following a good database backup
d any of the above are appropriate method
15. if the init.ora optimzer mode is set to choose, but no statistics have been generated for the application’s tables and indexes, which optimizer mode will oracle user
a cost
b rule
c hint
d none of the above
16 which of the following lock type is the most restrictive
a exclusive
b unique
c exclusion
d non of the above

17 which lock type is taken out when creating, dropping or altering a table
a restrictive
b exclusive
c explicit
d shared
18 which of the following types of indexes stores the indexed columns values associated row id as binary string
a b-tree index
b reverse key index
c bitmap index
d bitwise index

19 which of the following factors would not make a column a good candidate for b-tree index
a the data in the column has low cardinality
b the column frequently used in sql statement where clases
c most queries on the table return only small portion of all row
d none of the above

20 index organized tables store row data that exceeds the index’s pct threshould in what type of segment
a chain segment
b excess segment
c overflow segment
d index segment

Solutions:

1 (c)
2 (c)
3 (a)
4 (b)
5 (b)
6 (c)
7 (b)
8 (a)
9 (d)
10 (a)
11( b)
12 (d)
13 (b)
14 (d)
15 (b)
16 (a)
17 (b)
18 (c)
19 (a)
20 (c)

Hope you like these Frequently asked questions for DBA

Related articles

100 Basics Questions on Oracle DBA

30 Frequently asked DBA questions

top 40 oracle dba interview questions and answers


Leave a Reply