GeekInterview.com

DBMS Questions and Answers

 
Showing Questions 1 - 18 of 18 Questions
Sort by: 
 | 

How centralized DBMS differs from distributed DBMS .

Star Read Best Answer

Asked By: dharmendra | Asked On: Oct 9th, 2007

Answered by: ambika on: Oct 21st, 2013

Recovery in centralized dbms

Answered by: su4surya on: Aug 24th, 2009

A centralized database has all its data at one place so there may occur problems of data avalability, and a system crash may lead to whole dataloss. In a distributed database, database is stored on se...

3 answers


What is trigger in DBMS

Asked By: Interview Candidate | Asked On: Jul 17th, 2005

Answered by: samantha on: Apr 9th, 2013

The Event is performed and when the Condition is True The action is performed.................

Answered by: yuvrajpape88 on: Sep 12th, 2008

A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. Triggers can restrict access to specific data, perform logging, ...

6 answers


DBMS relation

In DBMS, what is a relation?

Asked By: Pragati.rch | Asked On: Feb 28th, 2008

Answered by: tarpeg on: Nov 30th, 2010

Relation is defined as a set of tuples that have the same attributes.

1 answer


What are the advantages and disadvantages of DBMS-SQL

Asked By: ddkdhar | Asked On: Mar 1st, 2007

Answered by: neerajalatha on: Jul 7th, 2010

Disadvantages:

It is slow when compared to native dynamic SQL and coding is also difficult when compared to native dynamic SQL.

Answered by: stshekhar on: Jun 22nd, 2008

Disadvantage :
1) Executing DDL statements through dbms_sql sometime can result in deadlock. example : we are trying to drop one object at the time it is being accessed by other user.

5 answers


DBMS analysis and requirements

Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS? Write your answer according to the requirements of Oracle 9i or 10g enterprise database system.

Asked By: aiman | Asked On: Nov 4th, 2007

Answered by: vdamodharan on: Jan 20th, 2010

That depends on what role you are playing in the DBA team.  If you are a operation DBA, then all you need to know to create a database are:  Initial sizing, redo, archive log size.  The...

1 answer


Set theory linked to DBMS

How is set theory linked to DBMS (union, intersection, minus, logical)

Asked By: Pragati.rch | Asked On: Feb 28th, 2008


How logical architecture of DBMS differs from physical architecture

Asked By: dharmendra | Asked On: Oct 9th, 2007

Answered by: vijaya_pitta on: Dec 12th, 2007

Architecture is the frame work of the Database Management System. They are simply classified into logical and physical.

1 answer


What is erow DBMS?

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

Answered by: naveen on: Jul 19th, 2007

Emerging Research Oppurtunities in Web Data Management

1 answer


exec send_test_message Step:1 Step:2 Step:3 Step:4 not executed i m in exeption please advise thanks " href="http://www.geekinterview.com/question_details/41477">PL/SQL procedure send mail problem

Hi all I wrote a procedure to send email via PL/SQL procedure, it was compiled successfully but not working .... here is the code (actuly I added the DBMS output like step1 ,step 2 to see in which step the control is going on ) {geshibot language="PL/SQL"}create or replace procedure send_test_message is mailhost...

Asked By: lalit4untl | Asked On: Jan 23rd, 2007

Answered by: KiranKW on: May 2nd, 2007

Hi,

   I dont see any problem with your code ... try to capture the return code for each of the calls ... that will help to identify the exact problem

1 answer


What is theta join in DBMS?

Asked By: Ashish Sharma | Asked On: Mar 27th, 2007

Answered by: tarun on: Apr 12th, 2007

Theta joins are those joins that use any of the comparison operators(i.e. less than,less than or equal to,greater than,greater than or equal to)

1 answer


What is the meaning of the following..1)if an input file has an excessive number of rows and can be split-up then use standard 2)logic to run jobs in parallel3)tuning should occur on a job-by-job basis....

Asked By: sudhakar | Asked On: Nov 17th, 2005

Answered by: tannya on: Nov 8th, 2006

The third point specifies about tuning the performance of job,use the power of DBMS means one can improve the performance of the job by using teh power of Database like Analyzing,creating index,creati...

Answered by: Sharanu Patil on: Feb 28th, 2006

Question is not clear eventhough i wil try to answer somethingIf u have SMP machines u can use IPC,link-colector,link-partitioner for performance tuningIf u have cluster,MPP machines u can use paralle...

2 answers


Hello frens..I'm a student of rvce,bangalore.Yahoo came here on 7-9-2006.Yahoo had 4 rounds 1.Written test2.Programming3.Technical interview4.Hrwritten test: included toTALLY 15 questions with different...

Asked By: Harish Kumar | Asked On: Sep 8th, 2006

Answered by: ApriL on: Nov 6th, 2006

hey, did they allow only computer sc students or studs from all streams? and finally how many did they take and from which branch?

thx.

1 answer


There was an off campus (subexazure ltd.) drive in bhubaneswar dated 3rd aug 2006.Pttern of interview:1. Written test a. Test C programming skill-20 questions for 30 minutes.All are objective...

Asked By: sisir kumar jena | Asked On: Aug 3rd, 2006

Answered by: mukul on: Sep 8th, 2006

i agree subex is the only company that is concern about talent not marks.......its rounds are too toughi got selected and working as pso.......all the best for all who want to join our family.....just...

1 answer


Can you name few DBMS packages and their use?

Asked By: Interview Candidate | Asked On: Aug 26th, 2005

Answered by: cmanne on: Jul 29th, 2006

DBMS_METADATA

DBMS_STATS

DBMS_SUPPORT

DBMS_SESSION

Answered by: akebono on: Aug 26th, 2005

 DBMS_OUTPUT.PUT_LINE('strings'); print out the strings  DBMS_UTILITY.get_time() get the current time  DBMS_ALERT e.g begin dbms_alert.register('myreg...

2 answers


What checklist questions could one come up with for the establishment of a DBMS for an organisation with 90pcs?

Asked By: Ezekiel Mafara | Asked On: Dec 13th, 2005

Answered by: apiplani on: Feb 14th, 2006

There are a number of things you can add to checklist while setting up DBMS and the checklist will depend on which kind of organisation is it. I am assuming you are a DBA setting up DBMS for software ...

1 answer


What is relational DBMS?

Asked By: Interview Candidate | Asked On: Jul 9th, 2005

Answered by: premika on: Jul 9th, 2005

RDBMS IS A TRANSPARENT INTERFACE BETWEEEN PHYSICOL STORAGE AND LOGICAL REPRESENTATION OF DATA 

1 answer


Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

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.