Structured Query Language MCQ

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

• Let the statement : SELECT column1 FROM myTable; return 10 rows. The statement : SELECT ALL column1 FROM myTable; will return
  ক

  less than 10 rows

  খ

  more than 10 rows

  গ

  exactly 10 rows

  ঘ

  none of the Mentioned
• Find the temperature in increasing order of all cities
  ক

  SELECT city FROM weather ORDER BY temperature;

  খ

  SELECT city, temperature FROM weather;

  গ

  SELECT city, temperature FROM weather ORDER BY temperature;

  ঘ

  SELECT city, temperature FROM weather ORDER BY city;
• Which of the SQL statements is correct?
  ক

  SELECT Username AND Password FROM Users

  খ

  SELECT Username, Password FROM Users

  গ

  SELECT Username, Password WHERE Username = ‘user1’

  ঘ

  None of the Mentioned
• A command that lets you change one or more fields in a record is
  ক

  Insert

  খ

  Modify

  গ

  Look-up

  ঘ

  All of the Mentioned
• In SQL, which command is used to SELECT only one copy of each set of duplicable rows
  ক

  SELECT DISTINCT

  খ

  SELECT UNIQUE

  গ

  SELECT DIFFERENT

  ঘ

  All of the Mentioned
• Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
  ক

  Data Definition Language(DDL)

  খ

  Data Manipulation Language(DML)

  গ

  DDL and DML

  ঘ

  None of the Mentioned
• What is the full form of SQL?
  ক

  Structured Query Language

  খ

  Structured Query List

  গ

  Simple Query Language

  ঘ

  None of the Mentioned