Question: need help using oracle sql developer pleasa provide screenshots!!!! 1 - Create New Login ( SQL server authentication ) Login name should be Faisal Mohammed

need help using oracle sql developer pleasa provide screenshots!!!!
1
-
Create New Login
(
SQL server authentication
)
Login name should be "Faisal Mohammed
|
"
,
Password
"
1
2
3
"
and Confirm password
columns.
Create login yourloginname with password
=
'yourpassword'
Create login Testlogin with password
=
'
P@ssword'
2
-
Test the new created user login
(
in step
1
)
Now it is the time to test the newly created user login
(
above in step
1
)
,
is it working or not,
login with user name and password using SQL Server authentication
3
-
Create Database
Database name should be
"
CCDS
4
3
5
"
example
(
database with the name CCDS
4
3
5
)
4
-
Creating database backups.
Select backup type
(
Full
\
diff
\
log
)
and make sure to check destination path which is where
the backup file will be created.
5
-
Drop database
To remove your database from MS SQL Server.
Click OK to remove the database
(
in this example, the name is Testdb as shown in
the above screen
)
from MS SQL Server
6
-
Restoring Database
Restore the database using Backup file we create above in step No
3
.
7
-
Checking SQL Server logs and Export SQL Server logs
.
Export SQL server logs file in Text Document
(
.
log
)
!
!
!
-
Important Note: Attach the Sereen Shots of all above tasks
(
1
-
7
)
and server
.
Log
file" as text file in submission,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!