SQL Questions

March 14, 2023

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

0 votes, 0 avg

354

SQL Questions

1 / 15

1. Types of SQL Commands are –

A. DDL

B. DML

C. DCL

D. All of the above

2 / 15

2. What is the keyword of the Ascending and Descending?

A. ASCE, DESC

B. ASC, DES

C. ASCE, DES

D. ASC, DESC

3 / 15

3. What default value gets stored in columns of the table?

A. NULL

B. 1

C. -1

D. o

4 / 15

4. What is the role of “CONSTRAINS” in defining a table in Mysql?

A. Declaring primary key

B. Declaring Foreign Key

C. Restrictions on columns

D. All of the mentioned

5 / 15

5. SQL DELETE can be used to delete,

A. Rows

B. Database

C. View

D. All of the above

6 / 15

6. Commands that come under TCL is/are –

A. COMMIT

B. ROLLBACK

C. SAVEPOINT

D. All of the above

7 / 15

7. In order to insert a row directly in the table, which command is used?

A. INSERT IN

B. INSERT INSIDE

C. INSERT UNDER

D. INSERT INTO

8 / 15

8. Commands that comes under DDL is/are –

A. CREATE

B. DROP

C. TRUNCATE

D. All of the above

9 / 15

9. UPDATE statement is a DML statement. What does DML stand for?

A. Data Manipulation Language

B. Data Manipulation Level

C. Data Markup Language

D. Data Markup Level

10 / 15

10. Which one is not the OPTIONAL Clause in SELECT statement?

A. WHERE

B. ORDER BY

C. HAVE

D. HAVING

11 / 15

11. . A View can be used to select a subset of the table columns.

A. true

B. false

12 / 15

12. 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

13 / 15

13. CREATE VIEW xyz (abc) AS SELECT a FROM t;

A. row name

B. column name

C. view

D. database

14 / 15

14. What is joining a table to itself called?

A. COMPLETE

B. SELF

C. OBSOLETE

D. CROSS

15 / 15

15. Which statement is TRUE about the WHERE Clause?

A. In order to retrieve rows, WHERE Clause is used.

B. In order to group the rows, WHERE Clause is used.

C. In order to select the defined groups, WHERE Clause is used.

D. In order to return the rows, WHERE Clause is used.

Your score is

The average score is 58%

Questions, Quiz

CoderMantra

Questions

About CoderMantra

Latest Posts

Contact Us