All India Exams
Home AptitudeBankEngineeringEnglishGKInterviewOnline TestPlacement PapersReasoning
  • Home
  • Aptitude
  • Bank
  • Engineering
  • English
  • GK
  • Interview
  • Online Test
  • Placement Papers
  • Reasoning

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.

Home EngineeringComputer Science & EngineeringDBMS Questions and AnswersData Types

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
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option B

Explanation:

yyyy/mm/dd

yyyy/mm/dd is the default format in sql

Workspace

Report Error


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.
  • A. Index
  • B. Reference
  • C. Assertion
  • D. Timestamp
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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.

Workspace

Report Error


  • «
  • 1
  • 2
  • »

Related Topics:

  • Transactions
  • Indexes
  • DBMS Keys
  • RAID
  • Constraints
  • OLAP
  • Aggregate Functions
  • Triggers
  • Views
  • Normal Forms

Mock Tests & Online Quizzes

  • Aptitude Online Test

  • Reasoning Online Test

  • GK Online Test

  • English Online Test

  • RRB Mock Test

  • RBI Mock Test

  • Free SBI Mock Test

  • IBPS Mock Test FREE

  • SSC Mock Test

  • CAT Exam Mock Test

  • GATE Mock Test

  • IT Courses Quiz

Questions and Answers

  • Aptitude Questions
  • Verbal Reasoning Questions
  • Non Verbal Reasoning
  • Logical Reasoning Questions
  • Data Sufficiency Questions
  • Data Interpretation
  • eLitmus Sample Papers
  • ECE Questions and Answers
  • EEE Questions and Answers
  • Verbal Ability Questions
  • GK Questions

Programming Quiz

  • C Programming
  • C++ Programming
  • PHP Programming
  • Java Programming
  • Python Programming
  • DataScience MCQ
  • Hadoop MCQ
  • Mongo DB MCQ
  • MySQL MCQ

Interview Questions

  • Java Interview Questions
  • .Net Interview Questions
  • Networking Interview Questions
  • C Language Interview Questions
  • C++ Interview Questions
  • Testing Interview Questions
  • Android Interview Questions
  • HR Interview Questions
  • Group Discussion Topics

Our Sites

AView.in

© by AllIndiaExams.in. All Rights Reserved | Copyright | Terms of Use & Privacy Policy