Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

Business Logic comments is required for any SQL

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

MYISAM is the default mysql search engine?

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

The follwing command is used to take the mysql backup?

mysql
mysqlbackup
mysqldump
mydump

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which one is mysql configuraion file?

/etc/my.conf
/etc/my.cnf
/etc/mysq.conf
/etc/mysql.cnf

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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 NOCOUNT OFF
SET XACT_ABORT ON
SET NOCOUNT ON
SET XACT_ABORT OFF

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Tag: databases

Questions Related to databases