CS403 Quiz 4 Set 2

Q1. The ________ operator allows to use wild cards in the where clause of an SQL statement.

1. IN
2. FROM
3. None of the above.
4. LIKE

Correct answer: LIKE

Q2. Consider the two relations,

Supplier (S_no, S_name, Contact_No, Address) and

Supply (S_no, Item_no). Which of the following statements give(s) a list of supplier names supplying the item with Item_no

‘555’?

1. SELECT S_name FROM Supplier WHERE Item_no=’555’
2. SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’
3. SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’)
4. SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM Supply WHERE Item_no='555')

Correct answer: SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’

Q3. Text based & Graphical User Interface (GUI) most commonly called as Forms, are two different types of

1. language
2. system programs
3. Application programs
4. user interface

Correct answer: user interface

Q4. Which of the following is not DML command?

1. Select
2. Delete
3. Update
4. Truncate

Correct answer: Truncate

Q5. DBMS stand for__________.

1. Database Manipulation Software.
2. Digital Base Mapping System.
3. Database Management System.
4. Data Borrowing and Movement Software

Correct answer: Database Management System.

Q6. A memory cache, sometimes called a cache store or-------------------.

1. RAM
2. DROM
3. Hard disk
4. ROM

Correct answer: RAM

Q7. Value of a function in SQL is always determined by the input parameters

1. False
2. True

Correct answer: True

Q8. Which of the following is used with INSERT command to insert values in a DB table?

1. UPTO
2. WITH
3. ONTO
4. INTO

Correct answer: INTO

Q9. SQL is used for:

1. Generating queries, organizing, managing and retrieving data stored in a database.
2. Creating, managing and deleting tables and manage the relationships among the stored date.
3. Maintaining data integrity and coordinate data sharing.
4. All of the above

Correct answer: All of the above

Q10. There are -------------- types of user interfaces.

1. three
2. four
3. two
4. One

Correct answer: three