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 |
What is coalesce in sql server?
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
What are the differences between left join and inner join in sql server?
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?
Explain indexed views and partitioned view with their syntax.
How to enable/disable indexes?
Mention the 3 ways to get a count of the number of records in a table.
What happens to a statement batch if there is a compilation error?
What is checkpoint process in the sql server?
Can foreign key be deleted?
what is mean by crystal repoart? ahere we will mainly use that?