Linux Certification Quiz

1

Instructions For Quiz

This Mock Test has 20 Questions
Each Question is of 1 marks so total 20 marks
Multiple Choice Questions with only ONE valid answer

2

1) A systematic collection of data stored in a central location is known as?* This field is required.

csv

Database

Flat file

Excel

3

2) Which type of database management system represents relations using tables?* This field is required.

Network DBMS

Hierachical DBMS

Relational DBMS

Object Oriented DBMS

4

3) Logic model of a database is?* This field is required.

concerned with the planning of the entire database development life cycle

concerned with the physical implementation of the database

concerned with developing the database model taking into consideration the physical implementation

concerned with developing the database model without taking into consideration the physical implementation or the DBMS

5

4) Database development lifecycle is very important to the successful implementation of a database system.* This field is required.

NO

YES

6

5) What is a composite key?* This field is required.

its is a key that is defined as the primary key in another table

it is a key that uniquely identifies a record in a database

its is an optional key and allows null values

it is a primary key that consists of more than one field that uniquely identifies a record

7

6) Which of the following is not YES regarding ER modeling.* This field is required.

ER models act as non technical communication tools

ER models increase the database developer\'s productivity

ER models can be converted into a database

ER models waste the database developer\'s time

8

7) One to many relationship can only contain multiple entries of both primary and foreign keys.* This field is required.

NO

YES

9

8) Which of the following SQL statements will generate an error when executed.* This field is required.

CREATE DATABASE students

CREATE DATABASE students;

create database if not exists students

IF NOT EXISTS CREATE DATABASE `STUDENTS`

10

9) WHERE clause is mandatory when using the SELECT command.* This field is required.

YES

NO

11

10) Which of the following scripts will run successfully?* This field is required.

SELECT customer name FROM customers;

SELECT FROM `customers` \'customer name\';

SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;

SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;

12

11) WHERE clause is exactly HAVING clause* This field is required.

NO

YES

13

12) What command is used to permanently remove a record from a database table?* This field is required.

CUT

DELETE

REMOVE

DROP

14

13) What improvements can be made to the query UPDATE students SET `contact number` = 0999;* This field is required.

The query does not need any improvements

enclose the contact number in single quotes

15

14) Clause ORDER is used to sort records in either ascending or descending order.* This field is required.

YES

NO

16

15) ASC and DESC keywords can be used in the same statement.* This field is required.

YES

NO

17

16) GROUP BY command cannot be used with aggregate functions together.* This field is required.

YES

NO

18

17) Wildcards are* This field is required.

not supported by MySQL

used to perform pattern matches

use characters such as $ to perform pattern matches

use characters such as % to perform single character matching

19

18) Which of the following is a valid aggregate function.* This field is required.

CURDATE()

COUNT

AVERAGE

MAXIMUM

20

19) Null is used as a place holder for optional fields.* This field is required.

YES

NO

21

20) UNION command is used to combine resultsets from more than one query into a single result set.* This field is required.

YES

NO