1. In SQL, which command is used to SELECT only one copy of each set of duplicable rows
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;
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
9. Which of the following is the oldest database model?
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
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