‘2341’ is a ____________
1.integer
2.floating point
3.hexadecimal
4.string
“INSERT” is same as “UPDATE”?
1.NO
2.YES
3.May be
4.None of the mentioned
Character data can be stored as ______________
1.Fixed length string
2.Variable length string
3.Either Fixed or Variable length string
4.None of the mentioned
If a string is to be converted to a number, it is converted into a _____________
1.double precision floating point
2.single precision floating point
3.decimal integer
4.hexadecimal integer
If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________
1.identifier-quoting character
2.string-quoting character
3.hexadecimal
4.string
In the following SQL query, what does “person” stands for?
1.Composite attributes
2.Multivalued attributes
3.Table name
4.None of the mentioned
Is it necessary to insert the value in each column of the table?
1.Yes
2.No
3.Depends on the server
4.Depends on the usage of the table
Mysql command line tool is used to show “how many rows are returned and how long SQL command took to execute”.
1.TRUE
2.FALSE
3.Undetermined
4.Depend
Numbers prefixed with ‘0x’ are in base __________
1.8
2.16
3.32
4.64
The BIGINT precision is of bit _________
1.32
2.64
3.128
4.16
The bit-field values are prefixed with __________
1.0b
2.0bit
3.bit-
4.‘bit’
The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________
1.32
2.64
3.65
4.16
The escape sequence for carriage return is ___________
1.‘c’
2.‘ ’
3.‘’
4.‘z’
The mantissa in -1.58E5 is __________
1.-1.58
2.1.58
3.E
4.5
The maximum length of the char columns is ____________
1.255 bytes
2.65, 535 bytes
3.256 bytes
4.None of the mentioned
The number of legal hexadecimal values among 0x0a, 0x0A, 0X0a and 0X0A is _________
1.1
2.2
3.3
4.4
To measure the length of a string in bytes, the operator used is __________
1.CHAR_LENGTH()
2.LENGTH()
3.LEN()
4.SIZE()
What default value gets stored in columns of the table?
1.NULL
2.0
3.1
4.-1
What is the default value of column?
1.NULL
2.0
3.-1
4.Undefined
What is the meaning of “REFERENCES” in table definition?
1.Primary key
2.NULL
3.Foreign Key
4.A ”foreign Key” belong to this particular table
What is the role of “CONSTRAINS” in defining a table in Mysql?
1.Declaring primary key
2.Declaring Foreign Key
3.Restrictions on columns
4.All of the mentioned
What is used to produce a new string from an old string in the desired character set?
1.Introducers
2.CONVERT()
3.CONVERTER()
4.CONVERTS()
Which among the following are the correct definitions for “NULL” in Mysql?
1.Absence of value
2.Unknown
3.Empty set
4.All of the mentioned
Which among the following is the correct syntax for creating table?
1.CREATE TABLE name;
2.CREATE name;
3.CREATE TABLE
4.All of the mentioned
Which among the following is the correct syntax for defining “Constraint Check” in Mysql?
1.gender char(1) check( gender IN (‘M’, ‘F’)),
2.gender char (1) check,
3.gender char (1) check ( gender ),
4.none of the mentioned
Which among the following is the correct syntax for defining “ENUM” in Mysql?
1.gender ENUM (‘M’, ‘F’),
2.gender ENUM,
3.gender ENUM ( ),
4.none of the mentioned
Which among the following is the correct syntax for modifying the definition of an existing table?
1.ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;
2.ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT;
3.ALTER TABLE person MODIFY person_id ;
4.ALTER TABLE person
Which among the following is the correct syntax for showing all tables in the database?
1.SHOWS TABLES
2.SHOW TABLE
3.SHOW
4.SHOWS TABLES;
Which authentications are required for login into Mysql command line tool?
1.Username
2.Password
3.Only Username
4.Both Username and Password
Which character set variable indicates the character set used for storing identifiers?
1.character_set_system
2.character_set_server
3.collation_server
4.character_set_database
Which clause is used to rename the existing table?
1.RENAME
2.MODIFY
3.ALTER
4.None of the mentioned
Which Clause is used to select a particular row from the set of row in an existing table?
1.WHERE
2.FROM
3.ALTER
4.None of the mentioned
Which Clause is used to select a particular table in Mysql?
1.WHERE
2.SELECT
3.FROM
4.ALTER
Which Clause is used to sort the stored data in alphabetical order?
1.ORDER by CLAUSE
2.MODIFY
3.ALTER
4.UPDATE
Which command is used for showing current date and time in Mysql command line tool?
1.select now()
2.SELECT now();
3.SELECT now()
4.None of the mentioned
Which command is used for the table definition in Mysql?
1.DESC table_name;
2.DESC table_name
3.DESC
4.None of the mentioned
Which command is used to show all tables that are stored in a database?
1.SHOWS
2.SHOW
3.SHOWES
4.None of the mentioned
Which data type character merges the “Check Constraint” into a data type definition?
1.ENUM
2.ENUM1
3.ENUM2
4.None of the mentioned
Which declaration doesn't use the same number of bytes and consumption of bytes depends on the input data?
1.Varchar
2.Char
3.Both Varchar and Char
4.None of the mentioned
Which declaration represents that “character data will consume the same number of bytes as declared and is right padded”?
1.Char
2.Varchar
3.Both Char and Varchar
4.None of the mentioned
Which feature is used for the automatic increment of the column?
1.AUTO_INCREMENT
2.AUTO
3.INCREMENT
4.All of the mentioned
Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character?
1.NO_ESCAPES_SLASH
2.NO_ESCAPES_BACKSLASH
3.NO_BACKSLASH_ESCAPES
4.NO_BACKSLASH_ESCAPE
Which of the following functions are not performed by “ALTER” clause?
1.Change the name of the table
2.Change the name of the column
3.Drop a column
4.All of the mentioned
Which statement can be used for modifying the definition for an existing table?
1.ALTER
2.Modified
3.SELECT
4.FROM
Which statement is used for updating existing information in the table?
1.UPDATE
2.WHERE
3.MODIFY
4.ALTER
Which statement is used to delete an existing row from the table?
1.DELETE
2.WHERE
3.MODIFY
4.None of the mentioned
Which Statement is used to insert the values in the table?
1.INSERT INTO
2.Insert
3.INSERT
4.None of the mentioned
Which statement is used to select columns and rows from the table?
1.SELECT
2.ALTER
3.MODIFY
4.FROM
X’61626364′ and X’61626364′ are respectively ______
1.abcd and 1633837924
2.abcd and 4297383361
3.dcba and 1633837924
4.dcba and 4297383361
x’ffff’ in decimal is ___
1.65534
2.66535
3.65536
4.65537