DATABASE TECHNOLOGY

Introduction to SQL with some Database Concepts

This Test will cover introduction to SQL and some Database concepts related to Tables and Data.

Q. The language used in application programs to request data from the DBMS is referred to as the?
Q. A logical schema _______ .
Q. In SQL, which command is used to change a table's storage characteristics?
Q. In SQL, which of the following is not a data definition language commands?

Q. What is the maximum allowed field size for Boolean (Yes/No) fields?
Q. Which of the following field type can store maximum data?
Q. In an E-R diagram an entity set is represent by a _______ .
Q. A report generator is used to _______ .
Q. The property/properties of a database is/are :

Q. The DBMS language component which can be embedded in a program is _______ .
Q. What is the full form for SQL?
Q. One of the relational model feature is that, there _______ .
Q. Which of the following key is used to identify each row uniquely?
Q. The method in which records are physically stored in a specified order according to a key field in each record is _______?
Q. What are two basic types of functions in SQL?

SUBMIT TEST