Tag: sql

Questions Related to sql

The Order Of shorting Can be Change by Which SQL command??

sql

  1. Order From

  2. Order On

  3. Order By

  4. Order In

Show answer
Correct Option: C

Sql Command use to Avoid selection Of duplicate Rows?

sql

  1. Distinct

  2. Unique

  3. Exclusive

  4. Discrete

Show answer
Correct Option: A

Which of following denotes a single value function used in SQL?

sql

  1. COUNT()

  2. SQRT()

  3. AVG()

  4. ALL OF THESE

Show answer
Correct Option: B

Which of following is used in SQL command to Comment Multiple Lines?
sql

  1. /**/

  2. REM

Show answer
Correct Option: A

Which one of the following comes under Transaction controlled Language ?
sql

  1. grant

  2. revoke

  3. rollback

  4. none

Show answer
Correct Option: C

Which of the following are cursor attributes ?

sql

  1. %ISOPEN

  2. %NOTFOUND

  3. both a and b

  4. %CURSORSOPEN

Show answer
Correct Option: C

Which one of the following is false about cursor?
sql

  1. Cursors can hold multiple records at the same time

  2. Cursors are a private SQL area network

  3. Cursors are used to retrieve and manipulate data

  4. Cursor is not a pointer to a memory location

Show answer
Correct Option: D

Which of the following do you need to consider when you make a table in SQL?
sql

  1. Data types

  2. Primary keys

  3. Default values

  4. All of the above.

Show answer
Correct Option: D

SQL query and modification commands make up a(n)
sql

  1. DDL

  2. DML

  3. HTML

  4. XML

Show answer
Correct Option: B
Explanation:

To solve this question, the user needs to have knowledge of SQL and its different components. In particular, the user needs to understand the purpose of SQL query and modification commands.

Now, let's go through each option and explain why it is right or wrong:

A. DDL: This option is incorrect. DDL stands for Data Definition Language and is used to define and manage the structure of a database. DDL commands include CREATE, ALTER, and DROP. While DDL commands are part of SQL, they are not specifically related to SQL query and modification commands.

B. DML: This option is correct. DML stands for Data Manipulation Language and is used to retrieve, insert, update, and delete data in a database. DML commands include SELECT, INSERT, UPDATE, and DELETE, which are commonly used in SQL queries and modifications.

C. HTML: This option is incorrect. HTML stands for Hypertext Markup Language and is used for creating the structure and presentation of web pages. HTML is not related to SQL query and modification commands.

D. XML: This option is incorrect. XML stands for Extensible Markup Language and is used for storing and transporting data. XML is not directly related to SQL query and modification commands.

The Answer is: B. DML

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s
sql

  1. LIKE only.

  2. IN only.

  3. NOT IN only.

  4. Both IN and NOT IN.

Show answer
Correct Option: D