Data Types

Data Types

Easy Questions

MYSQL

MySQL Subquery
MySQL Character Set
MySQL Views
Mysql Basic
Mysql Setup
Mysql Foreign Keys
Mysql Query Optimization
Interacting With MySQL
Server SQL Mode
MySQL Events
MySQL UNION
MySQL Full-Text Search
MySQL Command Line Tool
Mysql Error handling
Mysql Compound Statements
MySQL Stored Procedures
MySQL Stored Functions
MySQL Triggers
MySQL Connectors and APIs
Connection
MySQL Functions
MySQL Operators
MySQL Table Operations
MySQL Internationalization and Localization
MySQL Database Operations
MySQL Access Control and Security
MySQL Type Conversion in Expression Evaluation
MySQL Scheduling and Locking Issues
MySQL ORDER BY
MySQL HAVING
MySQL GROUP BY
MySQL Optimization
Managing MySQL Users
MySQL Programs
Access Control for MySQL Stored Programs and Views
Create Database
Drop Database
Select Database
Data Types
Create Tables
Insert Query
Select Query
Mysql miscellaneous
Where Clause
Update Query
Delete Query
Sorting Results
Using Join
NULL Values
Transactions
Alter Command
Indexes
Database Info
Using Sequences
  1. SPATIAL indexes cannot be created on NOT NULL spatial columns.










  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The ‘SPATIAL’ indexes can be created on ‘NOT NULL’ spatial columns. Therefore, if it is planned to index the column, it would need to be declared as NOT NULL. This type can be used in many ways.

  1. Which type can store a collection of objects of any type?










  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    ‘GEOMETRYCOLLECTION’ can store a collection of objects of any type. The other collection types like ‘MULTIPOINT’, ‘MULTILINESTRING’, ‘MULTIPOLYGON’ and ‘GEOMETRYCOLLECTION’ restrict collection members to those having a particular geometry type.

  1. Which classes does spatial data types in MySQL correspond to?










  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    MySQL has spatial data types that correspond to OpenGIS classes. Some of them that hold single geometry values are ‘GEOMETRY’, ‘POINT’, ‘LINESTRING’ and ‘POLYGON’. Some can hold collection of values.

  1. Which is the header that should be included first?










  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    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.

  1. Which is the library file that contains various portability macros and definitions?










  1. 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.