How are identifiers quoted in MySQL?
1.single quotes
2.double quotes
3.backticks
4.can't be quoted
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
How is communication established with MySQL?
1.SQL
2.Network calls
3.A programming language like C++
4.APIs
In MySQL databases, the structure representing the organizational views of the entire databases is ____________
1.Schema
2.View
3.Instance
4.Table
In UNIX, the name of the option file is __________
1..my.cnf
2..my.ini
3..my.opt
4..my.opc
On UNIX, statements entered in ‘MySQL’ are saved in which file?
1..mysql_queries
2..queries
3..mysql_history
4..history
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
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
The clause that enables mapping a short command to a long command is __________
1.map
2.direct
3.label
4.alias
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
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
The MySQL server used in its client/server architecture is _______________
1.mysqla
2.mysqlb
3.mysqlc
4.mysqld
The NULL value also means ___________
1.value equal to zero
2.unknown value
3.negative values
4.a large value
The query ‘SELECT NOW()’ shows the current _____________
1.table
2.time only
3.date only
4.date and time
The special database that always exists after setting up MySQL in a computer is __________
1.sampdb
2.mysql
3.information_schema
4.readme_db
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
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
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
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
What does comparing a known value with NULL result into?
1.zero
2.a positive value
3.a negative value
4.null
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
What is AI in terms of database collation?
1.Accent Insensitive
2.Augment Insensitive
3.Articulate Insensitive
4.Addition Insensitive
What is data in a MySQL database organized into?
1.Objects
2.Tables
3.Networks
4.File systems
What is the maximum collations a character set can have?
1.0
2.1
3.2
4.more than 1
What is the maximum length for alias names in terms of characters?
1.64
2.128
3.256
4.32
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
What represents a ‘tuple’ in a relational database?
1.Table
2.Row
3.Column
4.Object
What represents an ‘attribute’ in a relational database?
1.Table
2.Row
3.Column
4.Object
Which case does InnoDB store database names in?
1.lower
2.upper
3.mixed
4.random
Which clause can be used to sort string values according to a specific collation?
1.SORT
2.GROUP
3.FILTER
4.COLLATE
Which clause is used to sort query elements?
1.GROUP
2.GROUP BY
3.ORDER
4.ORDER BY
Which is the MySQL instance responsible for data processing?
1.MySQL client
2.MySQL server
3.SQL
4.Server daemon program
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
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
Which of the following characters is illegal in naming an unquoted identifier in SQL?
1._
2.$
3.2
4..
Which of the following clauses is used to display information that match a given pattern?
1.LIKE
2.WHERE
3.IS
4.SAME
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’
Which of the following is an illegal unquoted identifier name?
1.123_id
2.123id
3.id1
4.123
Which of the following is case sensitive in MySQL?
1.Event names
2.Logfile group names
3.Column names
4.Indexes
Which of the following is case sensitive?
1.Stored function name
2.Stored procedure name
3.Trigger name
4.Event name
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`
Which of the following options tells mysql to ask for entering the password?
1.-e
2.-p
3.-u
4.-h
Which of these modes is a composite server mode?
1.COMPOSITE
2.COMPOSITE_MODE
3.COMPOSITE_SERVER
4.ANSI
Which property determines whether a database object is a case sensitive?
1.COLLATION
2.ATOMICITY
3.COLLABORATION
4.NORMALIZATION
Which server mode value disables use of built in function names as identifiers?
1.ANSI
2.IGNORE_FUNC
3.TRADITIONAL
4.IGNORE_SPACE
Which server mode value enables use of double quotes to wrap identifier names?
1.ANSI
2.ANSI_QUOTES
3.TRADITIONAL
4.PIPES_AS_CONCAT
Which statement can be used to specify the sql_mode system variable at runtime?
1.SPECIFY
2.SET
3.ASSIGN
4.CHANGE
Which type of database management system is MySQL?
1.Object-oriented
2.Hierarchical
3.Relational
4.Network
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