Start learning →

M.Sc Computer Science Structured Query Language — practice questions

Explore 30 free Structured Query Language questions in M.Sc Computer Science Computer Science. Open each question or exercise to read its content, reference answers and available explanation.

Practise Structured Query Language with Quill →

Structured Query Language questions and exercises with answers

Showing questions 1–30 of 30.

Every SQL statement should always end with a:Read the answer and worked solution →SQL statements are described as not being:Read the answer and worked solution →Which clause is used to enforce conditions in an SQL query?Read the answer and worked solution →Which statement is used to modify existing data in a table?Read the answer and worked solution →Which clause displays results in ascending or descending order?Read the answer and worked solution →Which clause eliminates repetition so values appear only once?Read the answer and worked solution →MySQL is described as which kind of RDBMS software?Read the answer and worked solution →Statements for defining, modifying and deleting schemas are part of:Read the answer and worked solution →Insert, select, update and delete statements belong to:Read the answer and worked solution →Which statement changes the structure of a table, such as adding a column?Read the answer and worked solution →Restrictions on the data values an attribute can have are called:Read the answer and worked solution →Which constraint ensures a column cannot hold missing or unknown values?Read the answer and worked solution →Which operator defines a range of values inclusive of the boundary values?Read the answer and worked solution →Which operator selects values matching any value in a given list?Read the answer and worked solution →CHAR(n) specifies character data where n can be any value from 0 to:Read the answer and worked solution →Which function groups rows containing the same values in a column?Read the answer and worked solution →COUNT, MAX, MIN, AVG and SUM are examples of which functions?Read the answer and worked solution →An operation combining rows from two tables on a common field is a:Read the answer and worked solution →Single row functions are also known as:Read the answer and worked solution →By default, ORDER BY displays records in which order?Read the answer and worked solution →Using DROP to remove a database will also remove all its:Read the answer and worked solution →By default, which attribute cannot take NULL values?Read the answer and worked solution →Is it DDL or DMLRead the answer and worked solution →Match the SQL clauseRead the answer and worked solution →Order the steps to build a tableRead the answer and worked solution →True or false about SQLRead the answer and worked solution →Sort the SQL functionsRead the answer and worked solution →Complete the SQL rulesRead the answer and worked solution →Stack the correct SQL answersRead the answer and worked solution →SQL bingoRead the answer and worked solution →

Worked practice questions

Every SQL statement should always end with a:

  1. Semicolon
  2. Semitone
  3. Sentence
  4. Sequence
Show answer and solution

Correct answer: A. Semicolon

1. An SQL client needs to know where a statement stops. 2. One punctuation mark marks that end. 3. Always end SQL statements with a semicolon. 4. So the answer is a semicolon. _Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_

Open this question →

SQL statements are described as not being:

  1. Char sensitive
  2. Case sensitive
  3. Cost sensitive
  4. Cache sensitive
Show answer and solution

Correct answer: B. Case sensitive

1. SQL uses descriptive English words. 2. Whether they are typed in capitals does not matter. 3. SQL is easy to learn as the statements are not case sensitive. 4. The names salary and SALARY are the same to SQL. _Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_

Open this question →

Which clause is used to enforce conditions in an SQL query?

  1. WHERE
  2. WHILE
  3. WHICH
  4. WHOLE
Show answer and solution

Correct answer: A. WHERE

1. A query often has to be restricted to certain rows. 2. One clause carries that restriction. 3. The WHERE clause in an SQL query is used to enforce conditions. 4. So the answer is WHERE. _Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_

Open this question →

How to practise

  1. Choose a Structured Query Language question and try to work out your answer.
  2. Open the question to check the correct answer and read its worked solution.
  3. Continue in the app for bite-sized lessons, explanations and review with Quill. You can start without creating an account.

More Computer Science topics

Sorting and SearchingDatabase ConceptsStacks and Queues