MySQL interview questions part 28
MySQL interview questions part 28
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which of the following statements concerning business rules is true?
Correct Answer is : Data will be truncated
2. In order to use a record management system
Correct Answer is : Mediumtext
3. In an E-R diagram an entity set is represent by a
Correct Answer is : Longtext
4. A relational database developer refers to a record as
Correct Answer is : Both Whole and Natural numbers
5. The relational model feature is that there
Correct Answer is : Int
6. E-R model uses this symbol to represent weak entity set ?
Correct Answer is : Total of four digits, two to the left of decimal and two to the right of decimal
7. Which of the following is record based logical model?
Correct Answer is : Both 24.33 and 124.4
8. A ___________ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
Correct Answer is : 12345
9. Identify the criteria for designing database from the point of view of user
Correct Answer is : Total of 1 digit
10. The relational model is based on the concept that data is organized and stored in two-dimensional tables called _____________
Correct Answer is : Temporal data type
11. An aggregation association is drawn using which symbol:
Correct Answer is : YYYY-MM-DD
12. An n-array relationship is drawn using which symbol:
Correct Answer is : YYYY-MM-DD HH:MI:SS
13. A BI reporting system does not _____________
Correct Answer is : YYYY-MM-DD HH:MI:SS
14. The “curse of dimensionality” relates to which problem of using operational data for BI reporting?
Correct Answer is : YYYY
15. A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
Correct Answer is : HHH:MI:SS
16. Business Intelligence (BI) reporting systems cannot do which of the following operations?
Correct Answer is : Yes
17. Which of the following is not a component of a data warehouse?
Correct Answer is : 123.44
18. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Correct Answer is : FLOAT
19. The wildcard in a WHERE clause is useful when?
Correct Answer is : BINARY
20. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;
Correct Answer is : VARCHAR
