Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Write the complete SQL statement for creating a new database called addressbook 2. Which statement is used to list the information about a table?

image text in transcribed

1. Write the complete SQL statement for creating a new database called addressbook 2. Which statement is used to list the information about a table? How do you use this statement? 3. How would you list all the databases available on the system? 4. Write the statement for inserting the following data in employee_data table First name: Rudolf Last name: Reindeer Title: Business Analyst Age: 34 Years of service: 2 Salary: 95000 Perks: 17000 email: rudolf@bugnet.com 5. Give two forms of the SELECT statement that wil list all the data in employee_data table 6. What will select fname, email from employee_data, display? 7. Write the statement for listing data from salary, perks and yos columns of employee_data table 8. How can you find the number of rows in a table using the SELECT statement? 9. What will select salary, Lname from employee_data; display? Page Break

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

Oracle RMAN For Absolute Beginners

Authors: Darl Kuhn

1st Edition

1484207637, 9781484207635

Students also viewed these Databases questions

Question

Write down the circumstances in which you led.

Answered: 1 week ago