Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
QUESTION 1 10 points Save Answer Which of the following is used to restrict rows in SQL? O SELECT OFROM O WHERE GROUP BY QUESTION
QUESTION 1 10 points Save Answer Which of the following is used to restrict rows in SQL? O SELECT OFROM O WHERE GROUP BY QUESTION 2 10 points Save Answer Which of the following is not a SQL function? OMAX OSUM O MEAN O COUNT QUESTION 3 10 points Save Answer MS SQL Server, MongoDB, Oracle are three major database management systems. Which one of these is non-commercial open-source database management systems? O I and II O II and III O ll only I only QUESTION 4 10 points Save Answer Suppose there are two tables: A and B and we run command: SELECT from A RIGHT JOIN B on A.orderid = B.orderid. What will be the code output? only the records from table A where tables A and B have the same orderid only the records from table B where tables A and B have the same orderid the complete set of records from table A, along with the matching records (depending on the availability) from table B where tables A and B have the same orderid the complete set of records from table B, along with the matching records (depending on the availability) from table A where tables A and B have the same orderid* QUESTION 5 10 points Save Answer Suppose there are two tables: A and B. and we run command SELECT * from A LEFT JOIN B on A.orderid = B.orderid. What would be the code output? only the records from table A where tables A and B have the same orderid only the records from table B where tables A and B have the same orderid the complete set of records from table A, along with the O matching records (depending on the availability) from table B where tables A and B have the same orderid the complete set of records from table B, along with the O matching records (depending on the availability) from table A where tables A and B have the same orderid Suppose there are two tables: A and B and we run command SELECT * from A INNER JOIN B on A.orderid = B.orderid. What would be the code output? ; only the records from table A where tables A and B have the same orderid only the records from both tables A and B where tables A and B have the same orderid the complete set of records from table A, along with the O matching records (depending on the availability) from table B where tables A and B have the same orderid the complete set of records from table B, along with the O matching records (depending on the availability) from table A where tables A and B have the same orderid QUESTION 7 10 points Save An What is the function COUNT() used for? O to return the number of tables in a database. To return the number of SQL statements in query To return the number of columns that match a specified criteria To return the number of rows that match a specified criteria QUESTION 8 10 points Save An Which of the following is not a type of join? O LEFT JOIN FULLER INNER JOIN O INNER JOIN O FULL OUTER JOIN
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