SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 299 123456789101112131415 SQL Questions 1 / 15 1. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional? A. select_list B. table_list C. row_constraint D. grouping_columns 2 / 15 2. What default value gets stored in columns of the table? A. NULL B. 1 C. -1 D. o 3 / 15 3. Which among the following is the correct syntax for modifying the definition of an existing table? A. ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT; B. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT; C. ALTER TABLE person MODIFY person_id ; D. ALTER TABLE person 4 / 15 4. Which Statement is used to insert the values in the table? A. INSERT INTO B. Insert C. INSERT D. None of the mentioned 5 / 15 5. Will the following SQL command produce any error? INSERT INTO person (person_id, fname,lname) VALUES (1,’S’,’U’), VALUES (1,’T’,’U’); /* where person_id is a primary key */ A. Error B. No Error C. Depends D. None of the mentioned 6 / 15 6. Select the correct syntax of SELECT TOP clause? A. SELECT TOP name B. SELECT TOP column C. SELECT TOP FROM D. SELECT TOP Number 7 / 15 7. Full form of TCL is – A. Transaction Common Language B. Transaction Commit Language C. Transaction Concatenate Language D. Transaction Control Language 8 / 15 8. How many Primary keys can have in a table? A. Only 1 B. Only 2 C. Depends on no of Columns D. Depends on DBA 9 / 15 9. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 10 / 15 10. What is the meaning of “REFERENCES” in table definition? A. Primary key B. NULL C. Foreign Key D. A ”foreign Key” belong to this particular table 11 / 15 11. SQL INSERT is used to insert a – A. Single or Multiple record B. Single or Multiple database C. Single or Multiple table D. None of the above 12 / 15 12. Which datatype can store unstructured data in a column? A. CHAR B. RAW C. NUMERIC D. VARCHAR 13 / 15 13. What is the role of “CONSTRAINS” in defining a table in Mysql? A. Declaring primary key B. Declaring Foreign Key C. Restrictions on columns D. All of the mentioned 14 / 15 14. Full form of DCL is – A. Data Control Language B. Data Commit Language C. Data Common Language D. Data Concatenate Language 15 / 15 15. Which command is used for the table definition in Mysql? A. DESC table_name; B. DESC table_name C. DESC D. None of the mentioned Your score is The average score is 59% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz