Dbms basic sql operation

A level that describes how a record is stored.

• Physical

• Logical

• User

• View

A logical structure of the database.

• Schema

• Attribute

• Relation

• Instance

The actual content in the database at a particular point.

• Attribute

• Instance

• Parameter

• Relation

Sql is ________

• Relation

• Hierarchical

• IMS

• Networks

Which of the following is not a built in aggregate function in SQL?

• Avg

• Total

• Count

• Max

State true or false: SQL does not permit distinct with count(*)

• True

• False

Which command is used to create a new relation in SQL

• a) create table( , …)

• b) create relation( , …)

• c) new table( , …)

• d) new relation( , …)

What is the command used to define view in SQL?

• a) define view

• b) new view

• c) create view

• d) none of the mentioned

What is the approximate storage capacity of CDs in MB

• 1000

• 700

• 500

• 300

State true or False: Variable length records cannot be implemented

• True

• False