Q.1
Which of the following is not a date function?
  • Month
  • Year
  • Now
  • Pow
Q.2
MySQL is
  • A Programming language
  • A technique for writing reliable programs
  • A Relational Database Management System
  • None of the Above
Q.3
Which type of database management system is MySQL?
  • Object-oriented
  • Hierarchical
  • Relational
  • Network
Q.4
What is the full form of SQL?
  • Structured Query Language
  • Structured Query List
  • Simple QueryLanguage
  • None of these
Q.5
What will be the output of the following query:Select round(59999.99,-2);
  • 59999
  • 59900
  • 60000
  • 59990
Q.6
Which of the following scripts will run successfully?
  • SELECT customer name FROM customers;
  • SELECT FROM `customers` 'customer name';
  • SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;
  • SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;
Q.7
Which of the following can add a row to a table?
  • Add
  • Insert
  • Update
  • Alter
Q.8
What will be returned by the given query? SELECT INSTR("INDIA", "DI");
  • 2
  • 3
  • -2
  • -3
Q.9
What will be printed by the given query? SELECT LENGTH("WINNER");
  • 7
  • 6
  • 8
  • 9
Q.10
What will be returned by the given query? SELECT round(153.2);
  • 153.6
  • 153.66
  • 153.67
  • 153.7
Q.11
Which of the following is not a numeric function?
  • MOD
  • SIGN
  • MID
  • POW
Q.12
With SQL, how do you select all the columns from a table named "Persons"?
  • SELECT * FROM Persons
  • SELECT Persons
  • SELECT [all] FROM Persons
  • SELECT *.Persons
Q.13
What will be returned by the given query? SELECT concat("It", "was", "ok");
  • "It was ok"
  • "Itwasok"
  • "Itwas ok"
  • "Tt wasok"
Q.14
Which of the following is not a relational operator?
  • &&
  • >=
  • !=
  • =
Q.15
In a LIKE clause, you can ask for any 6 letter value by writing
  • LIKE ______ (that's six underscore characters)
  • LIKE ...... (that's six dots)
  • LIKE .{6}
  • LIKE ??????
Q.16
Which of the following is not a valid aggregate function?
  • COUNT
  • MIN
  • COMPUTE
  • MAX
Q.17
Which of the following are valid column names?
  • Marks Eng
  • 66_Marks
  • Marks_Eng
  • #Eng_Marks
Q.18
What will be returned by the given query? SELECT month('2020-05-11');
  • 5
  • 11
  • May
  • November
Q.19
What will be returned by the given query? SELECT sign(26);
  • 1
  • -1
  • 0
  • none
Q.20
Which of the following is not a text function?
  • TRIM()
  • TRUNCATE()
  • LEFT()
  • MID()
0 h : 0 m : 1 s