Is primary key indexed by default?

812

Is primary key clustered or nonclustered?

1035

What is SQL Azure?

107

How many concurrent programs you have customized, can you name some of them?

1

What command must you use to include the not null constraint after a table has already been created?

1173

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

734

What is plan freezing?

985

How do you exit a database?

910

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2464

What are different functions in sql?

960

How to insert dynamic values in mysql using php?

1152

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2318

How do I run a sql query?

1039

Create table employee (eno int(2),ename varchar(10)) ?

1021

Mention what plvcmt and plvrb does in pl/sql?

1156