1) What keyword isused in SQl to retrieve data from a database? a) GET b) SELECT c) SEARCH d) RETURN 2) Which SQL clause is used to filter records? a) GROUP BY b) ORDER BY c) WHERE d) HAVING 3) What SQl clause is used to sort the result set in ascending order? a) ASC b) DESC c) SORT d) ORDER 4) In SQL , what is the purpose of the JOIN clause? a) TO FILTER RECORDS b) TO GROUP RECORDS c) TO COMBINE ROWS FROM TWO OR MORE TABLES d) TO SORT THE RESULT SET 5) Which SQL command is used to make changes to an existing database table? a) EDIT TABLE b) MODIFY TABLE c) UPDATE TABLE d) ALTER TABLE 6) What is the SQL keyword used to retrieve unique rows from a table a) ONLY b) DISTINCT c) UNIQUE d) SINGLE 7) Which operator is used in SQL to compare values? a) & b) <> c) II d) = 8) What SQl statement is used to delete data from a database? a) DELETE b) ERASE c) REMOVE d) TRUNCATE 9) In SQL, what clause is used to specify a specific condition while retrieving data? a) SORTY BY b) PICK c) WHERE d) CLARIFY 10) Which SQL command is used to add new rows to a table? a) ADD RECORD b) INSERT INTO c) CREATE ROW d) APPEND ROW 11) What SQL statement is used to retieve data from more than one table? a) REUNITE b) MERGE c) JOIN d) COMBINE 12) In SQL, which command is used to make a temporary copy oF a database table? a) CLONE b) COPY c) REPLIATE d) CREATE 13) What SQL clause is used to count the number of rows in a table? a) COUNT b) SUM c) TOTAL d) CALCULATE 14) What SQL operator is used to match a certain pattern. a) LIKE b) APPROX c) MATCH d) SIMILAR 15) Which SQL command is used to retrieve all records from a table? a) FETCH ALL b) GET ALL c) SELECT * d) SHOW ALL 16) Which SQL statement is used to update existing records in a table? a) MODIFY b) CHANGE c) UPDATE d) SAVE 17) In SQL, which command is used to remove a table from the database? a) DROP TABLE b) DELETE TABLE c) REMOVE TABLE d) ERASE TABLE 18) What keyword is used in SEL to retrive data from multiple tables based on a related column between them? a) TOGETHER b) LINK c) RELATE d) JOIN 19) Which SQL clause is used to restrict the number of rows returned? a) LIMIT b) HIDE c) SHRINK d) TRUNCATE 20) What SQL command is used to change the structure of a table? a) RESTRUCTURE b) RESHAPE c) MODIFY d) ALTER

SQL Commands Exam

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?