Show
DBMS mcq questions with answers set 11 includes SQL mcqs, SQL basics questions and answers, SQL query mcq questions and Answer, SQL quiz questions, SQL online test, SQL objective questions, SQL mcq online test, structured query language mcqs, SQL query questions and answers for practice, database management system SQL mcq questions and answers. The following SQL mcqs are very helpful for UGC NET, GATE exam, GRE, lecture computer science, and database-related jobs test or interview. Its also helpful for Microsoft SQL and Oracle certification exams preparation Databas MCQs Set 111. SQL is a _____? Correct: B 2. To form a projection with SQL _____? Correct: A 3. To remove duplicate rows, this _____ qualifier must be specified. Correct: C 4. Which SQL keyword is used to name a new table and describe the table's columns? Correct: B 5. Which SQL keyword is used to change the structure, properties or constraints of a table? Correct: D 6. Which one of the following is used to define the structure of the relation, deleting relations and relating schema's? Correct: B 7. If table PRODUCT has a column PRICE with data type Numeric (8,2), it stores values as _____? Correct: A 8. If the
table PRODUCT has a column PRICE that has the data type Numeric (8, 2), the value 12345 will be displayed by the DBMS as _____? Correct: A 9. Which SQL keyword is used to delete a table's structure? Correct: B 10. When the correct SQL command is used to delete a table's structure, what happens to the data in the table? Correct: C 11. The _____ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate. Correct: A 12. In an SQL query, which SQL keyword is used to specify the table(s) to be used? Correct: D 13. The asterisk (*) means that _____? Correct: B 14. Which SQL keyword Is used to state the condition to specifies the rows to be selected? Correct: B 15. In an SQL query, which SQL keyword is used to join two conditions that both must be true for the rows to be selected? Correct: C 16. In SQL the spaces at the end of the string are removed by _____ function. Correct: C 17. In an SQL query, which SQL keyword is used to determine if a column value is equal to any one of a set of values? Correct: B 18. In an SQL query,
which built-in function is used to compute the number of rows in a table? Correct: D 19. In an SQL query, which built-in function is used to total numeric columns? Correct: A 20. In SQL, which built-in function is used to compute the average value of numeric columns? Correct: A 21. The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character. Correct: C 22. In an SQL, which built-in function is used to obtain largest value of numeric columns? Correct: B 23. In SQL,
which built-in function is used to obtain the smallest value of numeric columns? Correct: A 24. In an SQL query, which SQL keyword is used with built-in functions to group rows that have the same value in a specified column together? Correct: D 25. Which SQL keyword is used with GROUP BY to select groups meeting specified criteria? Correct: C 26. Which of the following statements contains an
error? Correct: D 27. Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command? Correct: D 28. In an SQL query, which SQL keyword is used to implement a subquery? Correct: B 29. When one SQL query is embedded in WHERE clause of another SQL query, it is called _____? Correct: A 30. _____ operator is used
for appending two strings. Correct: C Read also>->>Database MCQs With Answers Set 7 Read also>->>Database MCQs With Answers Set 8 Read also>->>Database MCQs With Answers Set 10 Read also>->>Database MCQs With Answers Set 12 Which SQL keyword is used to change the structure of a table?The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
Which SQL keyword is used to change one or more rows in a table a select B Update C insert and modify?The SQL UPDATE query is used to modify the existing records in a table.
Which SQL keyword is used to change the values of an entire column?The ALTER COLUMN command is used to change the data type of a column in a table.
Which SQL keyword is used to make a new table database?The SQL CREATE TABLE Statement. The CREATE TABLE statement is used to create a new table in a database.
|