Advanced SQL Questions

MCQ bookmark_border

51.

Which of the following is the right syntax for the assertion?

A

Create assertion

B

Create assertion check

C

Create assertions

D

All of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

52.

a)

A

Control who is allowed access to the data

B

Ensure that duplicate records are not entered into the table

C

Improve the quality of data entered for a specific property

D

Prevent users from changing the values stored in the table

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

53.

Which of the following can be addressed by enforcing a referential integrity constraint?

A

All phone numbers must include the area code

B

Certain fields are required

C

Information on the customer must be known before anything can be sold to that customer

D

When entering an order quantity, the user must input a number and not some text

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

54.

Dates must be specified in the format

A

mm/dd/yy

B

yyyy/mm/dd

C

dd/mm/yy

D

yy/dd/mm

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

55.

A ________ 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

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

56.

Here which one denotes the relation for which index is created?

A

StudentID_index

B

ID

C

StudentID

D

Student

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

57.

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

A

Clob

B

Blob

C

Binary

D

Image

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

58.

The user defined data type can be created using

A

Create datatype

B

Create data

C

Create definetype

D

Create type

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

59.

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

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

60.

a)

A

Value

B

Not null

C

Check

D

Check

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion