Which statement can be used to specify the sql_mode system variable at runtime?
1.SPECIFY
2.SET
3.ASSIGN
4.CHANGE
Answer:2
Posted Date:-2021-07-18 21:19:21
1.single quotes
2.double quotes
3.backticks
4.can't be quoted
Answer 31.reject them
2.accept them
3.change them to the closest legal value and accept
4.change them to the closest legal value and reject
Answer 11.SQL
2.Network calls
3.A programming language like C++
4.APIs
Answer 11.Schema
2.View
3.Instance
4.Table
Answer 11..my.cnf
2..my.ini
3..my.opt
4..my.opc
Answer 11..mysql_queries
2..queries
3..mysql_history
4..history
Answer 31.chmod +e run_me.sh
2.chmod +a run_me.sh
3.chmod +y run_me.sh
4.chmod +x run_me.sh
Answer 41.SELECT DATABASE()
2.SELECT DATABASE sampledb
3.USE DATABASE sampledb
4.USE sampledb
Answer 41.map
2.direct
3.label
4.alias
Answer 41.Ctrl-A
2.Ctrl-E
3.Ctrl-D
4.Esc-a
Answer 11.SQL server
2.Server SQL mode
3.Operating system of machine
4.Does not depend on anything
Answer 31.mysqla
2.mysqlb
3.mysqlc
4.mysqld
Answer 41.value equal to zero
2.unknown value
3.negative values
4.a large value
Answer 21.table
2.time only
3.date only
4.date and time
Answer 41.sampdb
2.mysql
3.information_schema
4.readme_db
Answer 31.sql_config
2.sql_mode
3.sql_server
4.sql_enable
Answer 21.mysql exec.sql > sampdb
2.mysql sampdb < exec.sql
3.mysql exec.sql
4.mysql exec
Answer 21.DESCRIBE tbl_name
2.VIEW tbl_name
3.SELECT TABLE tbl_name
4.SELECT tbl_name
Answer 11.only the table name
2.only the database name
3.table name followed by database name
4.database name followed by table name
Answer 41.zero
2.a positive value
3.a negative value
4.null
Answer 41.copies to clipboard
2.pastes from clipboard
3.undoes last change
4.deletes the current line
Answer 31.Accent Insensitive
2.Augment Insensitive
3.Articulate Insensitive
4.Addition Insensitive
Answer 11.Objects
2.Tables
3.Networks
4.File systems
Answer 21.0
2.1
3.2
4.more than 1
Answer 41.64
2.128
3.256
4.32
Answer 31.invalid
2.display contents of table_1
3.improper case being used
4.display only column names in table_1
Answer 21.Table
2.Row
3.Column
4.Object
Answer 21.Table
2.Row
3.Column
4.Object
Answer 31.lower
2.upper
3.mixed
4.random
Answer 11.SORT
2.GROUP
3.FILTER
4.COLLATE
Answer 41.GROUP
2.GROUP BY
3.ORDER
4.ORDER BY
Answer 41.MySQL client
2.MySQL server
3.SQL
4.Server daemon program
Answer 21.ANSI_DQ
2.ANSI_QUOTES
3.ANSI_RECG_QUOTES
4.ANSI_RECG_DQUOTES
Answer 21.PIPES_AS_CONCAT
2.ORS_AS_CONCAT
3.DOUBLE_PIPE_AS_CONCAT
4.LOGIC_OR_AS_CONCAT
Answer 11._
2.$
3.2
4..
Answer 41.LIKE
2.WHERE
3.IS
4.SAME
Answer 11.–sqlmode=’TRADITIONAL’
2.–sql_mode=’TRADITIONAL’
3.–sql-mode=’TRADITIONAL’
4.–sql.mode=’TRADITIONAL’
Answer 31.123_id
2.123id
3.id1
4.123
Answer 41.Event names
2.Logfile group names
3.Column names
4.Indexes
Answer 21.Stored function name
2.Stored procedure name
3.Trigger name
4.Event name
Answer 31.SELECT * FROM `sampledb.member`
2.SELECT * FROM `sampledb`.`member`
3.SELECT * FROM `member`.`sampledb`
4.SELECT * FROM `member.sampledb`
Answer 21.-e
2.-p
3.-u
4.-h
Answer 21.COMPOSITE
2.COMPOSITE_MODE
3.COMPOSITE_SERVER
4.ANSI
Answer 41.COLLATION
2.ATOMICITY
3.COLLABORATION
4.NORMALIZATION
Answer 11.ANSI
2.IGNORE_FUNC
3.TRADITIONAL
4.IGNORE_SPACE
Answer 41.ANSI
2.ANSI_QUOTES
3.TRADITIONAL
4.PIPES_AS_CONCAT
Answer 21.SPECIFY
2.SET
3.ASSIGN
4.CHANGE
Answer 21.Object-oriented
2.Hierarchical
3.Relational
4.Network
Answer 31.lower_case_table_names
2.lower_case_all
3.lower_case_alias
4.lower_case_aliases
Answer 1