MySql – Online Education & Certification

Results

#1. You can add a row using SQL in a database with which of the following?

ADD

CREATE

INSERT

MAKE

#2. _________ is a spatial data type.

geometry

sql_variant

cursor

all of the mentioned

#3. You can delete a row using SQL in a database with which of the following?

ADD

DELETE

REMOVE

FLUSH

#4. The SQL WHERE clause

limits the column data that are return

limits the row data are return

both a and b are correct

Neither a nor b are correct

#5. You want to track date and time of the last write access per row?

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 write a trigger that sets its value

Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions

#6. SQL can be used to

Crete database structures only

query database data only

modify database data only

All of the above can be done by SQL

#7. ntext datatype falls under which category?

Exact numerics

Character strings

Unicode character strings

None of the mentioned

#8. The Wildcard in a WHERE Clause is useful when

An exact match is necessary 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 not possible in a CREATE Statement

#9. _______ is not a category of SQL command

TCL

SCL

DCL

DDL

#10. Which of the following is large object data type?

varchar(max)

varbinary(max)

nvarchar(max)

image

#11. Which of the following statements is true concerning subqueries?

Involves the use of an inner and outer query

Cannot return the same result as a query that is not a subquery

Does not start with the word SELECT

All of the mentioned

#12. What does the abbreviation DBMS stand for?

Digital Base Mapping System

Data Borrowing and Movement Software

DataBase Management System

Database Manipulation Software

#13. What does the abbreviation RDBMS stand for?

Radio Digital Base Mapping System

Record Data Borrowing and Movement Software

Relational Database Management System

Relational Database Manipulation Software

#14. Which of the following data type is not present in SQL Server?

bit

boolean

hierarchical

geography

#15. What type of join is needed when you wish to include rows that do not have matching values?

Equal-join

Natural join

Outer join

All of the mentioned

#16. Exact numeric data type is ________

bigint

int

smallmoney

all of the mentioned

#17. The result of a SQL SELECT statement is a ____________

report

form

file

table

#18. ______ removes all rows from a table without logging the individual row deletions?

DELETE

REMOVE

DROP

TRUNCATE

#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 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 does not include the same number of columns

#20. The benefits of a standard relational language include which of the following?

Reduced training costs

Increased dependence on a single vendor

Applications are not need

All of the above

#21. Which of the following data type is not present in SQL Server?

bit

byte

hybrid

int

#22. Which of the following is valid SQL for an Index?

CREATE INDEX ID;

CHANGE INDEX ID;

ADD INDEX ID;

REMOVE INDEX ID;

#23. __________ is monetary data type in SQL server.

Smallmoney

sql_variant

Cursor

None of the mentioned

#24. The SQL WHERE Clause:

limits the column data that are returned.

limits the row data are returned

Both A and B are correct

Neither A nor B are correct

#25. Which is not a type of join in T-SQL?

Equi=join

Natural join

Outer join

Cartesian join

#26. Which of the following SQL Clauses is used to DELETE tuples from a database table?

DELETE

REMOVE

DROP

CLEAR

#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 Clause is used with the JOIN Clause only

The AS clause defines a search condition

All of the mentioned

#28. A column of type ________ may contain rows of different data types.

ntext

date

smallmoney

sql_variant

#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 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 outer query to determine the processing of an outer query

#30. Exact numeric data type is ____

float

bigint

smallmoney

all of the mentioned

#31. ________ is a spatial data type.

geometry

sql_variant

cursor

all of the mentioned

#32. Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

COUNT(*)

#33. SQL data definition commands make up a ______

DDL

DML

HTML

XML

#34. Data types in SQL Server are organized into how many categories?

#35. Which of the following are TCL Commands?

UPDATE and TRUNCATE

SELECT and INSERT

GRANT and REVOKE

ROLLBACK and SAVEPOINT

#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 manipulation Language

To define the data structures

All of the above

#37. A view is which of the following?

A virtual table that can be accessed via SQL commands

A virtual table that cannot be accessed via SQL Comands

A base table that can be accessed via SQL Commands

A base table that cannot be accessed via SQL commands

#38. Which of the datatype has storage size of 8 bytes?

timestamp

uniqueidentifier

real

smallmoney

#39. _________ is monetary data type in SQL Server.

Smallmoney

sql_variant

Cursor

None of the mentioned

#40. Select * from student join takes using

select*from student inner join

select*from student outer join

select*from student left outer join

All of the mentioned

#41. Which of the following is not the function of client?

Compile queries

Query optimization

Receive queries

Result formatting and presentation

#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

Both DELETE and TRUNCATE 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

#43. Select _________ from instructor where dept name “Comp-Sci”;

Mean(salary)

Avg(salary)

Sum(salary)

Count(salary)

#44. The SQL statement that queries or reads data from a table is _________

SELECT

READ

QUERY

None of the above is correct

#45. To sort the results of a query use:

SORT BY

GROUP BY

ORDER BY

None of the above is correct

#46. Which SQL keywords is used to retrieve a maximum value?

MOST

TOP

MAX

UPPER

#47. SQL can be used to

create database structures only

query database data only

modify database data only

All of the above can be done by SQL

#48. The wildcard in a WHERE clause is useful when?

An exact match is necessary 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 not possible in a CREATE statement

#49. The command to remove rows from a table customer is

REMOVE FROM CUSTOMER;

DROP FROM CUSTOMER;

DELETE FROM CUSTOMER WHERE;

UPDATE FROM CUSTOMER

#50. Which of the following is one of the basic approaches for joining tables?

Subqueries

Union Join

Natural join

All of the mentioned

#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 rows rather than columns

Acts like a WHERE clause but is used for columns rather than groups

Acts EXACTLY like a WHERE clause

#52. What type of join is needed when you wish to return rows that do have matching values?

Equi-join

Natural join

Outer join

All of the mentioned

#53. The SQL keywords ________ is used with wildcards.

LIKE only

IN only

NOT IN only

IN and NOT IN

#54. The SQL keywords _______ is used with Where condition.

Having

Group by

Order by

Select

#55. The SQL keywords _______ is used with Orderby.

Having

Join

Groupby

#56. The command to eliminate a table from a database is:

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

#57. A column of type ________ may contain rows of different data types.

ntext

date

smallmoney

int

#58. Which one of the following sorts rows in SQL?

SORT BY

ALIGN BY

ORDER BY

GROUP BY

#59. How many tables may be included with a join?

#60. Select ______ dept_name from instructor;

All

From

Distinct

Name

Finish