How would you go about increasing the buffer cache hit
ratio?
0. Explain the difference between a hot backup and a cold
backup and the benefits associated with each
1. You have just had to restore from backup and do not have
any control files. How would you go about bringing up this
database?
2. How do you switch from an init.ora file to a spfile?
3. Explain the difference between a data block, an extent
and a segment.
4. Give two examples of how you might determine the
structure of the table DEPT.
5. Where would you look for errors from the database engine?
6. Compare and contrast TRUNCATE and DELETE for a table.
7. Give the reasoning behind using an index.
8. Give the two types of tables involved in producing a star
schema and the type of data they hold.
9. What type of index should you use on a fact table?
10. Give two examples of referential integrity constraints.
11. A table is classified as a parent table and you want to
drop and re-create it. How would you do this without
affecting the children tables?
12. Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.
13. What command would you use to create a backup control
file?
14. Give the stages of instance startup to a usable state
where normal users may access it.
15. What column differentiates the V$ views to the GV$ views
and how?
16. How would you go about generating an EXPLAIN plan?
- 2 Answers
- 5037 Views
- I also Faced
- E-Mail Answers
Answer Posted / sathish
1)The hot backup basically backups database is it still up
and running and it must be in archive log mode.
Benefit-database available for use while the backup is
occurring and recover the database any point in time.
The cold backup basically backups database it is shutdown
and not required to being in archive log mode.
Benefit- easier to backup and recover abd slight performance
gain the database is not cutting archive logs to disk.
2)I would create a text based backup control file,
stipulating where on disk all the data files where and then
issue the recover command with the using backup control file
clause.
3)using spfile from pfile
4)Oracle save the data as datablocks..group of datablocks
know as extent and these extent are segmented
5)Alert log
7)Faster access to data blocks in a table.
8)Fact tables and dimension tables. A fact table contains
measurements while dimension tables will contain data that
will help describe the fact tables.
9)Bitmap Index
10)Primary key and foreign key
11)disable foreign key in parent table.do changes in parent
table then enable foreign key
12)ARCHIVELOG mode is a mode that you can put the database
in for creating a backup of all transactions that have
occurred in the database so that you can recover to any
point in time. NOARCHIVELOG mode is basically the absence of
ARCHIVELOG mode and has the disadvantage of not being able
to recover to any point in time. NOARCHIVELOG mode does have
the advantage of not having to write transactions to an
archive log and thus increases the performance of the
database slightly.
13)Alter database backup control file to trace
14)STARTUP NOMOUNT - Instance startup
STARTUP MOUNT - The database is mounted
STARTUP OPEN - The database is opened
15)The INST_ID column which indicates the instance in a RAC
environment the information came from.
16)Create a plan table with utlxplan.sql.
Use the explain plan set statement_id = 'tst1' into
plan_table for a SQL statement
Look at the explain plan with utlxplp.sql or utlxpls.sql
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are sql constraints?
What are stored procedures in mysql?
what are the differences between binary and varbinary? : Sql dba
Is truncate ddl or dml?
Can we join two tables without common column?
What is a string data type in sql?
Can we commit in trigger?
Why trigger is used in sql?
Where is all the data on the internet stored?
Explain spool.
Why do we need cursors in pl sql?
What are sql functions? Describe the different types of sql functions?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Can we rename a column in the output of sql query?
how many triggers are allowed in mysql table? : Sql dba
