What is Schema in Database?
Answer / pradeep
Schema is a logical set of data. It contains tables, views,
Packages, constraints. This is treated as a whole database.
This has assigned with a unique id called as SID i.e.
System ID. Because of this ID one can create n number of
DBs on a single DB server. Obviously within the limit of
the hardware of DB server.
| Is This Answer Correct ? | 11 Yes | 1 No |
Differentiate between SQL and ORACLE joins and write their syntax.
Do you have any idea about the tcl commands?
What are the difference between clustered and a non-clustered index?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
What is mean by candidate key?
what is Covering Index ?
Explain cursor as data base object?
What action plan is preferred if sql server is not responding?
What are the properties of primary key?
What are the differences between stored procedure and functions in SQL Server 2000?
25 Answers College School Exams Tests, HCL, Infosys, TCS,
How to find out name of all employees who has salary less than 200 Rs.?
What are page splits? : SQL Server Architecture
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)