Only for 10 records.

Aman

• Mar 1st, 2021

Only for 10 records

Answer Question  Select Best Answer

What are the three key properties of RDBMS

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 12th, 2018

Implicit properties of Relational Database. An RDBMS is easily accessible using Structured Query Language (SQL) commands in them to manipulate data. SQL is the ISO standard language for interacting w...

Answer Question  Select Best Answer

Piyush Pathak

• Feb 1st, 2018

$$DBDATE$$ retrieves the current database or the server you using date
$$date$$ retrieves the current operating system or the current system you are working date.

palani

• Apr 26th, 2006

$$date$$ displaying local system date $$dbdate$$ displaying server date.

Answer Question  Select Best Answer

Ashwini

• Jan 25th, 2018

Procedure - Definition - Procedure is a program unit or a module that performs a particular task. Execution - A stored procedure is executed explicitly by issuing procedure call Parameters - St...

qptopm

 Profile Answers by qptopm Questions by qptopm

• Nov 3rd, 2016

Commit cannot be done in case of triggers except for autonomous transactions. When you create a trigger you have to identify event and action of your trigger. Triggers are implicitly called by DB itself

Answer Question  Select Best Answer

Union operator in structured query lanhuage

Ashwini

• Jan 25th, 2018

Union combines the results of two or more SELECT statements and eliminates the duplicate rows

Answer Question  Select Best Answer

Diwakar

• Oct 20th, 2017

Anonymous block is independent piece of code to implement certain pseudo code. subprogram are some named entities like procedure and function which can be invoked from outside window.

YES procedure can be invoked using anonymous block.

Nupur

• Apr 25th, 2015

Answer to second part of the question : yes we can call a procedure from an anonymous block

Answer Question  Select Best Answer

Diwakar

• Oct 20th, 2017

AWR-Automiatic Workload repository is the report which provides finer details of work that was performed on DB during specific period. It provides following important details 1. Wait events causing...

Ora-Masala

• May 4th, 2016

The AWR is used to collect performance statistics including: Wait events used to identify performance problems. Time model statistics indicating the amount of DB time associated with a process fro...

Answer Question  Select Best Answer

What is modules

• Feb 24th, 2017

In easy language for beginner

Jai pal reddy

• Jun 9th, 2007

Set con=createobject("ADODB.connection")set rs=createobject("ADODB.recordset")set cmd=createobject("ADODB.command")con.provider=(Microsoft.jet.oledb.4.0")con.open "select the path of the database"rs.open "enter sql querry",con

Answer Question  Select Best Answer

eswar

• Dec 28th, 2016

Basically a simple and complex views can be differentiated based on the relations, functions and groups of data not by number of tables in the views. Ex: We can not apply Insert, Delete and Update on...

Bahadar Ayaz

• Jul 20th, 2011

Here are few differences between simple and complex views. 1. A Simple view selects from one table. A Complex view selects from one or more tables. 2. A Simple view does not contain functions but Com...

Answer Question  Select Best Answer

ANURAG

• Oct 22nd, 2016

How do we configure that? Any help would be appreciated...

Enamul

 Profile Answers by Enamul Questions by Enamul

• Jul 9th, 2008

At first configure webconfig file that have in server folder.

Answer Question  Select Best Answer

Hi..I am a student and I am learning software quality assurance subject...I want to know how to writes test cases for an email inbox of an email account.I will be very thankful to u

Mukesh

• Oct 1st, 2016

Hi swagatika,
well written
but in case here is lots of things like Compose, Sent Mail, Draft, how to close Draft etc

swagatika

• Jan 10th, 2015

Pre Condition: 1-Device connected to open internet, able to access in the internet 2-Access the URL Steps: 1-Access www.gmail.com->login page->Enter created emailid and pwd 2-Click inbox field ->op...

Answer Question  Select Best Answer

1) What is meant by Joint DEPENDENCY in normalization?
2) What is a MULTIVALUED DEPENDENCY? Explain.

shivakumar

• Jan 12th, 2016

When you decompose a relation into sub relations and when you assembled those sub relations it should result in original loss-less relation. Such dependency is called join dependency. Example relation...

Athira.m.m

• Oct 12th, 2015

You see joint dependency means that when you decompose tables those decomposed table should satisfy JOIN dependency ie., when they are joined they should make the original table without any conflicts ...

Answer Question  Select Best Answer

Create the flowchart and algorithm for a module that will prompt the user to enter their height in feet and inches (two separate input values). The program should output “Guard” if the user is under 6’4”, “Forward” if the user is between 6’4” and 6’10”, and “Center” is the user is over 6’10”.

Nupur

• Apr 25th, 2015

1.declare variables ft and inch.
2. Enter the values.
3. Check for validity using case statement .
4. Print on screen using dbms_output.put_line

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

RicGupta1984  

 Profile Answers by RicGupta1984 Questions by RicGupta1984

• Member Since Sep-2007 | Mar 5th, 2008

---

A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored.

RDBMS is a Relational Data Base Management System Relational DBMS. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables. This excludes the databases that don't support a tabular structure or don't enforce relationships between tables.

Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.

Yes you can say DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard bcz rdbms difine the integrity constraint for the purpose of holding ACID PROPERTY.

asif shaikh

• Nov 22nd, 2014

And other major difference are dbms does not support constraints and normalization.

prashant_hcu

 Profile Answers by prashant_hcu Questions by prashant_hcu

• Aug 1st, 2010

DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some un...

Improve Answer

Im trying to create a traceable database for work using Access, and im finding that even though i have all the data i need and everything to trace where everything goes i cant seem to get my queries to work. I need to have Table A, B, and C connect to D and connect to E with a query at E to go backwards to the other tables. A, B,and C dont have any relationships that connect them but they all connect...

ritam mitra

• Aug 30th, 2014

First try to check the join or connection between all the tables are proper, then create a view and then run query. it will work

Answer Question  Select Best Answer

How d you ensure end to end test coverage in ATDD process as functionality are delivered in pieces in different sprint?

I have a request about adding new application at existing oracle 11gr2 database.

What questions should I raise with the vendor about there application. Please give my answer at your earliest possible time, because my management waiting for the answers.

Thanks in advance.
Ibrahim

While installing Oracle 10g in window 7 it is giving error------
Abnormal Program termination.An internal error has occurred . Please provide the following files to Oracle support:
"Unknown" "Unknown" "Unknown"

Oracle2066

• Apr 26th, 2013

The question is over 2 years. How can you run windows Compatibility troubleshooter on an Oracle Internal error? It is not possible period. Please revisit Oracle Internal errors documentation at Oracle...

sushant

• Apr 26th, 2013

Just open control panel then click to Action Center ..There U will find the Window Programs Troubleshooting Compatibility Click that and browse the program u want to install

Answer Question  Select Best Answer

How to delete duplicate records in Teradata?

ram

• Apr 2nd, 2013

SELECT column names from party group by column names;

Use Distinct or Qualify

Answer Question  Select Best Answer

santosh varma

• Mar 21st, 2013

Check in v$dba_datafiles where the datafiles will start with prefix + are asm data bases

Answer Question  Select Best Answer