Database Test 6 Computer Subject
Database Test 6 Computer Subject
Question 11
In an SQL query, which SQL keyword is used to specify the names of tables to be joined?
The FROM clause specifies the tables to retrieve data from and is used to define the tables that can be joined.
Not clear enough?
Question 12
In SQL, which SQL keyword is used to specify the condition for a join operation?
The WHERE clause is used to filter rows and specify the condition for a join between tables.
Not clear enough?
Question 13
Regarding the interchangeability of subqueries and joins _____?
Joins and subqueries can sometimes replace each other depending on the requirement, but they are not always interchangeable.
Not clear enough?
Question 14
Which SQL keyword is used to add one or more rows to a table?
INSERT is the SQL command used to add new rows into a table.
Not clear enough?
Question 15
Which SQL keyword is used to change one or more rows in a table?
UPDATE is used to modify existing rows in a table based on given conditions.
Not clear enough?
Question 16
Which SQL keyword is used to change a column value?
SET is used with UPDATE to assign new values to specific columns.
Not clear enough?
Question 17
Which keyword is used to remove one or more rows from a table?
DELETE is the correct SQL command used to remove one or more rows from a table.
Not clear enough?
Question 18
WHERE clauses cannot refer to ranges and to partial values when _____?
IS NULL is used for null checks only and does not support ranges or partial values.
Not clear enough?
Question 19
Which of the following are the five built-in functions provided by SQL?
The five standard SQL aggregate functions are COUNT, SUM, AVG, MAX, and MIN.
Not clear enough?
Question 20
The SQL keyword GROUP BY instructs the DBMS?
GROUP BY groups rows that share the same values in specified columns for aggregate functions.
Not clear enough?
You might like
What is the present value of ₦3,500,000 to be paid at the end of 50 years if the correct risk adjusted interest rate is 18%?
I will faithfully give them their recompense, and I will make an everlasting covenant with them. The above statement of the LORD to Israel in Isaiah's prophecy suggests
Use the following information to answer this question:
Total of all expenditure incurred during the year: £ 80,000m
Indirect taxes on goods and services: £ 8,000m
Capital consumption: £ 6,000m
National income is __________.
Direction: Three of the following four number pairs are alike in a certain way and one is different. Find the odd one out ?