Header Ads Widget

Responsive Advertisement

Module 5: Reading and Writing Data with SQL.


Reading and Writing Data with SQL

1. Which type of join joins a table to itself?

A. Inner join

B. Cartesian join

C. Self join

D. Outer join

Answer: C

2. Which of the following statements are/is true?

A. Filtered query allows summarizing, grouping of records into summarized record set.

B. Aggregated query allows summarizing, grouping of records into summarized record set.

C. Nested query merges multiple query results together.

D. UNION keyword is used in composite query

Answer: B, D

3. _____________ contains blocks of command, where each successive block is dependent on the result of previous block.

A. Procedural language

B. Non-procedural language

Answer: A

4. In relational database, ___________ allows to temporarily stores changes.

A. Commit command

B. Rollback command

C. A transaction

D. None

Answer: C

5. For which type of query Order by clause is used?

A. Basic query

B. Filtered query

C. Sorted query

D. Join query

Answer: C

6. Filtering using a negative such as NOT or  !=  forces full table uses index and avoid scanning full table.

A. True

B. False

Answer: A

7. The LIKE operator is not efficient because it tends to full table scan.

A. True

B. False

Answer: A

8. Which type of join simply joins two tables regardless of any relationship?

A. Self join

B. Cross join

C. Full outer join

D. Nested join

Answer: B

9. Which of the following statement(s) is/are true?

A. Composite queries may not have the same data types for each field, all in the same sequence.

B. Insert column allows addition to tables in database.

C. A single command must be executed within a single transaction.

D. The DISTINCT clause is used to return only the unique records in a set of returned records.

Answer: C, D

10. 10 The WHERE and HAVING clause are used for same purpose.

A. True 

B. False

Answer: A

11. For sorting data, which clause is used?

A. WHERE clause

B. HAVING clause

C. ORDER BY clause

D. GROUP BY Clause

Answer: C

12. A query contain another query is called? Choose two.

A. Basic Query

B. Filter Query

C. Nested Query

D. Aggregate Query

E. Sub Query

Answer: C,E

13. Which command are used to change data in tables in a database? Choose two.





Answer: B,D

14. Which types of query merge multiple query result together?

A. Basic Query

B. Filter Query

C. Composite Query

D. Nested Query

Answer: C

15. Which commands allow alteration to metadata?

A. DELETE Command

B. ALTER Command

C. SELECT Command

D. UPDATE Command

Answer: B

16. A join who merges all records in one table with all records in another tables is called?

A. Self join

B. Outer join

C. Cross join

D. Equi join

Answer: C

Post a Comment