MySQL interview questions part 34
MySQL interview questions part 34
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. In SQL, which command is used to SELECT only one copy of each set of duplicable rows
Correct Answer is : NDB
2. A command that lets you change one or more fields in a record is
Correct Answer is : STATISTICS
3. Which of the SQL statements is correct?
Correct Answer is : ENGINES, PLUGINS
4. The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;
Correct Answer is : TRUE
5. Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE. The SQL statement SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE); prints
Correct Answer is : PROCESSLIST
6. Find the temperature in increasing order of all cities
Correct Answer is : mysqlshow
7. Let the statement : SELECT column1 FROM myTable; return 10 rows. The statement : SELECT ALL column1 FROM myTable; will return
Correct Answer is : –keys
8. A collection of data designed to be used by different people is called a/an
Correct Answer is : ->>
9. Which of the following is the oldest database model?
Correct Answer is : >>
10. Which of the following is the process of selecting the data storage and data access characteristics of the database?
Correct Answer is : SOUNDS LIKE
11. The relationship between DEPARTMENT and EMPLOYEE is a
Correct Answer is : TRUE
12. If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
Correct Answer is : Rich Text Format
13. When an entity instance must be a member of only one sub-type, it is which of the following?
Correct Answer is : fetchrow_array()
14. A supertype/subtype hierarchy is which of the following?
Correct Answer is : fetchrow_hashref()
15. Use of a supertype/subtype relationship is necessary when which of the following exists?
Correct Answer is : column name
16. Which of the following is not one of the three ways to classify an action assertion?
Correct Answer is : fetchrow_arrayref()
17. Which of the following advanced OOP features is/are not supported by PHP? i) Method overloading ii) Multiple Inheritance iii) Namespaces iv) Object Cloning
Correct Answer is : 3.4E+38
18. Which version of PHP introduced the advanced concepts of OOP?
Correct Answer is : CHECK TABLE
19. Which one of the following is the right way to clone an object?
Correct Answer is : ANALYZE TABLE
20. Which of the following is/are true for an abstract class? i) A class is declared abstract by prefacing the definition with the word abstract. ii) A class is declare abstract by using the keyword implements. iii) It is a class that really isn’t supposed to ever be instantiated but instead serves as a base class. iv) Attempting to instantiate an abstract class results in an error.
Correct Answer is : Msg_txt
