Question: 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?

 1. Write the complete SQL statement for creating a new database

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

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!