What is Schema in Database?



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

Post New Answer

More SQL Server Interview Questions

What is coalesce in sql server?

0 Answers  


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

0 Answers   CSC, IBM,


What are the differences between left join and inner join in sql server?

0 Answers  


I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,


How to create view in stored procedure sql server?

0 Answers  






Explain indexed views and partitioned view with their syntax.

0 Answers  


How to enable/disable indexes?

0 Answers  


Mention the 3 ways to get a count of the number of records in a table.

0 Answers  


What happens to a statement batch if there is a compilation error?

0 Answers  


What is checkpoint process in the sql server?

0 Answers  


Can foreign key be deleted?

0 Answers  


what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  


Categories