Q.1
SQL can be used to:
  • Create database structures only.
  • Query database data only.
  • Modify database data only.
  • All of the above can be done by SQL.
Q.2
What does SQL stand for?
  • Structured Query Language
  • Structured Question Language
  • Strong Question Language
  • None of the above
Q.3
Function TRIM() can remove leading and trailing text from a string
  • True
  • False
Q.4
The functions that work with one row at a time are called __________________ functions
  • Row functions
  • Single Row Functions
  • Scalar functions
Q.5
Date() and Day() return the same thing
  • True
  • False
Q.6
Which of the following functions returns the substring from a given string?
  • MID
  • INSTR
  • SUBSTR
  • MID & SUBSTR
Q.7
What SQL clause is used to restrict the rows returned by a query?
  • AND
  • WHERE
  • HAVING
  • FROM
Q.8
Which will input data into a table?
  • INSERT INTO table(name, height, weight) VALUES('strand', '6ft 2in', '165')
  • INPUT INTO table(name, height, weight) VALUES('strand', '6ft 2in', '165')
  • INSERT INTO table CATEGORIES(name, height, weight) VALUES('strand', '6ft 2in', '165')
  • INSERT INTO table CATEGORIES(name, height, weight) ('strand', '6ft 2in', '165')
Q.9
Which statement can be used to select the database?
  • $mysqli=select_db('databasename');
  • mysqli=select_db('databasename');
  • mysqli->select_db('databasename');
  • $mysqli->select_db('databasename');
Q.10
USE keyword is used to select a ____________________
  • Table
  • Column
  • Database
  • None of the above
0 h : 0 m : 1 s