IndiaBIX.com
Arithmetic Aptitude Data Interpretation
Logical Reasoning Verbal Reasoning Non Verbal Reasoning
General Knowledge
Sudoku Number puzzles Missing letters puzzles Logical puzzles Playing cards puzzles Clock puzzles
C Programming C++ Programming C# Programming Java Programming
Microbiology Biochemistry Biotechnology Biochemical Engineering
Civil Engineering Mechanical Engineering Chemical Engineering Networking Database Questions Computer Science Basic Electronics Digital Electronics Electronic Devices Circuit Simulation Electrical Enigneering Engineering Mechanics Technical Drawing
Placement Papers Group Disucssion HR Interview Technical Interview Body Language
Aptitude Test Verbal Ability Test Verbal Reasoning Test Logical Reasoning Test C Programming Test Java Programming Test Data Interpretation Test General Knowledge Test
Data Structures Operating Systems Networking DATABASE Database Basics SQL Server Basics SQL Server Advanced SQL Server 2008 JAVA Core Java Java Basics Advanced Java UNIX Unix File Management Unix Memory Management Unix Process Managemnt C Interview Questions The C Language Basics .NET Interview Questions .NET Framework ADO.NET ASP.NET Software Testing

Database - SQL for Database Construction

@ : Home > Database > SQL for Database Construction > General Questions

Exercise

"To err is human; to forgive, divine."
- Alexander Pope
1. 

The SQL command to create a table is:
A. MAKE TABLE.
B. ALTER TABLE.
C. DEFINE TABLE.
D. CREATE TABLE.
2. 

A ________ is a stored program that is attached to a table or a view.
A. pseudofile
B. embedded SELECT statement
C. trigger
D. None of the above is correct.
3. 

The DROP TABLE statement:
A. deletes the table structure only.
B. deletes the table structure along with the table data.
C. works whether or not referential integrity constraints would be violated.
D. is not an SQL statement.
4. 

SQL views can be used to hide:
A. columns and rows only.
B. complicated SQL syntax only.
C. both of the above can be hidden by an SQL view.
D. None of the above is correct.
5. 

The SQL statement to create a view is:
A. CREATE VIEW.
B. MAKE VIEW.
C. SELECT VIEW.
D. INSERT VIEW.

Read more:

© 2008-2013 by IndiaBIX™ Technologies. All Rights Reserved | Copyright | Terms of Use & Privacy Policy

Contact us: info@indiabix.com     Follow us on twitter!