Q.1
What is a field?
  • A collection of information
  • A single item of information
  • A list of information
  • A group of records
Q.2
Which SQL function is used to count the number of rows in a SQL query?
  • COUNT()
  • NUMBER()
  • SUM()
  • COUNT(*)
Q.3
What does the ALTER TABLE clause do?
  • The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
  • The SQL ALTER TABLE clause is used to insert data into database table
  • THE SQL ALTER TABLE deletes data from database table
  • The SQL ALTER TABLE clause is used to delete a database table
Q.4
What do the letters in CRUD stand for?
  • Create Read Update Delete
  • Craft Run Upload Database
  • Create Run Unrun Data
  • Crunch Read Uptime Downtime
Q.5
A UNION query is which of the following?
  • Combines the output from multiple queries and does not include the same number of columns.
  • Combines the output from multiple queries and must include the same number of columns.
  • Combines the output from no more than two queries and does not include the same number of columns.
  • Combines the output from no more than two queries and must include the same number of columns.
Q.6
SQL views can be used to hide?
  • Complicated SQL syntax
  • Rows
  • Columns
  • All of the above
Q.7
The SQL SELECT statement is capable of
  • Projection
  • Selection
  • Protection & Security
  • Both A & B
Q.8
Embedded SQL is which of the following?
  • The process of making an application capable of generating specific SQL code on the fly.
  • Hard-coded SQL statements in a trigger.
  • Hard-coded SQL statements in a program language such as Java.
  • Hard-coded SQL statements in a procedure.
Q.9
The arranging of data in a logical sequence is called
  • Summarizing
  • Classifying
  • Sorting
  • Rearranging
Q.10
Which SQL statement is used to insert new data in a database?
  • Insert Into
  • Add New
  • Insert Record
  • Add Record
Q.11
A database is used to
  • store data
  • modify data
  • extract data
  • All of the above
Q.12
Which of the following statements is true concerning subqueries?
  • Does not start with the word SELECT.
  • Involves the use of an inner and outer query.
  • Cannot return the same result as a query that is not a subquery.
  • All of the above
Q.13
AND, OR and NOT are examples of
  • Clauses
  • Boolean operators
  • Conjuctive operators
  • Exclusive operators
Q.14
In sql the spaces at the end of the string are removed by
  • LTrim
  • Upper
  • Trim
  • Lower
Q.15
What is the correct order of clauses in a SQL statement?
  • SELECT, FROM, ORDER BY, WHERE
  • SELECT, FROM, WHERE, ORDER BY
  • SELECT, WHERE, FROM, ORDER BY
  • WHERE, FROM, SELECT, ORDER BY
Q.16
What is Insert command in SQL?
  • The INSERT INTO statement is used to insert new records in a table.
  • The INSERT INTO statement is used to insert new column in a table.
Q.17
How would you display Chairs in the Items table that have a Price greater than £50.
  • SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50
  • SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100
  • SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50
  • SELECT * FROM Items WHERE Price > 50
Q.18
The UPDATE SQL clause can _____________
  • update only one row at a time
  • update more than one row at a time
  • delete more than one row at a time
  • delete only one row at a time
Q.19
SQL query to 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
Q.20
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
  • SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70
  • SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
  • SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
  • SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70
0 h : 0 m : 1 s