Trinity - MySQL SERVER Interview Preparation Questions
Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

MySQL QUESTIONS : PART 2

What does ‘name’ represent in the following code snippet?

CREATE TABLE student
       (
           name CHAR(30),
           roll_num INT,
           address CHAR(30),
           phone CHAR(12)
       );
 

A table

A row

A column

An object

SHOW ANSWER

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

Schema

View

Instance

Table

SHOW ANSWER

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

LIKE

WHERE

IS

SAME

SHOW ANSWER

What column names are displayed when this command is executed?

SHOW COLUMNS FROM tbl_name LIKE '%name';

suffixed with ‘name’

prefixed with ‘name’

suffixed with ‘%name’

prefixed with ‘%name’

SHOW ANSWER

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

sampdb

mysqlServer

information_schema

readme_db

SHOW ANSWER

Identify the table name in the following statement

INSERT INTO student VALUES('Kyle','M',NULL);

Student

Values

Kyle

M

SHOW ANSWER

The NULL value also means ___________

value equal to zero

unknown value

negative values

a large value

SHOW ANSWER

Which clause is used to sort query elements?

 GROUP

GROUP BY

ORDER

ORDER BY

SHOW ANSWER

The number of attributes in the following table is ______________

CREATE TABLE employee (
        emp_name CHAR(30),
        emp_id INT
    );
 

30

1

2

3

SHOW ANSWER

Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?

SELECT DATABASE()

SELECT DATABASE sampledb

USE DATABASE sampledb

USE sampled

SHOW ANSWER

To see the table structure, which of the following commands is issued?

DESCRIBE tbl_name

VIEW tbl_name

SELECT TABLE tbl_name

SELECT tbl_name

SHOW ANSWER

How are identifiers quoted in MySQL?

single quotes

double quotes

backticks

can’t be quoted

SHOW ANSWER

What does a fully qualified table name consist of?

only the table name

only the database name

table name followed by database name

database name followed by table name

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in