Answer Posted / vinod singh kushwah

A primary key is used to uniquely identify each row in a
table. It can either be part of the actual record itself ,
or it can be an artificial field (one that has nothing to
do with the actual record). A primary key can consist of
one or more fields on a table. When multiple fields are
used as a primary key, they are called a composite key.
Primary keys can be specified either when the table is
created (using CREATE TABLE) or by changing the existing
table structure (using ALTER TABLE).
Below are examples for specifying a primary key when
creating a table:

MySQL:

CREATE TABLE Customer
(SID integer,
Last_Name varchar(30),
First_Name varchar(30),
PRIMARY KEY (SID));

Oracle:

CREATE TABLE Customer
(SID integer PRIMARY KEY,
Last_Name varchar(30),
First_Name varchar(30));

SQL Server:

CREATE TABLE Customer
(SID integer PRIMARY KEY,
Last_Name varchar(30),
First_Name varchar(30));
Below are examples for specifying a primary key by altering
a table:

MySQL:

ALTER TABLE Customer ADD PRIMARY KEY (SID);

Oracle:

ALTER TABLE Customer ADD PRIMARY KEY (SID);

SQL Server:

ALTER TABLE Customer ADD PRIMARY KEY (SID);

Explain cascading triggers.

1053

---

What are the execution control statements in oracle?

1065

---

Point out the difference between user tables and data dictionary?

965

---

what is insert all statement in sql

6478

---

How to change user password in oracle?

1003

---

What is oracle server autotrace in oracle?

1139

---

What are the varoius components of physical database structure of oracle database?

982

---

defination of bitmap index

2095

---

How can I create database in oracle?

992

---

What suggestions do you have to reduce the network traffic?

936

---

How to rebuild an index in oracle?

1008

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1028

---

How to set up autotrace for a user account?

1028

---

How to define an anonymous block?

1126

---

Oracle

2353

---