Database MCQ - English
- Introduction to Database
- The Relational Model and Normalization
- Data Modeling with ER Model
- SQL for Database Construction
- Managing Multiuser Databases
- SQL Server 2000
- XML and ADO.NET
- Database Processing for BIS
- The Database Development Process
- ER Model and Business Rules
- Physical Database Design
- The Client Server Database
- Data Warehousing
- Distributed Databases
- Object Oriented Database
- Introduction to SQL
- Database Design Using Normalization
- Data Models into Database Designs
- Database Redesign
- Managing Databases with Oracle
- ODBC, OLE DB, ADO, and ASP
- JDBC, Java Server Pages, and MySQL
- The Database Environment
- Modeling Data in the Organization
- Logical Database Design
- Advanced SQL
- The Internet Database Environment
- Data and Database Administration
- Object Oriented Data Modeling
SQL for Database Construction MCQ Questions and Answers
Home | Database | SQL for Database ConstructionIn this section we provide lots of objective question of The SQL for Database Construction in Database Management System.
1) The SQL command to create a table is:
2) A ________ is a stored program that is attached to a table or a view.
3) 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.
Answer : B Discuss
4) 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 : C Discuss
5) The SQL statement to create a view is:
6) 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 : C Discuss
7) A ________ is a program that performs some common action on database data and that is stored in the database.
8) 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 : D Discuss
9) What is not an advantage of stored procedures?
10) 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 : C Discuss