Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions