MySQL interview questions part 33
MySQL interview questions part 33
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. The redo log buffer and Shared pool are elements of?
Correct Answer is : IS NULL
2. What does DLL stand for ?
Correct Answer is : NOT NULL
3. POST-BLOCK trigger is also a ?
Correct Answer is : Only those columns whose emp_id is NULL
4. The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________
Correct Answer is : Only those columns whose emp_id is not NULL
5. In Oracle, which of the following package procedure is UNRESTRICTED ?
Correct Answer is : No output
6. What is SQL * FORMS ?
Correct Answer is : Only those names whose emp_id is not equal to 6
7. What is the result of the following ‘PAN’NULL’KAJ’?
Correct Answer is : Only those names whose emp_id is not equal to 6 or emp_id with NULL values
8. Below is the EMP table EMPNO ENAME SALARY A29 PANKAJ 10000 A23 SAHIL 20000 A48 ABHYUDAY A83 KRISHNA 30000 Select count(SALARY) from EMP; will result in
Correct Answer is : REAL
9. Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
Correct Answer is : 0
10. Where is data dictionary kept?
Correct Answer is : STOP SLAVE
11. Which schema object instructs Oracle to connect to remotely access an object of a database?
Correct Answer is : -128
12. Which of the following object types below cannot be replicated?
Correct Answer is : Access Control Lists
13. How we can force a log switch?
Correct Answer is : TRUE
14. In the below given query, which expression is evaluated first? SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory
Correct Answer is : FALSE
15. The ORDER BY clause can only be used in ___________
Correct Answer is : $a[0].
16. Which of the following rule below are categories of index?
Correct Answer is : TRUE
17. What is the purpose of SMON (System Monitor Process) background process?
Correct Answer is : ->
18. Recycle bin can be turned on or off this. This parameter is stored in which of the below file?
Correct Answer is : metadata
19. When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called
Correct Answer is : SHOW TABLE STATUS
20. What is the full form of SQL?
Correct Answer is : TRUE
