Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 12 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

Which command is used to make a script file ‘run_me.sh’ executable?

A. chmod +e run_me.sh
B. chmod +a run_me.sh
C. chmod +y run_me.sh
D. chmod +x run_me.sh
Answer» E.
Discussion
2.

Mysql cannot be used to execute script files.

A. True
B. False
Answer» C.
Discussion
3.

In which file are the statements entered in ‘mysql’ saved?

A. .mysql_queries
B. .queries
C. .mysql_history
D. .history
Answer» D. .history
Discussion
4.

What is the table name in the following SQL code?

A. student
B. VALUES
C. Kyle
D. MView Answer
Answer» B. VALUES
Discussion
5.

What is InnoDB in the following MySQL code?

A. database name
B. table name
C. reference engine
D. storage engineView Answer
Answer» E.
Discussion
6.

What is the special database that always exists after setting up MySQL on a computer?

A. sampdb
B. mysql
C. information_schema
D. readme_db
Answer» D. readme_db
Discussion
7.

IN_WHICH_FILE_ARE_THE_STATEMENTS_ENTERED_IN_‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚Àւ§MYSQL‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ¬•_SAVED??$#

A. .mysql_queries
B. .queries
C. .mysql_history
D. .history
Answer» E.
Discussion
8.

What is the special database that always exists after setting up MySQL in a computer?

A. sampdb
B. mysql
C. information_schema
D. readme_db
Answer» D. readme_db
Discussion
9.

When relocating an individual table, the table to be relocated should be ______________

A. MyISAM
B. InnoDB
C. TRANSACTION
D. ENGINE
Answer» B. InnoDB
Discussion
10.

Before relocation of database, the server should be stopped if running.

A. True
B. False
Answer» B. False
Discussion
11.

For which of these is the startup option best suited?

A. entire data directory
B. individual database tables
C. server PID file
D. individual database directories
Answer» D. individual database directories
Discussion
12.

Symlink is an applicable relocation method for ______________

A. entire data directory
B. individual database tables
C. server PID file
D. log files
Answer» C. server PID file
Discussion