Mysql-quiz

Deprecated: round(): Passing null to parameter #1 ($num) of type int|float is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-content/plugins/quiz-maker/public/class-quiz-maker-public.php on line 1335

Deprecated: Implicit conversion from float 0.16666666666666666 to int loses precision in /home/u797631661/domains/codermantra.com/public_html/wp-content/plugins/quiz-maker/includes/class-quiz-maker-data.php on line 1008

Deprecated: Implicit conversion from float 0.16666666666666666 to int loses precision in /home/u797631661/domains/codermantra.com/public_html/wp-content/plugins/quiz-maker/includes/class-quiz-maker-data.php on line 1008

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/u797631661/domains/codermantra.com/public_html/wp-includes/formatting.php on line 449

0 votes, 0 avg

349

SQL Questions

1 / 15

1. A view can refer to multiple tables via __________

A. UNION

B. JOIN

C. GROUP

D. SELECT

2 / 15

2. SQL Views are also known as

A. Simple tables

B. Virtual tables

C. Complex tables

D. Actual Tables

3 / 15

3. Commands that come under TCL is/are -

A. COMMIT

B. ROLLBACK

C. SAVEPOINT

D. All of the above

4 / 15

In the following SQL query, what does “person” stands for? INSERT INTO person
(person_id, fname, lname)
VALUES (1,’S’,’P’);

A. Composite attributes

B. Multivalued attributes

C. Table name

D. None of the mentioned

5 / 15

5. Full form of DCL is -

A. Data Control Language

B. Data Commit Language

C. Data Common Language

D. Data Concatenate Language

6 / 15

6. Which of the following is not Constraint in SQL?

A. Primary Key

B. Not Null

C. Check

D. Union

7 / 15

7. Which keyword is used to delete all the rows from the table?

A. TRUNCATE

B. REMOVE

C. DELETE ALL

D. CLEAR

8 / 15

8. CROSS JOIN and JOIN are similar to __________

A. INNER JOIN

B. NATURAL JOIN

C. OUTER JOIN

D. CARTESIAN JOIN

9 / 15

9. What is xyz in the following SQL statement? DELETE FROM xyz WHERE abc = 5;

A. database name

B. column name

C. table name

D. row name

10 / 15

10. Command that comes under DCL is/are -

A. GRANT

B. REVOKE

C. Both A. and B.

D. None of the above

11 / 15

11. Select the correct syntax of SELECT TOP clause?

A. SELECT TOP name

B. SELECT TOP column

C. SELECT TOP FROM

D. SELECT TOP Number

12 / 15

12. SQL INSERT is used to insert a –

A. Single or Multiple record

B. Single or Multiple database

C. Single or Multiple table

D. None of the above

13 / 15

13. What is the difference between HAVING and WHERE clause?

A. HAVING clause is used in column operation whereas WHERE clause is used in row operation.

B. HAVING clause is post-filter whereas WHERE clause is pre-filter.

C. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.

D. All of the above

14 / 15

14. By default, sorting by ORDER BY clause is done in which order?

A. Ascending

B. Descending

15 / 15

15. Which operator is used to compare a value to a specified list of values?

A. ANY

B. BETWEEN

C. ALL

D. IN

Your score is

The average score is 58%

CoderMantra

Category

Archives

About CoderMantra

Latest Posts

Contact Us