Menu

Question Discussion & Solution

MCQ

Q.

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

A

create table temp_instructor

B

Create table temp_instructor like instructor

C

Create Table as temp_instructor

D

Create table like temp_instructor

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

a)

A

Value

B

Not null

C

Check

D

Check

Discussion

MCQ

2.

Here the tuples are selected from the view.Which one denotes the view.

A

Course_id

B

Watson

C

Building

D

physics_fall_2009

Discussion

MCQ

3.

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

Discussion

MCQ

4.

Which of the following is the syntax for views where v is view name?

A

Create view v as

B

Create

C

Create view v as

D

Create view

Discussion

MCQ

5.

. Which one of the following is not true for a view:

A

View is derived from other tables.

B

View is a virtual table.

C

A view definition is permanently stored as part of the database.

D

View never contains derived columns.

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs