MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can organize your jobs into categories either by using the SQL Server built-in categories, such as Database Maintenance, or by defining your own.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -To create a job category Click the plus sign to expand SQL Server Agent. Right-click the Jobs folder and select Manage Job Categories. In the Manage Job Categoriesserver name dialog box, click Add. In the new dialog box, in the Name box, enter a name for the new job category.

Detailed explanation-2: -Members of the sysadmin fixed server role can perform any activity in the server. Members of the serveradmin fixed server role can change server-wide configuration options and shut down the server.

Detailed explanation-3: -SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM, and Azure Synapse Analytics.

There is 1 question to complete.
Previous
Next