RDBMS-SQL

What is full form of SQL

• Structured Query Language 
• Strong Question Language
• Structured Question Language
• Strong Query Language
• Structure Query Language 

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
• SELECT * FROM Persons WHERE FirstName='Peter'
• SELECT * FROM Persons WHERE FirstName<>'Peter'
• SELECT * FROM Persons WHERE FirstName<>'Peter'
• SELECT * FROM Persons WHERE FirstName=='Peter'

With SQL, how can you insert a new record into the "Persons" table?

• INSERT INTO Persons VALUES ('Jimmy', 'Jackson')  
• INSERT ('Jimmy', 'Jackson') INTO Persons
• INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
• INSERT VALUES ('Jimmy, Jackson') INTO Persons
• INSERT ('Jimmy', 'Jackson') VALUES into Persons

Which of the following is valid SQL for an Index?

• CREATE INDEX ID;
• CHANGE INDEX ID;
• ADD INDEX ID;
• REMOVE INDEX ID;
• DELETE INDEX ID;

The HAVING clause does which of the following?

• Acts like a WHERE clause but is used for groups rather than columns.
• Acts like a WHERE clause but is used for rows rather than columns.
• Acts like a WHERE clause but is used for columns rather than groups.
• Acts EXACTLY like a WHERE clause.
• Acts like a WHERE clause but is used for groups rather than rows.

Which one of the following sorts rows in SQL?

• SORT BY
• ALIGN BY
• ORDER BY
• GROUP BY
• SORT

The DROP TABLE statement:

• deletes the table structure only.
• deletes the table structure along with the table data.
• works whether or not referential integrity constraints would be violated.
• is not an SQL statement.
• deletes the data only.

Which of the following is NOT a type of SQL constraint?

• Primary Key
• Foreign Key
• Alternate Key
• Unique
• NOT NULL

A table joined with itself is called

• Join
• Self Join
• Outer Join
• Equi Join
• Right Join

Which of the following function cannot be performed by SQL ?

• Setting permissions on tables
• Creating views in a database
• Updating records
• Creating Complex UI
• Delete database