Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Evaluate the statement: DELETE FROM customer; Identify which one of the following will the outcome after the statement is queried in SQL? O a. The
Evaluate the statement: DELETE FROM customer; Identify which one of the following will the outcome after the statement is queried in SQL? O a. The statement removes the structure of the CUSTOMER table from the database O b. The statement deletes the CUSTOMER column O C. The statement deletes all the rows from the CUSTOMER table O d. The statement deletes the first row in the CUSTOMERS table To display all the students whose names (of any length) start with the letters 'S'. Which WHERE clause should be used? a. Where name like '%S'; O b. Where name like '%S%'; O c. Where name like 'S%; O d. Where name like's'; Mr. Saleh is a database administrator. He wishes to use group functions. Which of the following is the correct SQL statement? O a. Where marks avg(marks); O b. Where avg(marks) o c. Having avg(marks); O d. Group by avg(marks); The storage structure in a relational database is: O a. Field O b. Row O C. Column O d. Table D Identify the correct output after the given below statement is executed successfully in a RDBMS. Select sum(marks), avg(marks) from students; O a. Return total marks and average marks from all the students. O b. Return total marks from each student. C. Statement is wrong. O d. Return average marks from the students table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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