6.
Which of the following statements are true for innoDB ?
- A.innoDB is enabled by default
- B.Tablespace and logfiles have to be configured explicitly to be created
- C.InnoDB is not enabled by default
- D.Tablespace and log files will be created even if not configured explicitly
- Answer
- Report
Answer : [A,D]
7.
When you acquire an advisory lock using GET_LOCK(), the lock is released if
- A.You issue another GET_LOCK() statement
- B.You issue a RELEASE_LOCK() Statement
- C.Your connection to the server terminates
- D.None of the above
- Answer
- Report
Answer : [A,B,C]
8.
Another user has gotten a lock using GET_lOCK. You inquire on the status of the lock by using.
- A.RELEASE_LOCK
- B.IS_FREE_LOCK
- C.IS_USED_LOCK
- D.Another GET_LOCK
- E.LOCK TABLES
- Answer
- Report
Answer : [B,C]
9.
Which of the following actions are performed during an RPM installation of the MYSQL server package ?
- A.Setup a mysql user
- B.Setup a mysql group
- C.Initialize the data directory
- D.Setup passwords for all default accounts
- Answer
- Report
Answer : [A,B,C]
10.
Which of the following can be influenced by the choice of character set ?
- A.Disk usage when storing data
- B.Syntax when writing queries involving JOINs
- C.The time taken to read & write table rows on disk
- D.Memory usage
- Answer
- Report
Answer : [A,C,D]
|
|
||||||||||||||||||||||||||||
