Business Logic comments is required for any SQL
True
False
MYISAM is the default mysql search engine?
The follwing command is used to take the mysql backup?
mysql
mysqlbackup
mysqldump
mydump
The syntax means that "mysqladmin -u root password NEWPASSWORD"
To update or change the root password
To setup root password for first time
A and B
None of the above
Which one is mysql configuraion file?
/etc/my.conf
/etc/my.cnf
/etc/mysq.conf
/etc/mysql.cnf
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?
SET NOCOUNT ON
SET ARITHABORT ON
SET NOCOUNT OFF
SET ARITHABORT OFF
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?
SET XACT_ABORT ON
SET XACT_ABORT OFF
When SET ANSI_NULLS is OFF then which one is true?
A SELECT statement that uses WHERE column_name = NULL returns no results
A SELECT statement that uses WHERE column_name = NULL returns the rows that have null values in column_name.
A SELECT statement that uses WHERE column_name = NULL will throw error.
A SELECT statement that uses WHERE column_name = NULL returns all the rows.
When SET QUOTED_IDENTIFIER is ON which will be true?
Identifiers can be delimited by double quotation marks, and literals can not be delimited by single quotation marks
Identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks
Identifiers can not be delimited by double quotation marks, and literals must be delimited by single quotation marks
Identifiers can not be delimited by double quotation marks, and literals can not be delimited by single quotation marks
Which one is true?
Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to OFF
setting ANSI_WARNINGS to ON will not affect ARITHABORT settings
Both are same
Setting ANSI_WARNINGS to ON implicitly sets ARITHABORT to ON