ITI COPA MySQL MCQ Database Concepts (DBMS) chapter’s Questions and Answers with PDF Download. Helpful for 2023 theory online CBT Exam paper preparation. These are new questions according to DGT new syllabus.
ITI COPA MySQL MCQ
1. MySQL is freely available and is open source.
a) True
b) False
c) Not sure
d) Private
Ans. a
2. What represents a ‘tuple’ in a relational database?
a) Table
b) Row
c) Column
d) Object
Ans. b
3. How is communication established with MySQL?
a) SQL
b) Network calls
c) A programming language like C++
d) APIs`
Ans. a
4. The MySQL server used in its client/server architecture is _______________
a) mysqla
b) mysqlb
c) mysqlc
d) mysqld
Ans. d
5. Which of the following clauses is used to display information that match a given pattern?
a) LIKE
b) WHERE
c) IS
d) SAME
Answer: a
6. What column names are displayed when this SQL command is executed?
SHOW COLUMNS FROM tbl_name LIKE ‘%name’;
a) suffixed with ‘name’
b) prefixed with ‘name’
c) suffixed with ‘%name’
d) prefixed with ‘%name’
Answer: a
7. The special database that always exists after setting up MySQL in a computer is __________
a) sampdb
b) mysql
c) information_schema
d) readme_db
Ans. c
8. In the following SQL code, InnoDB is __________
CREATE TABLE student (
name CHAR(30),
student_id INT,
PRIMARY KEY (student_id)
) ENGINE = InnoDB;
a) database name
b) table name
c) reference engine
d) storage engine
Ans. d
9. Identify the table name in the following SQL statement.
INSERT INTO student VALUES(‘Kyle’,’M’,NULL);
a) Student
b) Values
c) Kyle
d) M
Answer: a
10. What is ‘xyz’ in the following SQL statement?
SELECT abc FROM xyz;
a) row name
b) column name
c) table name
d) database name
Answer: c
11. Which operator is used to perform integer divisions in MySQL?
a) /
b) \
c) DIV
d) //
Answer: c
12. The NULL value also means ___________
a) value equal to zero
b) unknown value
c) negative values
d) a large value
Answer: b
13. What does comparing a known value with NULL result into?
a) zero
b) a positive value
c) a negative value
d) null
Ans. d
14. Which clause is used to sort query elements?
a) GROUP
b) GROUP BY
c) ORDER
d) ORDER BY
Ans. d
15. Which of the following options tells mysql to ask for entering the password?
a) -e
b) -p
c) -u
d) –h
Answer: b
16. What is ‘tamp’ in the following MySQL command?
mysql -h xyz.host.try.net -p -u tamp
a) user name
b) password
c) host name
d) table name
Ans. a
17. The query ‘SELECT NOW()’ shows the current _____________
a) table
b) time only
c) date only
d) date and time
Answer: d
18. Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?
a) SELECT DATABASE()
b) SELECT DATABASE sampledb
c) USE DATABASE sampledb
d) USE sampled
Answer: d
19. What does ‘abc’ & ‘xyz’ specify in the following SQL statement?
CREATE TABLE abc (xyz);
a) table name and column specs
b) column specs and table name
c) table name and number of columns
d) table name and number of rows
Ans. a
20. To see the table structure, which of the following SQL commands is issued?
a) DESCRIBE tbl_name
b) VIEW tbl_name
c) SELECT TABLE tbl_name
d) SELECT tbl_name
Ans. a
21. The command to move the cursor to the beginning of line in MySQL input editor is?
a) Ctrl-A
b) Ctrl-E
c) Ctrl-D
d) Esc-a
Answer: a
22. What does Control-_ do in MySQL input editor?
a) copies to clipboard
b) pastes from clipboard
c) undoes last change
d) deletes the current line
Ans. c
23. On UNIX, statements entered in ‘MySQL’ are saved in which file?
a) .mysql_queries
b) .queries
c) .mysql_history
d) .history
Ans. c
24. MySQL can be used to execute script files.
a) True
b) False
Ans. a
25. Suppose run_me.sh is a script file. Which command is used to make it 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
Ans. d
26. Which option prints output in table-format when MySQL is run interactively?
a) -t
b) -tf
c) -p
d) –pf
Ans. a
27. The clause that enables mapping a short command to a long command is __________
a) map
b) direct
c) label
d) alias
Answer: d
28. In UNIX, the name of the option file is __________
a) .my.cnf
b) .my.ini
c) .my.opt
d) .my.opc
Ans. a
29. In which language MySQL is written?
a) Python
b) C/C+
c) Java
d) COBOL
Ans. b
30. To see the list of options provided by MYSQL which of the following command is used?
a) HELP
b) –HELP
c) – HELP
d) ELP-
Ans. c
31. Is a semicolon necessary after every query?
a) TRUE
b) FALSE
Ans. a
32. To know your MYSQL version and current date which of the following command you should use?
a) VERSION, CURRENT_DATE();
b) SELECT VERSION, CURRENTDATE();
c) SELECT VERSION(), CURRENT_DATE;
d) SELECT VERSON(),CURRENT_DATE();
Ans. c
33. In which form MYSQL query results are displayed?
a) LIST
b) TUPLE
c) ROWS AND COLUMNS
d) LIST AND TUPLES BOTH
Ans. c
34. In MYSQL, can we write keywords in any letter case?
a) YES
b) NO
Ans. a
35. In MYSQL, can you write multiple statements in a single line?
a) YES
b) NO
Ans. a
36. If you want to stop the processing query then which of the following command you should use?
a) QUIT
b) STOP
c) /c
d) C and D both
Ans. c
37. To see all the databases which command is used?
a) Show database;
b) Show databases;
c) Show database();
d) Show_all database;
Ans. b
38. In the following statement, what do you mean by the ‘student’?
USE student;
a) Database name
b) Row name
c) Column name
d) Table name
Ans. a
39. Which of the following command is used to delete a database?
a) DELETE DATABASE_NAME;
b) DROP DATABASE_NAME;
c) DROP DATABASE DATABASE_NAME;
d) DELETE DATABASE DATABASE_NAME;
Ans. c
40. ALTER command is a type of which SQL command?
a) DML
b) DDL
c) DCL
d) DQL
Ans. b