16.
Which of the following best describes the scope of explicitly and implicitly set locks?
- A.Explicitly set locks may span several commands.
- B.Implicitly set locks may span several commands.
- C.Implicitly set locks will span only one statement or transaction.
- D.Explicitly set locks will span only one statement or transaction.
- Answer
- Report
Answer : [A,B,C]
17.
Which of the following statements is true for mysqldump?
- A.It can dump data only on remote servers.
- B.It can dump data only on the local server.
- C.It can dump data on both local and remote servers.
- D.None of the above
- Answer
- Report
Answer : [C]
18.
In a standard MySQL installation which of following files are stored below the data directory?
- A.Format files for all the tables
- B.Data and index files for MyISAM tables
- C.InnoDB tablespace files
- D.General server logs
- E.MySQL upgrade script files
- Answer
- Report
Answer : [A,B,C,D]
19.
Which of the following statements are true?
- A.InnoDB supports Foreign Keys.
- B.MyISAM supports Foreign Keys.
- C.InnoDB supports cascaded DELETE statements.
- D.MyISAM supports cascaded DELETE statements.
- E.InnoDB supports cascaded UPDATE statements.
- Answer
- Report
Answer : [A,C,E]
20.
Which of the following are some general properties of the mysqlimport client program?
- A.It loads data files into tables.
- B.It can load files only on the server host.
- C.It provides a command-line interface to the LOAD DATA INFILE.
- D.It can load files both on the client and server host.
- E.It bypasses the server and writes directly to the corresponding data files.
- Answer
- Report
Answer : [A,C,D]
|
|
||||||||||||||||||||||||||||
