MySQL interview questions part 32
MySQL interview questions part 32
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Examine the following settings for the initialization parameters: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M SGA_TARGET=300M PGA_AGGREGATE_TARGET=70M Which statement is true about the memory management for the newly started database instance?
Correct Answer is : DIV
2. A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.
Correct Answer is : unknown value
3. The ___________ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.
Correct Answer is : unknown value
4. A table is in 3NF if it is in 2NF and if it has no ____________
Correct Answer is :
5. Every constraint on the table is a logical consequence of the table’s
Correct Answer is :
6. A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.
Correct Answer is : ORDER BY
7. In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.
Correct Answer is : ORDER BY
8. Anomalies are avoided by splitting the offending relation into multiple relations, is also known as
Correct Answer is : FALSE
9. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
Correct Answer is : 2
10. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Correct Answer is : -p
11. Which of the following is not a restriction for a table to be a relation?
Correct Answer is : cobra.snake.net
12. What is the use of Library cache?
Correct Answer is : user name
13. Which processes is an instance made of Oracle?
Correct Answer is : date and time
14. Which of the following segment is destroyed when the SQL statement is finished?
Correct Answer is : USE sampledb
15. What is the use of an index?
Correct Answer is : table name and column specs
16. Which of the following components comprise an Oracle architecture?
Correct Answer is : DESCRIBE tbl_name
17. What is the use of extent in Oracle?
Correct Answer is : TRUE
18. Which area of PGA stores binding variables and run-time buffers information?
Correct Answer is : All of the mentioned
19. The ____________ contains a set of tables and views that Oracle uses as a reference to the database.
Correct Answer is : TRUE
20. In Oracle, which of below are types of segments?
Correct Answer is : FALSE
