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. NEW DATABASE

B. CREATE SCHEMA

C. CREATE DATABASE

D. CREATE TABLE

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

SQL is a:

A. Declarative language

B. Procedural language

C. Machine language

D. Assembly language

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SQL is a declarative language where you specify what data you want, not how to get it.

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

Question #2

The command to modify existing records in a table is:

A. UPDATE

B. MODIFY

C. ALTER

D. CHANGE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UPDATE is the DML command used to modify data in existing rows.

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

Question #3

Which wildcard character is used with the SQL LIKE operator to represent zero, one, or multiple characters?

A. Ampersand (&)

B. Underscore (_)

C. Hash (#)

D. Percentage sign (%)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The percentage sign (%) is used as a wildcard character to match any sequence of zero or more characters in an SQL LIKE string comparison query.

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

Explore All Database Management System (DBMS) MCQs