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

Posted Date:-2021-07-18 21:19:21


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

Posted Date:-2021-07-18 21:19:21


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


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


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


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


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

Posted Date:-2021-07-18 21:19:21


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

Posted Date:-2021-07-18 21:19:21


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


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

Posted Date:-2021-07-18 21:19:21


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

Posted Date:-2021-07-18 21:19:21


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


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


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


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

Posted Date:-2021-07-18 21:19:21


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

Posted Date:-2021-07-18 21:19:21


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

Posted Date:-2021-07-18 21:19:21


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

Posted Date:-2021-07-18 21:19:21


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

Posted Date:-2021-07-18 21:19:21


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


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

Posted Date:-2021-07-18 21:19:21


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


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


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


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


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

Posted Date:-2021-07-18 21:19:21


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

1.Table

2.Row

3.Column

4.Object

Posted Date:-2021-07-18 21:19:21


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

1.Table

2.Row

3.Column

4.Object

Posted Date:-2021-07-18 21:19:21


Question:
Which case does InnoDB store database names in?

1.lower

2.upper

3.mixed

4.random

Posted Date:-2021-07-18 21:19:21


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


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


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


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

Posted Date:-2021-07-18 21:19:21


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

Posted Date:-2021-07-18 21:19:21


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


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


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’

Posted Date:-2021-07-18 21:19:21


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


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


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


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`

Posted Date:-2021-07-18 21:19:21


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


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


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


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


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

Posted Date:-2021-07-18 21:19:21


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


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


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

Posted Date:-2021-07-18 21:19:21


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!