How are identifiers quoted in MySQL?
1.single quotes
2.double quotes
3.backticks
4.can't be quoted
Posted Date:-2021-07-18 21:19:21
How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data?
1.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
Posted Date:-2021-07-18 21:19:21
How is communication established with MySQL?
1.SQL
2.Network calls
3.A programming language like C++
4.APIs
Posted Date:-2021-07-18 21:19:21
In MySQL databases, the structure representing the organizational views of the entire databases is ____________
1.Schema
2.View
3.Instance
4.Table
Posted Date:-2021-07-18 21:19:21
In UNIX, the name of the option file is __________
1..my.cnf
2..my.ini
3..my.opt
4..my.opc
Posted Date:-2021-07-18 21:19:21
On UNIX, statements entered in ‘MySQL’ are saved in which file?
1..mysql_queries
2..queries
3..mysql_history
4..history
Posted Date:-2021-07-18 21:19:21
Suppose run_me.sh is a script file. Which command is used to make it executable?
1.chmod +e run_me.sh
2.chmod +a run_me.sh
3.chmod +y run_me.sh
4.chmod +x run_me.sh
Posted Date:-2021-07-18 21:19:21
Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?
1.SELECT DATABASE()
2.SELECT DATABASE sampledb
3.USE DATABASE sampledb
4.USE sampledb
Posted Date:-2021-07-18 21:19:21
The clause that enables mapping a short command to a long command is __________
1.map
2.direct
3.label
4.alias
Posted Date:-2021-07-18 21:19:21
The command to move the cursor to the beginning of line in MySQL input editor is?
1.Ctrl-A
2.Ctrl-E
3.Ctrl-D
4.Esc-a
Posted Date:-2021-07-18 21:19:21
The default case sensitivity of database and table names depends on ___________
1.SQL server
2.Server SQL mode
3.Operating system of machine
4.Does not depend on anything
Posted Date:-2021-07-18 21:19:21
The MySQL server used in its client/server architecture is _______________
1.mysqla
2.mysqlb
3.mysqlc
4.mysqld
Posted Date:-2021-07-18 21:19:21
The NULL value also means ___________
1.value equal to zero
2.unknown value
3.negative values
4.a large value
Posted Date:-2021-07-18 21:19:21
The query ‘SELECT NOW()’ shows the current _____________
1.table
2.time only
3.date only
4.date and time
Posted Date:-2021-07-18 21:19:21
The special database that always exists after setting up MySQL in a computer is __________
1.sampdb
2.mysql
3.information_schema
4.readme_db
Posted Date:-2021-07-18 21:19:21
The system variable in MySQL server that enables to configure the SQL mode is __________
1.sql_config
2.sql_mode
3.sql_server
4.sql_enable
Posted Date:-2021-07-18 21:19:21
To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?
1.mysql exec.sql > sampdb
2.mysql sampdb < exec.sql
3.mysql exec.sql
4.mysql exec
Posted Date:-2021-07-18 21:19:21
To see the table structure, which of the following SQL commands is issued?
1.DESCRIBE tbl_name
2.VIEW tbl_name
3.SELECT TABLE tbl_name
4.SELECT tbl_name
Posted Date:-2021-07-18 21:19:21
What does a fully qualified table name consist of?
1.only the table name
2.only the database name
3.table name followed by database name
4.database name followed by table name
Posted Date:-2021-07-18 21:19:21
What does comparing a known value with NULL result into?
1.zero
2.a positive value
3.a negative value
4.null
Posted Date:-2021-07-18 21:19:21
What does Control-_ do in MySQL input editor?
1.copies to clipboard
2.pastes from clipboard
3.undoes last change
4.deletes the current line
Posted Date:-2021-07-18 21:19:21
What is AI in terms of database collation?
1.Accent Insensitive
2.Augment Insensitive
3.Articulate Insensitive
4.Addition Insensitive
Posted Date:-2021-07-18 21:19:21
What is data in a MySQL database organized into?
1.Objects
2.Tables
3.Networks
4.File systems
Posted Date:-2021-07-18 21:19:21
What is the maximum collations a character set can have?
1.0
2.1
3.2
4.more than 1
Posted Date:-2021-07-18 21:19:21
What is the maximum length for alias names in terms of characters?
1.64
2.128
3.256
4.32
Posted Date:-2021-07-18 21:19:21
What is true about the following SQL statement?
1.invalid
2.display contents of table_1
3.improper case being used
4.display only column names in table_1
Posted Date:-2021-07-18 21:19:21
What represents a ‘tuple’ in a relational database?
1.Table
2.Row
3.Column
4.Object
Posted Date:-2021-07-18 21:19:21
What represents an ‘attribute’ in a relational database?
1.Table
2.Row
3.Column
4.Object
Posted Date:-2021-07-18 21:19:21
Which case does InnoDB store database names in?
1.lower
2.upper
3.mixed
4.random
Posted Date:-2021-07-18 21:19:21
Which clause can be used to sort string values according to a specific collation?
1.SORT
2.GROUP
3.FILTER
4.COLLATE
Posted Date:-2021-07-18 21:19:21
Which clause is used to sort query elements?
1.GROUP
2.GROUP BY
3.ORDER
4.ORDER BY
Posted Date:-2021-07-18 21:19:21
Which is the MySQL instance responsible for data processing?
1.MySQL client
2.MySQL server
3.SQL
4.Server daemon program
Posted Date:-2021-07-18 21:19:21
Which mode tells the server to recognize || as the string concatenation operator?
1.PIPES_AS_CONCAT
2.ORS_AS_CONCAT
3.DOUBLE_PIPE_AS_CONCAT
4.LOGIC_OR_AS_CONCAT
Posted Date:-2021-07-18 21:19:21
Which mode tells the server to recognize double quote as an identifier quoting character?
1.ANSI_DQ
2.ANSI_QUOTES
3.ANSI_RECG_QUOTES
4.ANSI_RECG_DQUOTES
Posted Date:-2021-07-18 21:19:21
Which of the following characters is illegal in naming an unquoted identifier in SQL?
1._
2.$
3.2
4..
Posted Date:-2021-07-18 21:19:21
Which of the following clauses is used to display information that match a given pattern?
1.LIKE
2.WHERE
3.IS
4.SAME
Posted Date:-2021-07-18 21:19:21
Which of the following commands sets the SQL mode as TRADITIONAL?
1.–sqlmode=’TRADITIONAL’
2.–sql_mode=’TRADITIONAL’
3.–sql-mode=’TRADITIONAL’
4.–sql.mode=’TRADITIONAL’
Posted Date:-2021-07-18 21:19:21
Which of the following is an illegal unquoted identifier name?
1.123_id
2.123id
3.id1
4.123
Posted Date:-2021-07-18 21:19:21
Which of the following is case sensitive in MySQL?
1.Event names
2.Logfile group names
3.Column names
4.Indexes
Posted Date:-2021-07-18 21:19:21
Which of the following is case sensitive?
1.Stored function name
2.Stored procedure name
3.Trigger name
4.Event name
Posted Date:-2021-07-18 21:19:21
Which of the following MySQL statements is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?
1.SELECT * FROM `sampledb.member`
2.SELECT * FROM `sampledb`.`member`
3.SELECT * FROM `member`.`sampledb`
4.SELECT * FROM `member.sampledb`
Posted Date:-2021-07-18 21:19:21
Which of the following options tells mysql to ask for entering the password?
1.-e
2.-p
3.-u
4.-h
Posted Date:-2021-07-18 21:19:21
Which of these modes is a composite server mode?
1.COMPOSITE
2.COMPOSITE_MODE
3.COMPOSITE_SERVER
4.ANSI
Posted Date:-2021-07-18 21:19:21
Which property determines whether a database object is a case sensitive?
1.COLLATION
2.ATOMICITY
3.COLLABORATION
4.NORMALIZATION
Posted Date:-2021-07-18 21:19:21
Which server mode value disables use of built in function names as identifiers?
1.ANSI
2.IGNORE_FUNC
3.TRADITIONAL
4.IGNORE_SPACE
Posted Date:-2021-07-18 21:19:21
Which server mode value enables use of double quotes to wrap identifier names?
1.ANSI
2.ANSI_QUOTES
3.TRADITIONAL
4.PIPES_AS_CONCAT
Posted Date:-2021-07-18 21:19:21
Which statement can be used to specify the sql_mode system variable at runtime?
1.SPECIFY
2.SET
3.ASSIGN
4.CHANGE
Posted Date:-2021-07-18 21:19:21
Which type of database management system is MySQL?
1.Object-oriented
2.Hierarchical
3.Relational
4.Network
Posted Date:-2021-07-18 21:19:21
Which variable is used to set table alias names as non-case sensitive?
1.lower_case_table_names
2.lower_case_all
3.lower_case_alias
4.lower_case_aliases
Posted Date:-2021-07-18 21:19:21