Which types of trigger can be fired on DDL operation?
A. Instead of triggerB. DML triggerC. System triggerD. DDL trigger

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

The trigger which can be fired on DDL operator is DDL trigger.

Answer Question  Select Best Answer

Name three activities involved in requirement gathering

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

Three activities involved in requirement gathering are
1.Eliciting requirement
2.Analyzing requirement
3.Recording requirement

Answer Question  Select Best Answer

Functions for error trapping are contained in which section of a PL/SQL block?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

The Exception section of the PL/SQL block contains the functions for error handling.

Answer Question  Select Best Answer

List the rules used to enforce table level integrity.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

There are 3 rules to enforce table level integrity. 1.Foreign key value can be modified only if we want to match the corresponding primary key value. 2.We cannot delete records either from parent or c...

Answer Question  Select Best Answer

Hi, I recently tried to get employee names and their dept names without a join condition, this query, although succeeds, I can't figure how it works. please help.

select ename,(select dname from dept where deptno=e.deptno) from emp e;

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Apr 11th, 2012

Youre using a Sub-query -- [(select dname from dept where deptno = e.deptno)] -- to get around using a join clause like -- [FROM EMP E INNER JOIN DEPT D ON (D.DEPTNO = E.DEPTNO)] -- however, you are n...

Blaster_Ayub_Khan

• Apr 10th, 2012

SQL coins the term query as the name for its commands. Basically, all SQL code is written in the form of a query statement and then executed against a database. All SQL queries perform some type of da...

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Value set is a collection of values.A value set associated with a report parameters, provides a list of values to the end user to accept one of the values as report parameter value.

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

I thhink it is simmilar to enum in c/c++

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Post block trigger belongs to Navigational triggers.

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 24th, 2007

Navigation Trigger

Answer Question  Select Best Answer

What is an intersection table and why is it important?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

An intersection table implements a many-to-many relationship between two business components.

scud021

 Profile Answers by scud021 Questions by scud021

• Jul 20th, 2008

A table added to the database to break down a many-to-many relationship to form two one-to-many relationships

Answer Question  Select Best Answer

How do indexes increase the searching capabilities?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 25th, 2012

By using the concept of serial scanning the indexes can increase the searching capabilities.

Answer Question  Select Best Answer

What is the degree of relationship? Name the three degrees.

kishorkakade

 Profile Answers by kishorkakade Questions by kishorkakade

• Jul 27th, 2012

The number of entity type involved
i.e
One : Unary
Two : Binary
Three : Ternary

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Degree of relationship is the cardinality of relationship that defines the number of instances of one entity as it relates to the number of instances of the other entity.Depending on the combinations ...

Answer Question  Select Best Answer

prathap

• Sep 14th, 2012

We can use "parallel" in the query and in the 11g we can use dynamic sampling.

dhivyavetriselvan

• Jul 26th, 2007

Select query can be made faster by using indexes.

Answer Question  Select Best Answer

Oracle stores information regarding the names of all the constraints on which table? A)USER_CONSTRAINTS B)DUAL C)USER D)None of these

Naresh kumar

• Oct 3rd, 2012

Constraints divided into 3 types those are: 1. domain integrity constraints:- not null,check 2. entity integrity constraints:- unique,Primary key 3. referential integrity constraints:- foreign key In...

sukrampal

 Profile Answers by sukrampal Questions by sukrampal

• Jul 12th, 2012

User-constraints and all_constraints

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Karanjeet

• Nov 22nd, 2005

---

Following are the tier types in a client server application:

a. 1 tier application:All the processing is done on one machines and number of clients are attached to this machine (mainframe applications)

b. 2 tier application: Clients and data base on different machines.Clients are thick clients i.e.? processing is done at client side.Application layer is on Clients.

c. 3 tier application.Client are partially thick.Apart from that there are two more layers application layer and database layer.

d. 4 tier application: Some clients may be totally non thick clients some clients may be partially thick and further there are 3 layers web layer, application layer and database layer.

Avinash

• Nov 24th, 2012

If I am not wrong

Class variables are variables which we create inside a class.

&

Class member are the variables & function declared inside class.

Manoj Kumar Chagantipati

• Jun 12th, 2012

In Two tier there will be Presentation layer and Data base layer
Where as in Three tire there will be Presentation layer,Data access layer and Data base layer

Improve Answer

sarat chand

• Dec 8th, 2012

Logical memory is based on schema design. but virtual memory is based on data access that means we want a data from hard disk(physical memory ) to main memory.

Answer Question  Select Best Answer

saratchand

• Dec 8th, 2012

Two type

In software :top down and button up approach
IN DBMS: generalization and specialization other is aggregation

Answer Question  Select Best Answer

How to remove only one column values from the duplication of values in that column without using any other column references in that table?

dhanraj varshney

• Jan 6th, 2013

Two methods..
Use unique key
Run query such way-insert ignore into table.

Answer Question  Select Best Answer

avinash

• Jan 21st, 2013

Yes to store excel file in data base just you have to save the excel file in .CSV(comma delimiter) format and then insert the value as usually in database.....

Waqas Ahmed

• Oct 6th, 2012

Here is the query to export data into csv file.

Code
span style="color: #ff0000;">"
ESCAPED BY 
LINES TERMINATED BY 
FROM products

Answer Question  Select Best Answer

Multiset table with UPI will allow duplicates or not?

Read Best Answer

Editorial / Best Answer

daniel.doboseru  

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Member Since Feb-2013 | Feb 6th, 2013

---

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it. Answer: No.

daniel.doboseru

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Feb 6th, 2013

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it.

Answer: No.

Improve Answer

Read Best Answer

Editorial / Best Answer

daniel.doboseru  

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Member Since Feb-2013 | Feb 6th, 2013

---

An ontology refers to a model that contains a set of classes (individuals) plus a set of relations between them. Lets consider a relational database model, having three tables: Human, Man, Woman. As you can observe, there is no relation defined between them. Well, in an ontology, besides that, you might also have a set of rules like: - Object X is Man, if and only if is Human, but is not Woman. - If object X is Human, then it is either Man or Woman, but not both. For defining ontologies there are several languages developed, the most representative being OWL (Web Ontology Language. And for querying them one must also use a specialized language (eg. SPARQL).

daniel.doboseru

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Feb 6th, 2013

An ontology refers to a model that contains a set of classes (individuals) plus a set of relations between them. Lets consider a relational database model, having three tables: Human, Man, Woman. As ...

Improve Answer

How to display nth lowest record in a table for example? How to display 4th lowest (salary) record from customer table?

Read Best Answer

Editorial / Best Answer

Answered by: Yadnesh

• Jun 1st, 2013

---

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtain derived column using DENSE_RANK() in a subquery and -- obtain temporary result set and finding nth record in a temporary result set using WHERE clause -- for the given example, following is the solution.

Code
 

Yadnesh

• Jun 1st, 2013

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtai...

Improve Answer