‘2341’ is a ____________
1.integer
2.floating point
3.hexadecimal
4.string
Posted Date:-2021-07-19 04:22:44
“INSERT†is same as “UPDATE�
1.NO
2.YES
3.May be
4.None of the mentioned
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________
1.identifier-quoting character
2.string-quoting character
3.hexadecimal
4.string
Posted Date:-2021-07-19 04:22:44
In the following SQL query, what does “person†stands for?
1.Composite attributes
2.Multivalued attributes
3.Table name
4.None of the mentioned
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
Numbers prefixed with ‘0x’ are in base __________
1.8
2.16
3.32
4.64
Posted Date:-2021-07-19 04:22:44
The BIGINT precision is of bit _________
1.32
2.64
3.128
4.16
Posted Date:-2021-07-19 04:22:44
The bit-field values are prefixed with __________
1.0b
2.0bit
3.bit-
4.‘bit’
Posted Date:-2021-07-19 04:22:44
The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________
1.32
2.64
3.65
4.16
Posted Date:-2021-07-19 04:22:44
The escape sequence for carriage return is ___________
1.‘c’
2.‘ ’
3.‘’
4.‘z’
Posted Date:-2021-07-19 04:22:44
The mantissa in -1.58E5 is __________
1.-1.58
2.1.58
3.E
4.5
Posted Date:-2021-07-19 04:22:44
The maximum length of the char columns is ____________
1.255 bytes
2.65, 535 bytes
3.256 bytes
4.None of the mentioned
Posted Date:-2021-07-19 04:22:44
The number of legal hexadecimal values among 0x0a, 0x0A, 0X0a and 0X0A is _________
1.1
2.2
3.3
4.4
Posted Date:-2021-07-19 04:22:44
To measure the length of a string in bytes, the operator used is __________
1.CHAR_LENGTH()
2.LENGTH()
3.LEN()
4.SIZE()
Posted Date:-2021-07-19 04:22:44
What default value gets stored in columns of the table?
1.NULL
2.0
3.1
4.-1
Posted Date:-2021-07-19 04:22:44
What is the default value of column?
1.NULL
2.0
3.-1
4.Undefined
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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()
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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;
Posted Date:-2021-07-19 04:22:44
Which authentications are required for login into Mysql command line tool?
1.Username
2.Password
3.Only Username
4.Both Username and Password
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
Which clause is used to rename the existing table?
1.RENAME
2.MODIFY
3.ALTER
4.None of the mentioned
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
Which Clause is used to select a particular table in Mysql?
1.WHERE
2.SELECT
3.FROM
4.ALTER
Posted Date:-2021-07-19 04:22:44
Which Clause is used to sort the stored data in alphabetical order?
1.ORDER by CLAUSE
2.MODIFY
3.ALTER
4.UPDATE
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
Which data type character merges the “Check Constraint†into a data type definition?
1.ENUM
2.ENUM1
3.ENUM2
4.None of the mentioned
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
Which feature is used for the automatic increment of the column?
1.AUTO_INCREMENT
2.AUTO
3.INCREMENT
4.All of the mentioned
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
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
Posted Date:-2021-07-19 04:22:44
Which statement can be used for modifying the definition for an existing table?
1.ALTER
2.Modified
3.SELECT
4.FROM
Posted Date:-2021-07-19 04:22:44
Which statement is used for updating existing information in the table?
1.UPDATE
2.WHERE
3.MODIFY
4.ALTER
Posted Date:-2021-07-19 04:22:44
Which statement is used to delete an existing row from the table?
1.DELETE
2.WHERE
3.MODIFY
4.None of the mentioned
Posted Date:-2021-07-19 04:22:44
Which Statement is used to insert the values in the table?
1.INSERT INTO
2.Insert
3.INSERT
4.None of the mentioned
Posted Date:-2021-07-19 04:22:44
Which statement is used to select columns and rows from the table?
1.SELECT
2.ALTER
3.MODIFY
4.FROM
Posted Date:-2021-07-19 04:22:44
X’61626364′ and X’61626364′ are respectively ______
1.abcd and 1633837924
2.abcd and 4297383361
3.dcba and 1633837924
4.dcba and 4297383361
Posted Date:-2021-07-19 04:22:44
x’ffff’ in decimal is ___
1.65534
2.66535
3.65536
4.65537
Posted Date:-2021-07-19 04:22:44