R4RIN – MCQs, Mock Tests | SQL SQL MCQ SET 13

Which type of database management system is MySQL?

1. Object-oriented
2. Hierarchical
3. Relational
4. Network

✅ Correct Answer: 3

What is data in a MySQL database organized into?

1. Objects
2. Tables
3. Networks
4. File systems

✅ Correct Answer: 2

What represents an ‘attribute’ in a relational database?

1. Table
2. Row
3. Column
4. Object

✅ Correct Answer: 3

What represents a ‘tuple’ in a relational database?

1. Table
2. Row
3. Column
4. Object

✅ Correct Answer: 2

How is communication established with MySQL?

1. SQL
2. Network calls
3. A programming language like C++
4. APIs

✅ Correct Answer: 1

Which is the MySQL instance responsible for data processing?

1. MySQL client
2. MySQL server
3. SQL
4. Server daemon program

✅ Correct Answer: 2

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

1. mysqla
2. mysqlb
3. mysqlc
4. mysqld

✅ Correct Answer: 4

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

1. Schema
2. View
3. Instance
4. Table

✅ Correct Answer: 1

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

1. LIKE
2. WHERE
3. IS
4. SAME

✅ Correct Answer: 1

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

1. sampdb
2. mysql
3. information_schema
4. readme_db

✅ Correct Answer: 3

The NULL value also means ___________

1. value equal to zero
2. unknown value
3. negative values
4. a large value

✅ Correct Answer: 2

What does comparing a known value with NULL result into?

1. zero
2. a positive value
3. a negative value
4. null

✅ Correct Answer: 4

Which clause is used to sort query elements?

1. GROUP
2. GROUP BY
3. ORDER
4. ORDER BY

✅ Correct Answer: 4

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

1. -e
2. -p
3. -u
4. -h

✅ Correct Answer: 2

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

1. table
2. time only
3. date only
4. date and time

✅ Correct Answer: 4

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

✅ Correct Answer: 4

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

✅ Correct Answer: 1

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

✅ Correct Answer: 1

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

✅ Correct Answer: 3

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

1. .mysql_queries
2. .queries
3. .mysql_history
4. .history

✅ Correct Answer: 3

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

✅ Correct Answer: 4

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

✅ Correct Answer: 2

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

1. map
2. direct
3. label
4. alias

✅ Correct Answer: 4

In UNIX, the name of the option file is __________

1. .my.cnf
2. .my.ini
3. .my.opt
4. .my.opc

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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

✅ Correct Answer: 1

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

✅ Correct Answer: 2

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

✅ Correct Answer: 1

Which of these modes is a composite server mode?

1. COMPOSITE
2. COMPOSITE_MODE
3. COMPOSITE_SERVER
4. ANSI

✅ Correct Answer: 4

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’

✅ Correct Answer: 3

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

1. SPECIFY
2. SET
3. ASSIGN
4. CHANGE

✅ Correct Answer: 2

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

1. _
2. $
3. 2
4. .

✅ Correct Answer: 4

How are identifiers quoted in MySQL?

1. single quotes
2. double quotes
3. backticks
4. can't be quoted

✅ Correct Answer: 3

Which of the following is an illegal unquoted identifier name?

1. 123_id
2. 123id
3. id1
4. 123

✅ Correct Answer: 4

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

1. ANSI
2. ANSI_QUOTES
3. TRADITIONAL
4. PIPES_AS_CONCAT

✅ Correct Answer: 2

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

1. ANSI
2. IGNORE_FUNC
3. TRADITIONAL
4. IGNORE_SPACE

✅ Correct Answer: 4

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

1. 64
2. 128
3. 256
4. 32

✅ Correct Answer: 3

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

✅ Correct Answer: 4

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`

✅ Correct Answer: 2

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

✅ Correct Answer: 2

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

✅ Correct Answer: 3

Which of the following is case sensitive?

1. Stored function name
2. Stored procedure name
3. Trigger name
4. Event name

✅ Correct Answer: 3

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

✅ Correct Answer: 1

Which case does InnoDB store database names in?

1. lower
2. upper
3. mixed
4. random

✅ Correct Answer: 1

Which of the following is case sensitive in MySQL?

1. Event names
2. Logfile group names
3. Column names
4. Indexes

✅ Correct Answer: 2

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

1. COLLATION
2. ATOMICITY
3. COLLABORATION
4. NORMALIZATION

✅ Correct Answer: 1

What is AI in terms of database collation?

1. Accent Insensitive
2. Augment Insensitive
3. Articulate Insensitive
4. Addition Insensitive

✅ Correct Answer: 1

What is the maximum collations a character set can have?

1. 0
2. 1
3. 2
4. more than 1

✅ Correct Answer: 4

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

1. SORT
2. GROUP
3. FILTER
4. COLLATE

✅ Correct Answer: 4