Free Test What is SQL? – SQL

Q1: What is the primary use of SQL?

A. Creating UI interfaces B. Designing websites C. Managing and manipulating databases D. Building operating systems

Q2: What does SQL stand for?

A. Structured Question Language B. Structured Query Language C. Simple Query Language D. Sequential Query Logic

Q3: Which of the following best describes SQL?

A. A database B. A programming language C. A query language D. An operating system

Q4: SQL is primarily used for?

A. Designing databases B. Querying and managing data C. Developing apps D. Creating networks

Q5: Which of the following is not a SQL command?

A. SELECT B. DELETE C. PRINT D. INSERT

Q6: What type of language is SQL?

A. Object-oriented B. Procedural C. Query-based D. Functional

Q7: Which SQL statement is used to extract data from a database?

A. SELECT B. GET C. EXTRACT D. OUTPUT

Q8: Which SQL command is used to remove all records from a table?

A. DELETE B. REMOVE C. ERASE D. TRUNCATE

Q9: Which SQL clause is used to filter the records?

A. WHERE B. FILTER C. ORDER BY D. GROUP BY

Q10: Who developed SQL?

A. Microsoft B. IBM C. Oracle D. Google

Q11: What is the default port for SQL Server?

A. 1521 B. 3306 C. 1433 D. 5432

Q12: Which of the following is used to define the structure of a table?

A. DML B. DDL C. TCL D. DCL

Q13: Which SQL keyword is used to prevent duplicate entries in results?

A. DISTINCT B. UNIQUE C. NO DUPLICATE D. FILTER

Q14: Which clause is used to group rows with the same values?

A. ORDER BY B. GROUP BY C. UNION D. JOIN

Q15: Which function returns the number of rows in SQL?

A. COUNT() B. SUM() C. TOTAL() D. ROWS()

Q16: Which SQL keyword is used to insert new data?

A. INSERT INTO B. ADD C. NEW RECORD D. PUT INTO

Q17: Which SQL keyword is used to update data in a table?

A. MODIFY B. CHANGE C. UPDATE D. SET

Q18: What is a primary key in SQL?

A. A field with null values B. A unique identifier for each record C. A duplicate field D. A foreign reference

Q19: Which statement is used to remove a table from the database?

A. DROP B. DELETE C. REMOVE D. ERASE

Q20: Which clause is used to restrict the groups of returned rows?

A. WHERE B. HAVING C. GROUP BY D. ORDER BY

Quiz for What is SQL?