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.
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.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
33. The SQL statement to create a view is:
CREATE VIEW.
MAKE VIEW.
SELECT VIEW.
INSERT VIEW.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
35. Which of the following is NOT a type of SQL constraint?
PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
40. What is not an advantage of stored procedures?
Greater security
SQL can be optimized
Code sharing
Increased network traffic
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
42. Which of the following is an SQL trigger supported by Oracle?
BEFORE
INSTEAD OF
AFTER
All of the above.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question