adplus-dvertising
51. In the database directory of the database each view and trigger object is associated with how many files?
a. 0
b. 1
c. 2
d. 3
Discuss
Answer: (b).1

52. What is the maximum number of characters allowed for a database name to have?
a. 16
b. 32
c. 64
d. 128
Discuss
Answer: (c).64

53. The data directory subdirectory that corresponds to the nbdinfo database is ______________
a. mysql
b. performance_schema
c. sys
d. nbdinfo
Discuss
Answer: (b).performance_schema

54. mysql_next_result() does not return.
CLIENT_MULTI_STATEMENTS, mysql_set_server_option()
a. True
b. False
c. May be True or False
d. Can't say
Discuss
Answer: (b).False

55. The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________
a. –ensure
b. –force
c. –violent
d. –run
Discuss
Answer: (b).–force

56. What is the synonym for CHARACTER SET?
a. CSET
b. CHSET
c. CHARSET
d. CHCSET
Discuss
Answer: (c).CHARSET

57. What is the statement used to select a default database?
a. USE
b. CREATE
c. DROP
d. SCHEMA
Discuss
Answer: (a).USE

58. Symlink is an applicable relocation method for ______________
a. entire data directory
b. individual database tables
c. server PID file
d. log files
Discuss
Answer: (b).individual database tables

59. For which of these is the startup option best suited?
a. entire data directory
b. individual database tables
c. server PID file
d. individual database directories
Discuss
Answer: (c).server PID file

60. Before relocation of database, the server should be stopped if running.
a. True
b. False
c. May be True or False
d. Can't say
Discuss
Answer: (a).True

Page 6 of 18