Menu

Question Discussion & Solution

MCQ

Q.

In SQL, the CREATE TABLE is used

A

to create a table, defining its columns, integrity constrains, and storage allocation

B

to add a column/integrity constraint to a table

C

to redefine a column

D

to change a table's storage characteristics

E

All of the above

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.

Data item characteristics that are important in data management include

A

punctuation

B

language

C

spelling

D

width

E

None of the above

Discussion

MCQ

2.

Sophisticated report generators can

A

print row-oriented reports

B

perform arithmetic operations

C

selectively retrieve and print portions of a list

D

All of the above

E

None of the above

Discussion

MCQ

3.

You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .

A

user data

B

metadata

C

A report

D

indexes

Discussion

MCQ

4.

Data security threats include

A

hardware failure

B

privacy invasion

C

fraudulent manipulation of data

D

All of the above

E

None of the above

Discussion

MCQ

5.

In SQL, which command is used to select only one copy of each set of duplicable rows

A

SELECT DISTINCT

B

SELECT UNIQUE

C

SELECT DIFFERENT

D

All of the above

E

None of the above

Discussion

More Computer Fundamentals Topics

Data Communication and Networking

522 MCQs

Miscellaneous or General

716 MCQs

Computer Basics

115 MCQs

Computer Softwares

58 MCQs

History and Generations

29 MCQs

CPU and its components

61 MCQs

Computer Languages

58 MCQs

Computer Hardware

336 MCQs

Input Devices

24 MCQs

Output Devices

23 MCQs

Computer Memory

132 MCQs

Digital Logic Gate

2 MCQs

Number System

37 MCQs

Computer Codes

28 MCQs

Operating System

536 MCQs

Disk Operating System (DOS)

211 MCQs

Database Systems

153 MCQs

Computer Security and Viruses

32 MCQs

Mixed

13 MCQs

Computer Awareness

115 MCQs

Files and its types

0 MCQs