Explain The Following Fixed Server / Database Roles That...

ASSESSMENT TASK1 THEORETICAL QUES. Q1. Explain the following fixed server/ database roles that exist in the sql server; a) Sysadmin b) Securityadmin c) Dbcreator d) Db_owner e) Db_accessadmin f) Db_securityadmin Ans.;- a) Sysadmin;-the sysadmin fixed server role can perform any activity in the server. The local administrator group are member of the sysadmin fixed server role. The users with sysadmin server role. The sysadmin a complete control of your server. There is a vulnerability database to run sql codes internal sql injection. b) Securityadmin; - fixed server role manage logins and their properties. They can AWARD, REBUFF, and REVOKE server-level permissions. The database level permission if they have access to a database. c) Dbcreator: - the dB creator stationary server role can create databanks, and can adjust and return their own databases. This role a login create database. This is typically normal user is a member of development teams and the like. The owner a given do anything within particular database. d) Db_ownre:- Stationary database role can perform all arrangement and repairs activities on the database, and can also drib the database you can add database other sql server roles into database role. Each member fixed database role can add other login to same role. e) Db_accessadmin:- db_accessadmin stable database part can add or remove contact for Holes logins, Windows groups, and SQL Server. It is going to allow nativeShow MoreRelatedWindows Sql Server Database Design And Optimization Essay5564 Words   |  23 Pages : Assessment: Windows SQL Server Database Design and Optimization ID NO : 14091138 SUBMITTED TO : Imran Sidqque SUBMITTED DATE: /july/2015 Diploma in Information Technology (Level 7) Assessment: Windows SQL Server Database Design and Optimization Subject Code: WD 602 Assessment: Task One Theoretical Questions Outcome 1 (1.1) Q1. Briefly explain following designing requirements that are required whenRead MoreWindows Sql Server Database Design And Optimization Essay4264 Words   |  18 Pages Tasman International Academies Diploma in information Technology Level 7 Assignment: - Windows SQL server Database Design and Optimization Subject code: WD 602 Name: Anurag ID: 15052231 Submitted to: Mr. Imran Siddique Outcome 1 (1.1, 1.2, 1.3) Q 1 Briefly explains following designing requirements that are required when designing the hardware and software infrastructure: - Ans: - Infrastructure in everything that helps in the flow and the processing of data. Infrastructure provides aRead MoreA Short Note On Storage Requirements And Data Distribution Requirements Essay4447 Words   |  18 Pagesrequirements. The physical size of the database, you have to consider the exchange development rate and data distribution requirements. There are some topic which are assessing current storage capacity:- †¢ Disk-space capacity †¢ Disk throughput capacity †¢ Locations and roles of database servers Network requirements: - all database administrators and infrastructure ought to have a stray pieces comprehension of the topology of the system supporting the database servers on the grounds that this effects infrastructuralRead MoreWhen Designing The Hardware And Software Infrastructure5952 Words   |  24 PagesQ1. Briefly explain following designing requirements that are requires when designing the hardware and software infrastructure: a) Storage requirements b) Network requirements c) CPU requirements d) Memory requirements Ans. There is one of the table which designing for hardware and software infrastructure. Software Hardware Programing system Hard disks for storage Operating system Power supply Internet explore Cluster services firewall Central processing unit Visual Basic (VB) Power supplyRead MoreWindows Sql Server Database Design Essay8605 Words   |  35 PagesASSESSMENT: Windows SQL Server Database Design and Optimization STUDENT NAME:: RANJIT SINGH STUDENT ID :: 14112532 ASSESSOR NAME:: IMRAN SIDDIQUE DATE SUBMITTED:: 20/07/2015 SUBJECT:: ASSESSMENT (THEORY) Assessment: Task One Theoretical Questions Outcome 1 (1.1) Q1. Briefly explain following designing requirementsRead MoreDesign A Knowledge Management ( Km ) System For The Bank Of Greece2530 Words   |  11 Pageshow the bank should develop its culture and share knowledge within the organisation to improve its working environment. Knowledge creation methods and strategies for delivering the captured knowledge using a delivery interface are given. Further, KM roles and responsibilities are analysed to divide the workload within the organisation. The infrastructure requirements for establishing a virtual environment utilising information technology support are explained. Finally, the need for continuous performanceRead MoreReview Quesition20349 Words   |  82 PagesDATABASE SOLUTIONS (2nd Edition) THOMAS M CONNOLLY CAROLYN E BEGG SOLUTIONS TO REVIEW QUESTIONS Chapter 1 Introduction- Review questions 1.1 List four examples of database systems other than those listed in Section 1.1. Some examples could be: †¢ A system that maintains component part details for a car manufacturer; †¢ An advertising company keeping details of all clients and adverts placed with them; †¢ A training company keeping course information and participants’Read MoreTypes Of Sap Hana Models10171 Words   |  41 Pagesdifferent models that can be created in SAP HANA. For each model type, the chapter defines the model in question, outlines the criteria for choosing it, and explains its benefits. 1.1 SAP HANA Database Engine Architecture SAP HANA is an in-memory technology platform that is deployable as an appliance or in the cloud. Its core is the SAP HANA database, which is built for high performance applications. It makes full use of the main memory and processing power provided by modern hardware. As relevant dataRead MoreInternet and Ebusiness Essay10788 Words   |  44 Pages4 1.2: Explain the benefits and barriers to businesses considering an online presence. Explain some of the benefits that Banknet from the case study will have by using an e-Business solution. 6 1.3: Assess the security and legislative issues facing an online business organization. 8 1.4: State the mode of communication available to an e-business and their applications. Suggest the type of communication Banknet can use to make it more users friendly. 10 2.1: Explain the internetRead MoreSpeech Recognition Essay7119 Words   |  29 Pagestechnology is that in any given instant, the picture on the screen is not the total image, but is instead rapidly alternating between images consisting of the individual red, green, and blue colors. Thus the eye and the brain play the last critical role in making single chip DLP projectors work, by combining or averaging or integrating the picture, so that the viewer perceives the desired image and not the rapidly flashing momentary components of the image.   A problem with DLP can also be light