Burst

SET 2

Which is not DDL (data definition language) operation 

GOEDUHUB.COM

Update data into a table in SQL database

1

Which statement is correct? A table can have 

GOEDUHUB.COM

one primary key and many unique key

2

Which SQL commands can be used to delete all records from the table in a sql database? 

GOEDUHUB.COM

Delete and TRUNCATE

3

SQL Command to remove stored procedure SQL 

GOEDUHUB.COM

DROP

4

Which SQL sub language is used for creating and destroying table structure? 

GOEDUHUB.COM

DML

5

Which SQL function is used to count the number of rows in a SQL query? 

GOEDUHUB.COM

COUNT(*)

6

The UNION SQL clause can be used with _____ 

GOEDUHUB.COM

SELECT clause only 

8

What is the meaning of LIKE ‘%0%0%’? 

GOEDUHUB.COM

Feature has two 0’s in it, at any position 

10

Which of the following statements is true concerning subqueries? 

GOEDUHUB.COM

Involves the use of an inner and outer query 

11

Which of the following statement is true? 

GOEDUHUB.COM

All of the Mentioned 

12

The phrase “greater than at least one” is represented in SQL by ___ 

GOEDUHUB.COM

> some 

13

Arrow