SQL/SQL MCQ SET 13 Sample Test,Sample questions

Question:
How are identifiers quoted in MySQL?

1.single quotes

2.double quotes

3.backticks

4.can't be quoted


Question:
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


Question:
How is communication established with MySQL?

1.SQL

2.Network calls

3.A programming language like C++

4.APIs


Question:
In MySQL databases, the structure representing the organizational views of the entire databases is ____________

1.Schema

2.View

3.Instance

4.Table


Question:
In UNIX, the name of the option file is __________

1..my.cnf

2..my.ini

3..my.opt

4..my.opc


Question:
On UNIX, statements entered in ‘MySQL’ are saved in which file?

1..mysql_queries

2..queries

3..mysql_history

4..history


Question:
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


Question:
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


Question:
The clause that enables mapping a short command to a long command is __________

1.map

2.direct

3.label

4.alias


Question:
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


Question:
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


Question:
The MySQL server used in its client/server architecture is _______________

1.mysqla

2.mysqlb

3.mysqlc

4.mysqld


Question:
The NULL value also means ___________

1.value equal to zero

2.unknown value

3.negative values

4.a large value


Question:
The query ‘SELECT NOW()’ shows the current _____________

1.table

2.time only

3.date only

4.date and time


Question:
The special database that always exists after setting up MySQL in a computer is __________

1.sampdb

2.mysql

3.information_schema

4.readme_db


Question:
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


Question:
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


Question:
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


Question:
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


Question:
What does comparing a known value with NULL result into?

1.zero

2.a positive value

3.a negative value

4.null


Question:
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


Question:
What is AI in terms of database collation?

1.Accent Insensitive

2.Augment Insensitive

3.Articulate Insensitive

4.Addition Insensitive


Question:
What is data in a MySQL database organized into?

1.Objects

2.Tables

3.Networks

4.File systems


Question:
What is the maximum collations a character set can have?

1.0

2.1

3.2

4.more than 1


Question:
What is the maximum length for alias names in terms of characters?

1.64

2.128

3.256

4.32


Question:
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


Question:
What represents a ‘tuple’ in a relational database?

1.Table

2.Row

3.Column

4.Object


Question:
What represents an ‘attribute’ in a relational database?

1.Table

2.Row

3.Column

4.Object


Question:
Which case does InnoDB store database names in?

1.lower

2.upper

3.mixed

4.random


Question:
Which clause can be used to sort string values according to a specific collation?

1.SORT

2.GROUP

3.FILTER

4.COLLATE


Question:
Which clause is used to sort query elements?

1.GROUP

2.GROUP BY

3.ORDER

4.ORDER BY


Question:
Which is the MySQL instance responsible for data processing?

1.MySQL client

2.MySQL server

3.SQL

4.Server daemon program


Question:
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


Question:
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


Question:
Which of the following characters is illegal in naming an unquoted identifier in SQL?

1._

2.$

3.2

4..


Question:
Which of the following clauses is used to display information that match a given pattern?

1.LIKE

2.WHERE

3.IS

4.SAME


Question:
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’


Question:
Which of the following is an illegal unquoted identifier name?

1.123_id

2.123id

3.id1

4.123


Question:
Which of the following is case sensitive in MySQL?

1.Event names

2.Logfile group names

3.Column names

4.Indexes


Question:
Which of the following is case sensitive?

1.Stored function name

2.Stored procedure name

3.Trigger name

4.Event name


Question:
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`


Question:
Which of the following options tells mysql to ask for entering the password?

1.-e

2.-p

3.-u

4.-h


Question:
Which of these modes is a composite server mode?

1.COMPOSITE

2.COMPOSITE_MODE

3.COMPOSITE_SERVER

4.ANSI


Question:
Which property determines whether a database object is a case sensitive?

1.COLLATION

2.ATOMICITY

3.COLLABORATION

4.NORMALIZATION


Question:
Which server mode value disables use of built in function names as identifiers?

1.ANSI

2.IGNORE_FUNC

3.TRADITIONAL

4.IGNORE_SPACE


Question:
Which server mode value enables use of double quotes to wrap identifier names?

1.ANSI

2.ANSI_QUOTES

3.TRADITIONAL

4.PIPES_AS_CONCAT


Question:
Which statement can be used to specify the sql_mode system variable at runtime?

1.SPECIFY

2.SET

3.ASSIGN

4.CHANGE


Question:
Which type of database management system is MySQL?

1.Object-oriented

2.Hierarchical

3.Relational

4.Network


Question:
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


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL – Basics
  20. MCQ | SQL – Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!