COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
There are a few built-in schemas in SQL Server, Choose two
|
|
Db-owner
|
|
|
Dbo
|
|
|
Sysadmin
|
|
|
Guest
|
Explanation:
Detailed explanation-1: -The database schema is divided into three types, which are: Logical Schema. Physical Schema. View Schema.
Detailed explanation-2: -What is Schema in SQL? In a SQL database, a schema is a list of logical structures of data. A database user owns the schema, which has the same name as the database manager. As of SQL Server 2005, a schema is an individual entity (container of objects) distinct from the user who constructs the object.
There is 1 question to complete.