Jobs By Abekus

Which of the following is not a category of SQL commands?

1

DDL

2

TCL

3

DML

4

SCL

Solution:

What represents an ‘attribute’ in a relational database?

1

Column

2

Table

3

Row

4

Object

Solution:

Which keyword in the UPDATE statement is used to assign values to columns?

1

ASSIGN

2

MARK

3

SET

4

GET

Solution:

Which of the following characters is illegal in naming an unquoted identifier in SQL?

1

_

2

$

3

||

4

.

Solution:

Which statement is used to check how MySQL would execute a SELECT query?

1

TELL

2

SHOW

3

DISPLAY

4

EXPLAIN

Solution:

Which of these is a valid call to a function?

1

CONCAT( A , B )

2

CONCAT ( A , B )

3

CONCAT( “A” , “B” )

4

CONCAT ( “A” , “B” )

Solution:

Which of the following statements is/are correct?

1

NOT(true OR true) = false

2

NOT(false OR false)= true

3

NOT (true OR false)= false

4

All of the mentioned

Solution:

What is the purpose of using the ORDER BY clause in SQL?

1

It sorts the records in ascending order by default

2

The DESC keyword is used to sort the records in descending order

3

Both (a) and (b) are correct

4

None of the above

Solution:

Which statement is used to check the status of the event scheduler at runtime?

1

SHOW STATUS OF ‘event_scheduler’

2

SHOW VARIABLES OF ‘event_scheduler’

3

SHOW STATUS LIKE ‘event_scheduler’

4

SHOW VARIABLES LIKE ‘event_scheduler’

Solution:

There is one table named Customers.
.
and the client wants to retrieve the data (shown below) from the table Customers.
.
So, which query is correct to get the required output in MySql?

1

SELECT TOP 3 * FROM Customers;

2

SELECT * FROM Customers WHERE col_count=3;

3

SELECT * FROM Customers WHERE col_count<=3;

4

SELECT * FROM Customers LIMIT 3;

Mysql Questions Set 56:

Which of the following is not a category of SQL commands?

Solution:

What represents an ‘attribute’ in a relational database?

Solution:

Which keyword in the UPDATE statement is used to assign values to columns?

Solution:

Which of the following characters is illegal in naming an unquoted identifier in SQL?

Solution:

Which statement is used to check how MySQL would execute a SELECT query?

Solution:

Which of these is a valid call to a function?

Solution:

Which of the following statements is/are correct?

Solution:

What is the purpose of using the ORDER BY clause in SQL?

Solution:

Which statement is used to check the status of the event scheduler at runtime?

Solution:

There is one table named Customers.
.
and the client wants to retrieve the data (shown below) from the table Customers.
.
So, which query is correct to get the required output in MySql?

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 56:

Which of the following is not a category of SQL commands?

Solution:

What represents an ‘attribute’ in a relational database?

Solution:

Which keyword in the UPDATE statement is used to assign values to columns?

Solution:

Which of the following characters is illegal in naming an unquoted identifier in SQL?

Solution:

Which statement is used to check how MySQL would execute a SELECT query?

Solution:

Which of these is a valid call to a function?

Solution:

Which of the following statements is/are correct?

Solution:

What is the purpose of using the ORDER BY clause in SQL?

Solution:

Which statement is used to check the status of the event scheduler at runtime?

Solution:

There is one table named Customers..and the client wants to retrieve the data (shown below) from the table Customers..So, which query is correct to get the required output in MySql?

Solution:

Related Question Sets:

Related Topics:

There is one table named Customers.
.
and the client wants to retrieve the data (shown below) from the table Customers.
.
So, which query is correct to get the required output in MySql?