MySql December 24, 2019 selva Online Exams Results ASP & XML Python ASP & XML Python Next#1. You can add a row using SQL in a database with which of the following? ADD ADD CREATE CREATE INSERT INSERT MAKE MAKE Next#2. _________ is a spatial data type. geometry geometry sql_variant sql_variant cursor cursor all of the mentioned all of the mentioned Next#3. You can delete a row using SQL in a database with which of the following? ADD ADD DELETE DELETE REMOVE REMOVE FLUSH FLUSH Next#4. The SQL WHERE clause limits the column data that are return limits the column data that are return limits the row data are return limits the row data are return both a and b are correct both a and b are correct Neither a nor b are correct Neither a nor b are correct Next#5. You want to track date and time of the last write access per row? Add TIMESTAMP column to the table Add TIMESTAMP column to the table Add a DATETIME column to the table and assign getdate() as the default value Add a DATETIME column to the table and assign getdate() as the default value Add a DATETIME column to the table and write a trigger that sets its value Add a DATETIME column to the table and write a trigger that sets its value Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server's built-in functions Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server's built-in functions Next#6. SQL can be used to Crete database structures only Crete database structures only query database data only query database data only modify database data only modify database data only All of the above can be done by SQL All of the above can be done by SQL Next#7. ntext datatype falls under which category? Exact numerics Exact numerics Character strings Character strings Unicode character strings Unicode character strings None of the mentioned None of the mentioned Next#8. The Wildcard in a WHERE Clause is useful when An exact match is necessary in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a SELECT statement An exact match is not possible in a SELECT statement An exact match is necessary in a CREATE statement An exact match is necessary in a CREATE statement An exact match is not possible in a CREATE Statement An exact match is not possible in a CREATE Statement Next#9. _______ is not a category of SQL command TCL TCL SCL SCL DCL DCL DDL DDL Next#10. Which of the following is large object data type? varchar(max) varchar(max) varbinary(max) varbinary(max) nvarchar(max) nvarchar(max) image image Next#11. Which of the following statements is true concerning subqueries? Involves the use of an inner and outer query Involves the use of an inner and outer query Cannot return the same result as a query that is not a subquery Cannot return the same result as a query that is not a subquery Does not start with the word SELECT Does not start with the word SELECT All of the mentioned All of the mentioned Next#12. What does the abbreviation DBMS stand for? Digital Base Mapping System Digital Base Mapping System Data Borrowing and Movement Software Data Borrowing and Movement Software DataBase Management System DataBase Management System Database Manipulation Software Database Manipulation Software Next#13. What does the abbreviation RDBMS stand for? Radio Digital Base Mapping System Radio Digital Base Mapping System Record Data Borrowing and Movement Software Record Data Borrowing and Movement Software Relational Database Management System Relational Database Management System Relational Database Manipulation Software Relational Database Manipulation Software Next#14. Which of the following data type is not present in SQL Server? bit bit boolean boolean hierarchical hierarchical geography geography Next#15. What type of join is needed when you wish to include rows that do not have matching values? Equal-join Equal-join Natural join Natural join Outer join Outer join All of the mentioned All of the mentioned Next#16. Exact numeric data type is ________ bigint bigint int int smallmoney smallmoney all of the mentioned all of the mentioned Next#17. The result of a SQL SELECT statement is a ____________ report report form form file file table table Next#18. ______ removes all rows from a table without logging the individual row deletions? DELETE DELETE REMOVE REMOVE DROP DROP TRUNCATE TRUNCATE Next#19. A Union query is which of the following? Combines the output from no more than two queries and must include the same number of columns Combines the output from no more than two queries and must include the same number of columns Combines the output from no more than two queries and does not include the same number of columns Combines the output from no more than two queries and does not include the same number of columns Combines the output from multiple queries and must include the same number of columns Combines the output from multiple queries and must include the same number of columns Combines the output from multiple queries and does not include the same number of columns Combines the output from multiple queries and does not include the same number of columns Next#20. The benefits of a standard relational language include which of the following? Reduced training costs Reduced training costs Increased dependence on a single vendor Increased dependence on a single vendor Applications are not need Applications are not need All of the above All of the above Next#21. Which of the following data type is not present in SQL Server? bit bit byte byte hybrid hybrid int int Next#22. Which of the following is valid SQL for an Index? CREATE INDEX ID; CREATE INDEX ID; CHANGE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; ADD INDEX ID; REMOVE INDEX ID; REMOVE INDEX ID; Next#23. __________ is monetary data type in SQL server. Smallmoney Smallmoney sql_variant sql_variant Cursor Cursor None of the mentioned None of the mentioned Next#24. The SQL WHERE Clause: limits the column data that are returned. limits the column data that are returned. limits the row data are returned limits the row data are returned Both A and B are correct Both A and B are correct Neither A nor B are correct Neither A nor B are correct Next#25. Which is not a type of join in T-SQL? Equi=join Equi=join Natural join Natural join Outer join Outer join Cartesian join Cartesian join Next#26. Which of the following SQL Clauses is used to DELETE tuples from a database table? DELETE DELETE REMOVE REMOVE DROP DROP CLEAR CLEAR Next#27. What is the purpose of the SQL AS Clause? The AS SQL clause is used change the name of a column in the result set or to assign a join The AS SQL clause is used change the name of a column in the result set or to assign a join The AS Clause is used with the JOIN Clause only The AS Clause is used with the JOIN Clause only The AS clause defines a search condition The AS clause defines a search condition All of the mentioned All of the mentioned Next#28. A column of type ________ may contain rows of different data types. ntext ntext date date smallmoney smallmoney sql_variant sql_variant Next#29. Which of the following is a correlated subquery? Uses the result of an inner query to determine the processing of an outer query Uses the result of an inner query to determine the processing of an outer query Uses the result of an outer query to determine the processing of an inner query Uses the result of an outer query to determine the processing of an inner query Uses the result of an inner query to determine the processing of an inner query Uses the result of an inner query to determine the processing of an inner query Uses the result of an outer query to determine the processing of an outer query Uses the result of an outer query to determine the processing of an outer query Next#30. Exact numeric data type is ____ float float bigint bigint smallmoney smallmoney all of the mentioned all of the mentioned Next#31. ________ is a spatial data type. geometry geometry sql_variant sql_variant cursor cursor all of the mentioned all of the mentioned Next#32. Which SQL function is used to count the number of rows in a SQL query? COUNT() COUNT() NUMBER() NUMBER() SUM() SUM() COUNT(*) COUNT(*) Next#33. SQL data definition commands make up a ______ DDL DDL DML DML HTML HTML XML XML Next#34. Data types in SQL Server are organized into how many categories? 6 6 8 8 7 7 10 10 Next#35. Which of the following are TCL Commands? UPDATE and TRUNCATE UPDATE and TRUNCATE SELECT and INSERT SELECT and INSERT GRANT and REVOKE GRANT and REVOKE ROLLBACK and SAVEPOINT ROLLBACK and SAVEPOINT Next#36. Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation Language To specify the syntax and semantics of SQL manipulation Language To define the data structures To define the data structures All of the above All of the above Next#37. A view is which of the following? A virtual table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL Comands A virtual table that cannot be accessed via SQL Comands A base table that can be accessed via SQL Commands A base table that can be accessed via SQL Commands A base table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands Next#38. Which of the datatype has storage size of 8 bytes? timestamp timestamp uniqueidentifier uniqueidentifier real real smallmoney smallmoney Next#39. _________ is monetary data type in SQL Server. Smallmoney Smallmoney sql_variant sql_variant Cursor Cursor None of the mentioned None of the mentioned Next#40. Select * from student join takes using select*from student inner join select*from student inner join select*from student outer join select*from student outer join select*from student left outer join select*from student left outer join All of the mentioned All of the mentioned Next#41. Which of the following is not the function of client? Compile queries Compile queries Query optimization Query optimization Receive queries Receive queries Result formatting and presentation Result formatting and presentation Next#42. Which of the following statement is true? DELETE does not free the space containing the table and TRUNCATE free the space containing the table DELETE does not free the space containing the table and TRUNCATE free the space containing the table Both DELETE and TRUNCATE free the space containing the table Both DELETE and TRUNCATE free the space containing the table Both DELETE and TRUNCATE does not free the space containing the table Both DELETE and TRUNCATE does not free the space containing the table DELETE free the space containing the table and TRUNCATE does not free the space containing the table DELETE free the space containing the table and TRUNCATE does not free the space containing the table Next#43. Select _________ from instructor where dept name “Comp-Sci”; Mean(salary) Mean(salary) Avg(salary) Avg(salary) Sum(salary) Sum(salary) Count(salary) Count(salary) Next#44. The SQL statement that queries or reads data from a table is _________ SELECT SELECT READ READ QUERY QUERY None of the above is correct None of the above is correct Next#45. To sort the results of a query use: SORT BY SORT BY GROUP BY GROUP BY ORDER BY ORDER BY None of the above is correct None of the above is correct Next#46. Which SQL keywords is used to retrieve a maximum value? MOST MOST TOP TOP MAX MAX UPPER UPPER Next#47. SQL can be used to create database structures only create database structures only query database data only query database data only modify database data only modify database data only All of the above can be done by SQL All of the above can be done by SQL Next#48. The wildcard in a WHERE clause is useful when? An exact match is necessary in a SELECT Statement An exact match is necessary in a SELECT Statement An exact match is not possible in a SELECT statement An exact match is not possible in a SELECT statement An exact match is necessary in a CREATE statement An exact match is necessary in a CREATE statement An exact match is not possible in a CREATE statement An exact match is not possible in a CREATE statement Next#49. The command to remove rows from a table customer is REMOVE FROM CUSTOMER; REMOVE FROM CUSTOMER; DROP FROM CUSTOMER; DROP FROM CUSTOMER; DELETE FROM CUSTOMER WHERE; DELETE FROM CUSTOMER WHERE; UPDATE FROM CUSTOMER UPDATE FROM CUSTOMER Next#50. Which of the following is one of the basic approaches for joining tables? Subqueries Subqueries Union Join Union Join Natural join Natural join All of the mentioned All of the mentioned Next#51. The HAVING clause does which of the following? Acts like a WHERE clause but is used for groups rather than rows Acts like a WHERE clause but is used for groups rather than rows Acts like a WHERE clause but is used for rows 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 like a WHERE clause but is used for columns rather than groups Acts EXACTLY like a WHERE clause Acts EXACTLY like a WHERE clause Next#52. What type of join is needed when you wish to return rows that do have matching values? Equi-join Equi-join Natural join Natural join Outer join Outer join All of the mentioned All of the mentioned Next#53. The SQL keywords ________ is used with wildcards. LIKE only LIKE only IN only IN only NOT IN only NOT IN only IN and NOT IN IN and NOT IN Next#54. The SQL keywords _______ is used with Where condition. Having Having Group by Group by Order by Order by Select Select Next#55. The SQL keywords _______ is used with Orderby. Having Having Like Like Join Join Groupby Groupby Next#56. The command to eliminate a table from a database is: REMOVE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; Next#57. A column of type ________ may contain rows of different data types. ntext ntext date date smallmoney smallmoney int int Next#58. Which one of the following sorts rows in SQL? SORT BY SORT BY ALIGN BY ALIGN BY ORDER BY ORDER BY GROUP BY GROUP BY Next#59. How many tables may be included with a join? 1 1 2 2 3 3 4 4 Next#60. Select ______ dept_name from instructor; All All From From Distinct Distinct Name Name Finish ASP & XML Python