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

SQL Server QUESTIONS : PART 1

_________ is free database software running free SQL Server technology.

SQL Server Express 

SQL Server Workgroup

 SQL Server Enterprise

SQL Server Web

SHOW ANSWER

__________is the first true GUI-based database server.

SQL Server 7.0 

SQL Server 6.5

 SQL Server 2005

SQL Server 2008

SHOW ANSWER

_________ is a software application first launched with the Microsoft SQL Server 2005.

Enterprise Manager

Query Analyzer

Business Intelligence Development Studio

 SQL Server Management Studio  

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

The SQL WHERE clause:

limits the column data that are returned.

limits the row data are returned. 

Both A and B are correct.

Neither A nor B are correct.

SHOW ANSWER

Which of the following is the original purpose of SQL?

To specify the syntax and semantics of SQL data definition language

To specify the syntax and semantics of SQL manipulation language

To define the data structures

All of the above.

SHOW ANSWER

The wildcard in a WHERE clause is useful when?

An exact match is necessary in a SELECT statement.

.

An exact match is not possible in a SELECT statement.

An exact match is necessary in a CREATE statement.

An exact match is not possible in a CREATE statement.

SHOW ANSWER

A view is which of the following?

A virtual table that can be accessed via SQL commands

A virtual table that cannot be accessed via SQL commands

A base table that can be accessed via SQL commands

A base table that cannot be accessed via SQL commands

SHOW ANSWER

The command to eliminate a table from a database is:

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER; 

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

SHOW ANSWER

SQL data definition commands make up a(n) ________

DDL

DML

HTML

XML

SHOW ANSWER

The SQL keyword(s) ________ is used with wildcards.

LIKE only

IN only

NOT IN only

IN and NOT IN

SHOW ANSWER

Which of the following is the correct order of keywords for SQL SELECT statements?

SELECT, FROM, WHERE  

FROM, WHERE, SELECT

WHERE, FROM,SELECT

SELECT,WHERE,FROM

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