MySQL Functions
- What does mysql_init() return?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
When NULL is passed to mysql_init() it automatically allocates a MYSQL structure, initializes it, and returns a pointer to it. The MYSQL data type is a structure containing information about a connection.
- The header that should be included first is ________________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
The file ‘my_global.h’ takes care of including several other header files that are likely to be generally useful, like ‘stdio.h’. It also includes Windows compatibility information.
- The library file that contains various portability macros and definitions is ______________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
The ‘my_sys.h’ header file contains a variety of portability macros and definitions required for structures and functions. These structures and functions are used by the client library.
- The clause that is used to display information that matches a given pattern is _____________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
The ‘LIKE’ clause filters information that match a given pattern. ‘WHERE’ clause selects information that is specified by a condition. ‘IS’ is used to match the exact condition specified.
- The option that executes all SQL statements in a SQL script irrespective of the number of errors is _______________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
If SQL queries in a file are run using mysql in batch mode, mysql either quits after the first error. If the –force option is specified all the queries are executed indiscriminately.