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 3

Which keyword is the synonym for DATABASE?

TABLE

OBJECT

DB

SCHEMA

SHOW ANSWER

Which keyword is used to create a database?

CREATE

SET

SETUP

LINK

SHOW ANSWER

Which statement makes changes to the database’s global attributes?

CHANGE

ALTER

ALTERNATE

UPDATE

SHOW ANSWER

The statement to change the table name is __________

CHANGE

CHANGENAME

CHANGENM

RENAME

SHOW ANSWER

The facility that allows nesting one select statement into another is called __________

nesting

binding

subquerying

encapsulating

SHOW ANSWER

You can add a row using SQL in a database with which of the following?

add

create

insert

make

SHOW ANSWER

The command to remove rows from a table 'CUSTOMER' is:

REMOVE FROM CUSTOMER ...

DROP FROM CUSTOMER ...

 DELETE FROM CUSTOMER WHERE ... 

UPDATE FROM CUSTOMER ...

SHOW ANSWER

Which of the following are the five built-in functions provided by SQL?

COUNT, SUM, AVG, MAX, MIN

SUM, AVG, MIN, MAX, MULT

SUM, AVG, MULT, DIV, MIN

SUM, AVG, MIN, MAX, NAME

SHOW ANSWER

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

ONLY

UNIQUE

DISTINCT 

SINGLE  

SHOW ANSWER

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); 

SHOW ANSWER

Which of these operators does not perform relative-value comparisons?

=

==

<=

>=

SHOW ANSWER

Which of these is also known as a virtual table?

SCHEMA

DATABASE

JOIN

VIEW

SHOW ANSWER

A table can be deleted using the command __________

REMOVE

DELETE

CLEAR

DROP

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