Computer Science & Informatics Practices

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Unit Test II

Email *

Name of Student *

Admission No. *

JNV Distt. *

Date of Exam *

YYYY

Choose Subject *

Making some changes in the data of the existing file or adding more data is called *

1 point

Editing

Appending

Modification

Alteration

Relational database model was first proposed by *

1 point

E F Cadd

E E Codd

E F Codd

E F Codder

A Function which calls itself is called as *

1 point

Built-in

Recursion

Lambda

return

Which of the following clause avoid the duplicate? *

1 point

Distinct

Remove

Where

Group By

If List=[17,23,41,9] then List.append(83) will result *

1 point

[83,17,23,41,9]

[17,23,41,9,83]

[9,17,23,83,41]

[41,83,23,17,9]

Which of the following is not a Keyword in Python ? *

1 point

break

while

operators

continue

Which operator is also called as Comparative operator? *

1 point

Arithmetic

Logical

Assignment

Relational

The maximum length of the char columns is ____________ *

1 point

65, 535 bytes

256 bytes

255 bytes

None of the mentioned

The maximum length of the varchar columns is ____________ *

1 point

Upto 256 bytes

Upto 65, 535 bytes

Upto 65, 567 bytes

None of the mentioned

In a LIKE clause, you can could ask for any value ending in “ton” by writing *

1 point

LIKE ton$

LIKE %ton

LIKE ^.*ton$

LIKE *ton

LIKE .*ton

Which clause is used to sort the result of SELECT statement? *

1 point

SORT BY

ORDER BY

ARRENGE BY

None of the above

Which of the following ways below are the correct way to get the current date & Time? *

1 point

SELECT CURTIME();

SELECT CURDATE();

SLELCT CURRRENT_TIME()

SELECT NOW()

Can DISTINCT command be used for more than one column? *

1 point

Yes

What is a candidate key? *

1 point

Used to uniquely identify a row

Alias for primary key

Used to identify a column

Alias for foreign key

USE keyword is used to select a ____________________ *

1 point

Table

Column

Database

All of the above

A view is nothing but a _____________ table or a stored query. *

1 point

Dynamic

Real

Virtual

Static

When do we use a HAVING clause? *

1 point

To limit the output of a query

To limit the output of a query using an aggregate function only

When GROUP by is used

Both a and c above

Which type of database management system represents relations using tables?

1 point

Network DBMS

Hierachical DBMS

Relational DBMS

Object Oriented DBMS

Clear selection

What is a composite key? *

1 point

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

Which of the following SQL statements will generate an error when executed. *

CREATE DATABASE students

CREATE DATABASE students;

create database if not exists students

IF NOT EXISTS CREATE DATABASE `STUDENTS`;

The WHERE clause is mandatory when using the SELECT command *

1 point

YES

Which of the following scripts will run successfully *

1 point

SELECT customername 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;

The WHERE clause is exactly HAVING clause *

1 point

Yes

What will be the output of the following query. SELECT * FROM `sales` WHERE amount > 200 *

1 point

the query will display all the sales records with amounts starting from 200 and above

the query will display all the sales records with amounts less than 200

the query will display all the sales records with amounts greater than 200

the query will output sales records with the amount equal to 200.

What will be the output of the following query INSERT INTO students (student name) VALUE ('James Lenon'); *

1 point

a student record with the name James Lenon will be added into the students table

the above query will generate an error message.

What command is used to permanently remove a record from a database table? *

1 point

DROP

REMOVE

DELETE

CUT

Which of the following is a DDL command? *

1 point

SELECT

UPDATE

DROP

ALTER

Abhay want to remove the table STORE from the database MyStore. Which command will he use from the following: *

1 point

DELETE FROM store;

DROP TABLE store;

DROP DATABASE mystore;

DELETE store FROM mystore;

Based on the given table. What will be the output of the query: write a query to display the name, department with all female. *

2 points

SELECT * FROM TEACHER

SELECT NAME, DEPARTMENT FROM TEACHER

SELEDT NAME, DEPARTMENT FROM TEACHER WHERE GENDER='F'

SELEDT * FROM TEACHER WHERE GENDER='F'

Based on the above table, write a query to display all the record whose salary is >25000 *

2 points

SELECT * FROM TEACHER WHERE SALARY>=25000

SELECT * FROM TEACHER WHERE SALARY>25000

SELECT * FROM TEACHER WHERE SALARY>='25000'

SELECT * FROM TEACHER WHERE SALARY>'25000'

To display name, bonus for each teacher where bonus is 10%of salary. (BASED ON ABOVE TABLE) *

2 points

SELECT name, salary*0.1 AS Bonus FROM teacher;

SELECT name, salary*10 AS Bonus FROM teacher;

SELECT *, salary*0.1 AS Bonus FROM teacher;

None of the above

The term HTTP stands for? *

1 point

Hyper terminal tracing program

Hypertext tracing protocol

Hypertext transfer protocol

Hypertext transfer program

Which one of the following is not a network topology? *

0 points

Star

Ring

Bus

Peer to Peer

The term WAN stands for? *

1 point

Wide Area Net

Wide Access Network

Wide Area Network

Wide Access Net

In specific, if the systems use separate protocols, which one of the following devices is used to link two systems? *

1 point

Repeater

Gateway

Bridge

Hub

In specific, if the systems use same protocols, which one of the following devices is used to link two systems?

1 point

Repeater

Gateway

Bridge

Hub

Clear selection

A set of rules that govern all aspects of information communication is called *

1 point

Server

Internet

Protocol

OSI Mode

The amount of data that can be carried from one point to another in a given time period is called *

1 point

Scope

Capacity

Bandwidth

Limitation

What is a Firewall in Computer Network? *

1 point

The physical boundary of Network

An operating System of Computer Network

A system designed to prevent unauthorized access

A web browsing Software

A copy of your responses will be emailed to the address you provided.

Submit

Clear form

Never submit passwords through Google Forms.

reCAPTCHA

Privacy Terms

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms