91.
Assume you compile MySQL from source and invoke configure with the following options. --
withcharset= latin1 --with-extra-charsets=utf8,ucs2 Compared to a standard binary installation that
contains many more character sets, which of the following statements is/are true?
- A.The compiled version will use less disk space, because only a few character sets will be installed on disk.
- B.The compiled version will use less memory, because only a few character sets will be loaded by the server.
- C.The compiled version will use less file handles, because only a few files need to be opened when the server is started.
- Answer
- Report
Answer : [A, B]
92.
Which of the following are true for how BTREE and HASH index types should be used for
MEMORY tables?
- A.HASH index types are only for use with equalitycomparisions such as those using the = and <=> operators.
- B.BTREE index types are preferable for use with comparisons that do not just use equality operators such as = and <=>
- C.BTREE index types are only for use with equality comparisons such as those using the = and <=> operators.
- D.HASH index types are preferable for use with comparisons that do not just use equality operators such as = and <=>
- Answer
- Report
Answer : [A, B]
93.
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.
- Answer
- Report
Answer : [A, C, D]
94.
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.
- F.MyISAM supports cascaded UPDATE statements.
- Answer
- Report
Answer : [A, C, E]
95.
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 forMyISAM tables
- C.InnoDB tablespace files
- D.General server logs
- E.MySQL upgrade script files
- Answer
- Report
Answer : [A, B, C, D]
|
|
||||||||||||||||||||||||||||
