SQL Questions:
1 Which of the following are some common RDBMS in use?
A. Oracle
B. MySQL
C. SQLite
D. All of the above
2. What command is used to create a new table in SQL?
A. CREATE TABLE
B. BUILD TABLE
C. GENERATE TABLE
D. None of the above
3. What does the following statement in SQL do? DROP TABLE student;
A. Deletes a table called student.
B. Creates a table called student.
C. Check if there is a table called student.
D. None of the above.
4. Which of the following matches the definition given below: It is an artificial key that aims to
uniquely identify each record.
A. Primary Key
B. Foreign Key
C. Surrogate Key
D. Composite Key
5. Which of the following commands are used to put a restriction on the number of rows
returned from a query?
A. LIMIT
B. LIKE
C. WHERE
D. GROUP BY
6. Primary key can be?
A. NULL
B. NOT NULL
C. Both NULL and NOT NULL
D. Depends on situation
7. What is a table joined with itself called?
A. Join
B. Self-join
C. Outer join
D. None of the above
8. What is the full form of SQL?
A. Structured Query Language
B. Sample Query Language
C. Structured Query List
D. None of the above
9. Which data manipulation command is used to combines the records from one or more
tables?
[Link]
[Link]
[Link]
[Link]
10. Which operator is used to compare a value to a specified list of values?
[Link]
[Link]
[Link]
[Link]
11. Which of the following is a comparison operator in SQL?
[Link] equal sign ( == )
[Link]
[Link]
[Link] equal sign ( = )
12. The COUNT function in SQL returns the number of ______________
[Link]
[Link] values
[Link] By
[Link]
13. What is the full form of DDL ?
[Link] Data Language
[Link] Data Language
[Link] Definition Language
[Link] Derivation Language
14. Which statement in SQL allows us to change the definition of a table is?
[Link]
[Link]
[Link]
[Link]
15. A command that lets you change one or more fields in a record is :
[A] Insert
[B] Modify
[C] Look-up
[D] All of the above
16. Which of the following is an aggregate function in SQL ?
A Union
B Like
C Group By SQL provides many aggregate functions that include
D Max avg, count, sum, min, max, etc.
17. An alias is :
A An alternate name given to a relation.
B An alternate name given to an inner query.
C An alternate name given to a user.
D None of the above.
18. Which type of join returns all rows that satisfy the join condition ?
A Inner join
B Outer join
C Semi Join
D Anti join
19. Which one of the following aggregate SQL function returns number of rows ?
A avg
B min
C count
D sum
20. A SQL query automatically eliminates duplicates (True / False) ?
[Link]
[Link]
Subjective questions:
1. What is a Dimension in Tableau?
2. What is a Measure in Tableau?
3. What is data blending?
4. What is a story in Tableau?
5. What is DBMS?
6. What is a Primary Key?
7. What is a Join? List its different types.
8. What are Entities and Relationships in Databases? Explain with a diagram.
9. What are the differences between OLTP and OLAP?
10. What is a Stored Procedure? Give an example.