Data Types Questions And Answers

Here you can find Data Types Questions and Answers.

Why Data Types Questions and Answers Required?

In this Data Types Questions and Answers section you can learn and practice Data Types Questions and Answers to improve your skills in order to face technical inerview conducted by organisations. By Practicing these interview questions, you can easily crack any Exams interview.

Where can I get Data Types Questions and Answers?

AllIndiaExams provides you lots Data Types Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Data Types Questions and Answers as PDF files and eBooks.

How to solve these Data Types Questions and Answers?

You no need to worry, we have given lots of Data Types Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Competitive Exams interview.

Data Types Questions and Answers

1. This set of Database Questions & Answers focuses on â€œSQL Data Types and Schemasâ€ Dates must be specified in the format

Data Types Questions and Answers

2. 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.

Data Types Questions and Answers

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

Data Types Questions and Answers

4. The user defined data type can be created using

Data Types Questions and Answers

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

Data Types Questions and Answers

6. Which of the following closely resembles Create view ?

Data Types Questions and Answers

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

Data Types Questions and Answers

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

DBMS Data Types Questions and Answers

This is the DBMS questions and answers section on "Data Types" with explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.

DBMS Data Types Questions

Online Test Name	DBMS Data Types
Exam Type	Multiple Choice Questions
Category	Computer Science Engineering Quiz
Number of Questions	08

1. This set of Database Questions & Answers focuses on "SQL Data Types and Schemas

Dates must be specified in the format

A. mm/dd/yy
B. yyyy/mm/dd
C. dd/mm/yy
D. yy/dd/mm

Answer & Explanation

Answer: Option B

Explanation:

yyyy/mm/dd

yyyy/mm/dd is the default format in sql

Workspace

Report Error

A. Index
B. Reference
C. Assertion
D. Timestamp

Answer & Explanation

Answer: Option A

Explanation:

Index

Index is the reference to the tuples in a relation.

Workspace

Report Error

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

A. Clob
B. Blob

Answer & Explanation

Answer: Option B

Explanation:

Blob

SQL therefore provides large-object data types for character data (clob) and binary data (blob). The letters "lob in these data types stand for "Large OBject.

Workspace

Report Error

4. The user defined data type can be created using

A. Create datatype
B. Create data
C. Create definetype
D. Create type

Answer & Explanation

Answer: Option D

Explanation:

Create type

The create type clause can be used to define new types.Syntax : create type Dollars as numeric(12,2) final; .

Workspace

Report Error

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

A. Cast
B. Drop type
C. Alter type
D. Convert

Answer & Explanation

Answer: Option A

Explanation:

Cast

Example of cast :cast (department.budget to numeric(12,2)). SQL provides drop type and alter type clauses to drop or modify types that have been created earlier.