Dear Readers, As we
know, IBPS specialist officer 2016 examinations are approaching in upcoming week so we are
providing a post of IT Rocket Quiz that will help to boost your
score in IBPS SO examination.
1. You can add a row using SQL in a database with which of the following?
2. A ________ is a program that performs some common action on database data and that is stored in the database.
A. pseudofile
B. trigger
C. None of the above is correct.
D. stored procedure
3. The wildcard in a WHERE clause is useful when?
A. An exact match is necessary in a SELECT statement.
B. An exact match is not possible in a SELECT statement.
C. An exact match is necessary in a CREATE statement.
D. An exact match is not possible in a CREATE statement
D. Vijaya Bank
4. The SQL statement to create a view is:
A. MAKE VIEW.
B. CREATE VIEW
C. SELECT VIEW
D. INSERT VIEW.
5. The command to eliminate a table from a database is:
A. DELETE TABLE CUSTOMER;
B. UPDATE TABLE CUSTOMER;
C. REMOVE TABLE CUSTOMER
D. DROP TABLE CUSTOMER;
6. The command to remove rows from a table ‘CUSTOMER’ is:
A. UPDATE FROM CUSTOMER ...
B. DROP FROM CUSTOMER ...
C. REMOVE FROM CUSTOMER ...
D. DELETE FROM CUSTOMER WHERE ...
7. A ________ is a stored program that is attached to a table or a view.
A. embedded SELECT statement
B. None of the above is correct.
C. pseudofile
D. trigger
8. Which of the following is valid SQL for an Index?
A. CHANGE INDEX ID;
B. ADD INDEX ID;
C. CREATE INDEX ID;
D. REMOVE INDEX ID;
9. The SQL command to create a table is:
A. MAKE TABLE
B. ALTER TABLE
C. CREATE TABLE
D. DEFINE TABLE.
10. The DROP TABLE statement:
A. deletes the table structure only.
B. works whether or not referential integrity constraints would be violated
C. deletes the table structure along with the table data.
D. is not an SQL statement.
Stay with STUDY ROCKET more updates for
upcoming IBPS, RRB PO/Clerk 2015 examinations. We need your supports so please
send your valuable thoughts of our site.
No comments:
Post a Comment