Introduction To SQL MCQ

Test your knowledge with important Introduction To SQL MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Introduction To SQL MCQs at Bissoy

• If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
  ক

  True

  খ

  False
• To establish a range of values, can be used.
  ক

  True

  খ

  False
• The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
  ক

  True

  খ

  False
• SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
  ক

  True

  খ

  False
• Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
  ক

  True

  খ

  False
• The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
  ক

  True

  খ

  False
• The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
  ক

  True

  খ

  False
• The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
  ক

  True

  খ

  False
• The keyword LIKE can be used in a WHERE clause to refer to a range of values.
  ক

  True

  খ

  False
• Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
  ক

  True

  খ

  False
• Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
  ক

  True

  খ

  False
• ORDER BY can be combined with the SELECT statements.
  ক

  True

  খ

  False
• The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
  ক

  True

  খ

  False
• Indexes may be created or dropped at any time.
  ক

  True

  খ

  False
• The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
  ক

  True

  খ

  False
• Most companies keep at least two versions of any database they are using.
  ক

  True

  খ

  False
• SUM, AVG, MIN, and MAX can only be used with numeric columns.
  ক

  True

  খ

  False
• COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
  ক

  True

  খ

  False
• The result of every SQL query is a table.
  ক

  True

  খ

  False
• DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
  ক

  True

  খ

  False
• The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
  ক

  True

  খ

  False
• SQL is a data sublanguage.
  ক

  True

  খ

  False
• The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
  ক

  True

  খ

  False
• Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
  ক

  True

  খ

  False
• Indexes can usually be created for both primary and secondary keys.
  ক

  True

  খ

  False
• SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
  ক

  True

  খ

  False
• A dynamic view is one whose contents materialize when referenced.
  ক

  True

  খ

  False
• There is an equivalent join expression that can be substituted for all subquery expressions.
  ক

  True

  খ

  False
• The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
  ক

  True

  খ

  False
• A SELECT statement within another SELECT statement and enclosed in square brackets ([...
  ক

  ) is called a subquery.

  খ

  <p><span>A. True

  গ

  [</span> False