Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

WRITE SQL CODE Q.1. System Variables System variables can be set via the command line. Please write a sequence of statements to: - Set safe

WRITE SQL CODE

Q.1. System Variables

System variables can be set via the command line. Please write a sequence of statements to:

- Set safe updates to false for the session.

- Do the following at the global level: o Set the maximum number of connections to 45.

o Set the threshold for long running queries to 7 seconds do this at the global level.

o Set logs to expire when they are more than 3 days old

Write the commands to display the value of the four variables you have updated.

Q.2. Managing Users

Write statements that do the following:

- Create users as follows: o Create user daisy with password imadog

o Create user elmo with password imacat

o Create user ap_superuser with password imsuper

o Create user ap_dev with password apdev

o Create user ap_guest with password apuser

- Rename user daisy to have username lazydaisy

- Change password for daisy to be imalazydog

- Drop user elmo

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server Query Performance Tuning

Authors: Sajal Dam, Grant Fritchey

4th Edition

1430267429, 9781430267423

More Books

Students also viewed these Databases questions

Question

What are the logistics implications of internationalisation?

Answered: 1 week ago

Question

1.The difference between climate and weather?

Answered: 1 week ago

Question

1. What is Fog ?

Answered: 1 week ago

Question

How water vapour forms ?

Answered: 1 week ago

Question

What is Entrepreneur?

Answered: 1 week ago

Question

Which period is known as the chalolithic age ?

Answered: 1 week ago

Question

How wide are Salary Structure Ranges?

Answered: 1 week ago