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
Learn more