Introduction to Database Concepts, Terminologies and SQL
This Test will cover some terms based questions about Databse and SQL, to introduce you to terminologies used in DBMS.
Q. It is better to use files than a DBMS when there are _______ .
Q. The conceptual model is _______ .
Q. What is a relationship called when it is maintained between two entities?
Q. Which of the following operation is used if we are interested in only certain columns of a
table?
Q. Which of the following is a valid SQL type?
Q. The RDBMS terminology for a row is _______?
Q. Which of the following operations need the participating relations to be union compatible?
Q. The full form of DDL is _______?
Q. Which of the following is an advantage of a View?
Q. Which of the following is a legal expression in SQL?
Q. Which of the following statements are TRUE about an SQL query?
- An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause
- An SQL query can contain a HAVING clause only if it has a GROUP BY clause
- All attributes used in the GROUP BY clause must appear in the SELECT clause
- Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
Q. Which database level is closest to the users?
Q. Which are the two ways in which entities can participate in a relationship?
Q. The result of the UNION operation between R1 and R2 is a relation that includes _______?
Q. Which of the following is a comparison operator in SQL?
