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