Answer Posted / dharshana

DBMS:
-Is a single user system.
-Does not support client server architecture.
-Normalization techniques cannot be applied.
-Memory allocation is less.

RDBMS:
-Is a multi user system.
-Supports client server architecture.
-Normalization techniques cannot be applied for checking
the consistency of the database system.
-Memory allocation is huge.

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

1928

---

Can group by and ordered by used in a single query?

986

---

What are stored-procedures? And what are the advantages of using them.

978

---

What is meant by database server?

1005

---

What are the key constraints in dbms?

965

---

What is a data source (ds)?

932

---

1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

2215

---

What are the package used in DBMS ?

2614

---

Explain issues for database performance.

951

---

Describe why operational and informational systems are separate.

950

---

Explain 2nf?

955

---

What is a concurrency problem in dbms?

975

---

What are the characteristics of data in the database?

982

---

What is difference between database and schema?

991

---

List few restrictions that are imposed while creating views?

883

---