GeekInterview.com
Series: Subject: Topic:

Database Admin Interview Questions

Showing Questions 1 - 20 of 89 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Fractured block

Asked By: kamal_dadhich2004 | Asked On: Feb 13th, 2008

What is mean by fractured block in terms of manual hot backup?

Answered by: ganesh on: Mar 12th, 2013

In case of hot backup we get fractured blocks, because of this reason hot backups is called Inconsistent backup. let say in hot backups our operating system copies OS block by OS block while copy is g...

Answered by: alok83 on: Apr 11th, 2008

The concept of fractured block occrus when backup is under process.
It means you are taking backup and some other session is updating it.
Then backup process can not get the consistent image of the block and it will be inconsistent right thats why it is called fractured block.

What does ckpt do??

Asked By: swatis.niit | Asked On: Feb 14th, 2013

Recovery catalog

Asked By: santisofttuch | Asked On: Jan 11th, 2010

How will you find-out if your database is using recovery catalog or not?

Answered by: Ram on: Jun 20th, 2012

Querying views like rc_database in each catalog will identify the target database it is registered with.

Answered by: Lokesh M on: Dec 6th, 2011

There are few ways through which you would find if your database uses recovery catalog: Check backup scripts and findout if the scripts are making any connection to a recovery catalog. Check tnsnames...

How to schedule the backup with cron at LINUX ?

Asked By: naveenn.optimus | Asked On: May 3rd, 2011

Answered by: RAM on: Jun 20th, 2012

- - - - -
| | | | |
| | | | +----- Day of week (0-6)
| | | +------- Month (1 - 12)
| | +--------- Day of month (1 - 31)
| +----------- Hour (0 - 23)
+------------- Min (0 - 59)

What are the initial steps to follow a database backup and job scheduling ?

Asked By: prettyparamesh | Asked On: Feb 14th, 2012

Answered by: mary on: Jun 7th, 2012

Backup can be taken in 3 ways 1)Cold backup 2)Hot Backup 3)RMAN Backup 1)For taking cold backup we need to shutdown database.So it is not advisable 2)Hotbackup can be taken while the DB upon running...

Waterfall testing

Asked By: Priyathiyagu | Asked On: Jun 5th, 2012

What is a waterfall testing?

Do you need a commit after DDL statements?

Asked By: Interview Candidate | Asked On: Jun 1st, 2005

Answered by: Chintan on: May 29th, 2012

DDL is Auto Commited Statements.

Answered by: cmanne on: Mar 25th, 2007

There is no need to issue commit command after executing DDL statements as the DDL statements are commited automatically

What is the difference between these two?

Asked By: Snowbird | Asked On: Apr 8th, 2012

I am new here and I am not sure if I am posting this in the correct place. But I have recently started studying to be a programmer but because there is so much out there between these two I am getting more and more confused about how to answer this. Could someone please answer these so I can at least...

Answered by: Tom Haughey on: Apr 29th, 2012

I will refer predominantly to Relational DBMS. In a file system, data is contained in a flattened structure that is often a variable length structure. For example, a shipment received could contain th...

What is DDL, dml?

Asked By: Interview Candidate | Asked On: Jun 1st, 2005

Answered by: SHIMAR on: Apr 16th, 2012

DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop

Answered by: Venki on: Dec 19th, 2011

DDL means "Data Definition Language". SELECT, UPDATE, INSERT belong to DML, which is "Data Modification Language". DDL is all the other commands -- for example, CREATE TABLE.

Oracle - change columns to row

Asked By: sweetpush.07je | Asked On: Oct 8th, 2011

What is the query to change the rows into column and columns into row

Answered by: oracle2066 on: Dec 28th, 2011

Alter table A add column address1 varchar2(10);

Answered by: Manas Kumar Hati on: Oct 31st, 2011

Unsing Pivot Query

How to calculate the row length?

Asked By: aadhisrilatha | Asked On: Jun 9th, 2008

Answered by: Lokesh M on: Dec 7th, 2011

You can make use of VSIZE function to get the number of bytes in the internal representation of individual field. However this cannot be applied on fields that has BLOB data type and in such case you have to use dbms_lob.getlength function on BLOB data type field.

In what situation you have to prefer offline and online backups ?

Asked By: karthikdb | Asked On: May 20th, 2011

Answered by: Lokesh M on: Dec 6th, 2011

Online backup also known as hot backup / open backup can be performed even the database is open and while users are working and is available for read and write activity. To perform Online backup, the ...

Sort_area_size usage

Asked By: raghava.727 | Asked On: Jun 10th, 2011

Why we use sort_area_size parameter in init.Ora file?Kindly let me know?

Answered by: Lokesh M on: Dec 6th, 2011

SORT_AREA_SIZE is one of the deferred Oracle Server Parameters which is set in init.ora. Its value as bytes (integer) sets the size of in-memory sort work area. The default is 64K and the maximum valu...

Archivelog mode

Asked By: shanthiavari | Asked On: Jul 18th, 2008

Should you take the backup of logfiles if the database is running in archivelog mode?

Answered by: Shaikh Ziya on: Nov 22nd, 2011

Yes We can Take of Controlfile Online Mode Just
Fire The Command alter database backup controlfile trace And
alter database backup controlfile as trace '/Location where u want 2 take backup of ctlfile/';

Answered by: sulbha singh on: Sep 22nd, 2011

No, we can not take backup of redo log files even database is running in archive log mode because of inconsistency

How to recover the datafile without having backup?

Asked By: Saravana | Asked On: Aug 18th, 2011

Take cold backup and recover

Answered by: shoaib1786 on: Nov 5th, 2011

just create the datafile with same location mention in ur controlfile and recover the datafile ... Its simple.

Answered by: naveen on: Sep 19th, 2011

alter database create datafile 'and give the datafile location and /name' by using this command we can recover the datafile without backup also

How do you show Oracle free sga memory?

Asked By: manueljrd | Asked On: Sep 4th, 2011

Answered by: Harieshsivam on: Oct 13th, 2011

show sga;

we can see the memory of SGA space

What is the difference between database refresh and database cloning

Asked By: krishna | Asked On: Feb 1st, 2007

Answered by: Neo on: Oct 11th, 2011

Whats the process of refresh ? ( I mean steps). Do you export/import or we take a differential backup and restore on test DB ? Any links to an article will be of great help.

Answered by: dsp on: Aug 18th, 2011

Hi, There is little diff between them. First we clone the d.b totally(homepath,datafiles,data.....etc) from Prod to Test, where as in D.B Refresh we just refresh the additional data which is in p...

Disk space estimation

Asked By: Crescience | Asked On: Sep 26th, 2011

For this assignment task you will design a database for capturing student’s assessments marks and estimate the required amount of space. suppose we suppose that there are 5000 students at our institution and that on average each student registers for 5 courses in a semester design a database that...

How to use "alter database begin backup;" command in Oracle 9i.

Asked By: support dba 8910 | Asked On: Nov 25th, 2007

Answered by: sudhakar on: Sep 25th, 2011

1- When BEGIN BACKUP is issued: The hot backup flag in the datafile headers is set, so that the copy is identified to be a hot backup copy. This is to manage the backup consistency issue when the cop...

Answered by: tykarthick on: Oct 6th, 2009

Sql>alter database begin backup;The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.Freeze means lock i.e during backup no data's wil...

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.