In SQL, which statement is used to create a new database? MCQ with Answer and Explanation

Question

Share Report Error

In SQL, which statement is used to create a new database?

A. CREATE TABLE

B. CREATE SCHEMA

C. CREATE DATABASE

D. NEW DATABASE

Answer: Option C

Solution (By JKSSB Mock Tests)

CREATE DATABASE is used to create a new database in SQL.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

What is data redundancy?

A. Absence of data

B. Encrypted data

C. Duplication of data in multiple places

D. Processed information

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data redundancy refers to unnecessary duplication of data, which DBMS helps control.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Which SQL function returns the current date and time?

A. CURDATE()

B. All of the above depending on the DBMS

C. NOW()

D. GETDATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Different DBMSs have different functions: MySQL NOW(), SQL Server GETDATE(), etc. But all return current date/time.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Candidate keys that are not selected or designated as the primary key of a table are known as what?

A. Foreign Keys

B. Alternate Keys

C. Composite Keys

D. Super Keys

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Out of all available candidate keys, the one selected to identify rows uniquely is the primary key, and the remaining unselected candidate keys are called alternate keys.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs