Tag: databases

Questions Related to databases

Business Logic comments is required for any SQL

technology databases

  1. True

  2. False

Show answer
Correct Option: B

MYISAM is the default mysql search engine?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The follwing command is used to take the mysql backup?
technology databases

  1. mysql

  2. mysqlbackup

  3. mysqldump

  4. mydump

Show answer
Correct Option: C

The syntax means that "mysqladmin -u root password NEWPASSWORD"

technology databases

  1. To update or change the root password

  2. To setup root password for first time

  3. A and B

  4. None of the above

Show answer
Correct Option: B

Which one is mysql configuraion file?

technology databases

  1. /etc/my.conf

  2. /etc/my.cnf

  3. /etc/mysq.conf

  4. /etc/mysql.cnf

Show answer
Correct Option: B

When we use SELECT and DML statement in SQL, SQL server returns a message which specify the number of rows effected by these statements. How to disable this?
technology databases

  1. SET NOCOUNT ON

  2. SET ARITHABORT ON

  3. SET NOCOUNT OFF

  4. SET ARITHABORT OFF

Show answer
Correct Option: A

when you execute a T-SQL statement (INSERT, UPDATE, SELECT, DELETE) in a new query window, you see a message that says how many rows affected in the result window. How to disable this?
technology databases

  1. SET NOCOUNT OFF

  2. SET XACT_ABORT ON

  3. SET NOCOUNT ON

  4. SET XACT_ABORT OFF

Show answer
Correct Option: C

When SET ANSI_NULLS is OFF then which one is true?

technology databases

  1. A SELECT statement that uses WHERE column_name = NULL returns no results

  2. A SELECT statement that uses WHERE column_name = NULL returns the rows that have null values in column_name.

  3. A SELECT statement that uses WHERE column_name = NULL will throw error.

  4. A SELECT statement that uses WHERE column_name = NULL returns all the rows.

Show answer
Correct Option: B

When SET QUOTED_IDENTIFIER is ON which will be true?

technology databases

  1. Identifiers can be delimited by double quotation marks, and literals can not be delimited by single quotation marks

  2. Identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks

  3. Identifiers can not be delimited by double quotation marks, and literals must be delimited by single quotation marks

  4. Identifiers can not be delimited by double quotation marks, and literals can not be delimited by single quotation marks

Show answer
Correct Option: B

Which one is true?

technology databases

  1. Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to OFF

  2. setting ANSI_WARNINGS to ON will not affect ARITHABORT settings

  3. Both are same

  4. Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to ON

Show answer
Correct Option: D