Introduction To sql programming Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” Introduction To sql programming “. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate Introduction To sql programming comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Introduction To sql programming Mcqs
  8. »
  9. Page 3

31.
The DROP TABLE statement:

Deletes the table structure only.

Deletes the table structure along with the table data.

Works whether or not referential integrity constraints would be violated.

Is not an SQL statement.

32.
SQL views can be used to hide:

Columns and rows only.

Complicated SQL syntax only.

Both of the above can be hidden by an SQL view.

None of the above is correct.

34.
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

A particular column in a particular underlying table.

A particular column in a particular row.

A particular row in a particular underlying table.

None of the above is correct.

35.
Which of the following is NOT a type of SQL constraint?

PRIMARY KEY

FOREIGN KEY

ALTERNATE KEY

UNIQUE

36.
A ________ is a program that performs some common action on database data and that is stored in the database.

Trigger

Stored procedure

Pseudofile

None of the above is correct.

37.
For what purposes are views used?

To hide columns only

To hide rows only

To hide complicated SQL statements only

All of the above are uses for SQL views.

38.
What is an SQL virtual table that is constructed from other tables?

Just another table

A view

A relation

Query results

39.
When using the SQL INSERT statement:

Rows can be modified according to criteria only.

Rows cannot be copied in mass from one table to another only.

Rows can be inserted into a table only one at a time only.

Rows can either be inserted into a table one at a time or in groups.

40.
What is not an advantage of stored procedures?

Greater security

SQL can be optimized

Code sharing

Increased network traffic

41.
A reason for using an SQL view to hide columns is:

To simplify a result only.

To prevent the display of sensitive data only.

To accomplish both of the above.

None of the above are reasons for using an SQL view.

42.
Which of the following is an SQL trigger supported by Oracle?

BEFORE

INSTEAD OF

AFTER

All of the above.

43.
The SQL ALTER statement can be used to:

Change the table structure.

Change the table data.

Add rows to the table.

Delete rows from the table.

44.
What SQL structure is used to limit column values of a table?

The LIMIT constraint

The CHECK constraint

The VALUE constraint

None of the above is correct.

45.
Which is NOT one of the most common types of SQL CHECK constraints?

System date

Range checks

Lists of values

Comparing one column value to another within the same table

error: You are not allowed to do so.....
0Shares
0
Scroll to Top