DBMS (Database Management System)

Question related to DBMS!!!

1. The DBMS acts as an interface between what two components of an enterprise-class database system?

A.Database application and the database

B.Data and the database

C.The user and the database application

D.Database application and SQL

2. SQL stands for ________ .

A.Structured Query Language

B.Sequential Query Language

C.Structured Question Language

D.Sequential Question Language

3. Because it contains a description of its own structure, a database is considered to be _______ .

A.Described

B.metadata compatible

C.self-describing

D.an application program.

4. You can add a row using SQL in a database with which of the following?

A.ADD

B.CREATE

C.INSERT

D.MAKE

5. The wildcard in a SELECT statement is which of the following?

A.%

B.&

C.*

D.#

6. The command to eliminate a row from a table is:

A.REMOVE FROM CUSTOMER

B.DROP FROM CUSTOMER

C.DELETE FROM CUSTOMER

D.UPDATE FROM CUSTOMER

7. The SQL WHERE clause:

A.limits the column data that are returned.

B.limits the row data are returned.

C.Both A and B are correct.

D.Neither A nor B are correct.

8. Which of the following is the original purpose of SQL?

A.To specify the syntax and semantics of SQL data definition language

B.To specify the syntax and semantics of SQL manipulation language

C.To define the data structures

D.All of the above.

9. 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.

10. A view is which of the following?

A.A virtual table that can be accessed via SQL commands

B.A virtual table that cannot be accessed via SQL commands

C.A base table that can be accessed via SQL commands

D.A base table that cannot be accessed via SQL commands

11. The command to eliminate a table from a database is:

A. REMOVE TABLE CUSTOMER;

B.DROP TABLE CUSTOMER;

C.DELETE TABLE CUSTOMER;

D.UPDATE TABLE CUSTOMER;

12. ON UPDATE CASCADE ensures which of the following?

A. Normalization

B.Data Integrity

C. Materialized Views

D. All of the above.

13. SQL data definition commands make up a(n) ________ .

A. DDL

B. DML

C. HTML 

D. XML

14. The SQL keyword(s) ________ is used with wildcards.

A. LIKE only

B. IN only

C. NOT IN only

D. IN and NOT IN

15. Which of the following is the correct order of keywords for SQL SELECT statements?

A. SELECT, FROM, WHERE

B. FROM, WHERE, SELECT

C. WHERE, FROM,SELECT

D. SELECT,WHERE,FROM

16. A subquery in an SQL SELECT statement is enclosed in:

A. braces — {…}.

B. CAPITAL LETTERS.

C. parenthesis — (…)

D. brackets — [...].

17. The result of a SQL SELECT statement is a(n) ________ .

A. report

B. form

C. file

D. table

18. Which one is not the command of DDL?

A. create

B. alter

C. delete

D. drop

19. Grant & Revoke are the commands ___________.

A. DDL

B. DML

C. DCL

D. TCL

20. Commands of TCL are ?

A. COMMIT &ROLLBACK

B. DROP &TRUNCATE

C. UPDATE &DELETE

D. NONE OF THESE

21. Which of the following are the five built-in functions provided by SQL?

A. COUNT, SUM, AVG, MAX,MIN

B. SUM, AVG, MIN, MAX,MULT

C. SUM, AVG, MULT, DIV,MIN

D. SUM, AVG, MIN, MAX,NAME

22. Which of the following options list the steps to convert a table to its second normal form? 
A. All of the above
B. Find and remove fields that are related to the only part of the key.
C. Assign the new table with the key i.e. part of the whole composite key.
D. Group the removed items in the another table.

23. In which of the following ways does “TRUNCATE TABLE” differ from “DELETE”?
A. All of the above
B. The number of deleted rows are not returned.
C. Truncate operations are not transaction safe.
D. Truncate operations drop and re-create the table which is much faster than deleting rows. one by one.

24. Following tasks can be performed when using the ALTER TABLE
clause:
1.Change the name of the table
2.Change the name of the column
3.Decrease the size of a column if table data exists.
  - True
  - False

25. Sometimes tables within particular database become obsolete and ought to be discarded. Which of the following commands would you use for the same? 
A. None of the above
B. REMOVE TABLE < TABLE NAME>
C. DROP TABLE < TABLE NAME >
D. DELETE TABLE < TABLE NAME >

26. A foreign key must have a corresponding primary key or unique key value in the master table. 
- True
- False

27. NULL value is equivalent to a value of Zero if the data type is number 
- True
- False

28. Integrity constraint can be dropped if the rule that it enforces is not longer TRUE or if the constraint is no longer needed.
- True
- False

29. SELECT TRIM(‘ Hansel ‘ ) “Trim both sides” FROM DUAL What would be the output of the above command?
A. None of the above
B. Trim both sides
C. Hansel
D. Trim both sides Hansel

30. What would be the output of following command. SELECT TRANSLATE(’1sct523′,’123′, ’7a9′) “Change” FROM DUAL; 
A. 7sct 5a9
B. None of the above
C. 7 sct
D. Change 7 sct 5a9

31. What is joining a Table to itself called?
A. Self Join
B. Outer join
C. Left inner join
D. Inner join

For answer key...Go here