DBMS MCQs - CSE MCQs Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

Index

Reference

Assertion

Timestamp

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

Which of the following is used to store movie and image files ?

Clob

Blob

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

The user defined data type can be created using

Create datatype

Create data

Create definetype

Create type

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

Values of one type can be converted to another domain using which of the following ?

Cast

Drop type

Alter type

Convert

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

Which of the following closely resembles Create view ?

Create table . . .like

Create table . . . as

With data

Create view as

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

Answer : Option B

Explanation :

Create table . . . as

The 'create table . . . as' statement closely resembles the create view statement and both are defined by using queries.The main difference is that the contents of the table are set when the table is created, whereas the contents of a view always reflect the current query result.

In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.

Catalogs, schemas

Schemas, catalogs

Environment, schemas

Schemas, Environment

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL
Share as Image
As Image

Which of the following statements creates a new table temp instructor that has the same schema as instructor.

create table temp_instructor;

Create table temp_instructor like instructor;

Create Table as temp_instructor;

Create table like temp_instructor;