Answered step by step
Verified Expert Solution
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?
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started