1. To obtain the structure of an Oracle table, the command to use is:
2. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Correct Answer is : ANSI_QUOTES
3. Which of the following is/are the DDL statements?
A) Create
B) Drop
C) Alter
D) All of the Mentioned
Correct Answer is : IGNORE_SPACE
4. In SQL, which command(s) is(are) used to change a table’s storage characteristics?
5. In SQL, which of the following is not a data definition language commands?
Correct Answer is : database name followed by table name
6. ________clause is an additional filter that is applied to the result.
7. ___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Correct Answer is : SELECT * FROM `sampledb`.`member`
8. SQL has how many main commands for DDL:
Correct Answer is : mysqldump
9. Which command defines its columns, integrity constraint in create table:
Correct Answer is : mysqlimport
10. Which command is used for removing a table and all its data from the database:
Correct Answer is : mysqladmin
11. Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:
12. The language used application programs to request data from the DBMS is referred to as __________
13. In SQL, which of the following is not a data Manipulation Language Commands?
Correct Answer is : –force
14. Which of the following is not a type of SQL statement?
Correct Answer is : comp_err
15. Which of the following is not included in DML (Data Manipulation Language)
Correct Answer is : mysql_upgrade
16. TRUNCATE statement in SQL is a –
Correct Answer is : mysqlslap
17. In SQL, which command is used to add new rows to a table?
Correct Answer is : mysqlbinlog
18. Stack is also called __________
Correct Answer is : EXPLAIN
19. A table that displays data redundancies yields ____________ anomalies.
Correct Answer is : ANALYZE TABLE
20. A type of query that is placed within a WHERE or HAVING clause of another query is called
Correct Answer is : EXPLAIN