Question - 1
What is the full form of SQL?
- Structured Query List
- Structure Query Language
- Simple Query Language
- None of the above
Solutions
Answer- B
Question - 2
What is DDL command stands for?
- Data definition language
- Data delectation language
- Data Defined language
- None of the above
Solutions
Answer- A
Question - 3
Which of the following is not a DDL command?
- DROP
- ALTER
- TRUNCATE
- UPDATE
Solutions
Answer- D
Question - 4
Which of the following is not a valid SQL type?
- FLOAT
- NUMERIC
- DECIMAL
- CHARACTER
Solutions
Answer- C
Question - 5
Which of the following are TCL commands?
- COMMIT and ROLLBACK
- UPDATE and TRUNCATE
- SELECT and INSERT
- GRANT and REVOKE
Solutions
Answer- A
Question - 6
Which is not a category of SQL command.
Answer- D
Question - 7
Which of the following do you need to consider when you make a table in SQL?
- Data types
- Primary keys
- Default values
- All the above
Solutions
Answer- D
Question - 8
Which of the following SQL clauses is used to DELETE tuples from a database table?
Answer- A
Question - 9
Which operator is used to compare a value to a specified list of values?
Answer- B
Question - 10
How many Primary keys can have in a table?
- 1
- 2
- As much as we want
- None the these
Solutions
Answer- A
Question - 11
Which of the following is not Constraint in SQL?
- Primary Key
- Check
- Not Null
- Union
Solutions
Answer- D
Question - 12
A database language used for defining the whole database structure and schema is called
- DDL
- DML
- DCL
- None of the above
Solutions
Answer- A
Question - 13
Which of the following is not a valid aggregate function?
Answer- B
Question - 14
What operator tests column for absence of data
- IS NULL Operator
- NOT Operator
- == NULL Operator
- IS EMPTY Operator
Solutions
Answer- A
Question - 15
Which of the following operations requires the relations to be union compatible?
- UNIONB
- INTERSECTION
- DIFFERENCED
- ALL OF THESE
Solutions
Answer- D
Question - 16
How many types of subquery are in SQL Server?
Answer- A
Question - 17
How many types of indexes In SQL Server?
Answer- B
Question - 18
What is a stored procedure?
- Stored Procedure is a function
- Stored Procedure is a SQL statement
- Stored Procedure is a function consists of many SQL statement
- None of these
Solutions
Answer- C
Question - 19
What is the difference between DELETE and TRUNCATE commands?
- TRUNCATE removes single single rows from the table, whereas DELETE used for delete all rows from a table
- DELETE use for delete a table whereas TRUNCATE use for delete database
- DELETE can removes a single row with where condition but TRUNCATE Can not delete single row
- None of the above
Solutions
Answer- C
Question - 20
SQL Views are also known as
- Simple tables
- Complex tables
- Virtual tables
- Real Tables
Solutions
Answer- C
Practice more set questions