WorksheetsClass Test
Total questions: 20
Worksheet time: 15mins
Repetition of data is called data ..............
dependance
redundancy
inconsistency
isolation
Data redundancy may lead to data inconsistency.
True
False
SQL stands for
(a)
The rows in a table is also known as
degree
tuple
cardinality
domain
What is a database?
Organized collection of information that cannot be accessed, updated, and managed
Collection of data or information without organizing
Organized collection of data or information that can be accessed, updated, and managed
Organized collection of data that cannot be updated
In which of the following formats data is stored in the database management system?
Table
Image
Text
Graph
Data communications refers to the transmission of the digital data between two or more computers and a computer network.
True
False
The computer or device that is used for sending data is called____________-
Sender
Reciever
Manager
Follower
_____________ connection is a connection in which the data flow in both directions simultaneously.
Simplex Connection
Half Duplex Connection
Full Duplex Connection
All above
radio-waves, microwave, infrared, satellite and bluetooth are examples of which media?
wired
television
wireless
computer
PHP server scripts are surrounded by delimiters, which?
<script>...</script>
<?php...?>
<&>...</&>
<?php>...</?>
All variables in PHP start with which symbol?
!
$
#
@
Fill in the blanks
$conn = mysqli_connect( (a) );
What is the correct way to end a PHP statement?
;
</php>
.
New line
Which PHP function is used to execute SQL queries?
execute SQL()
mysqli_query()
pdo_query()
sql_query()
Which MySQL command is used to create a new table
CREATE DATABASE
CREATE TABLE
INSERT INTO
SELECT
Which of the following is used to establish a connection to a MySQL database?
mysqli_connect()
mysql_connect()
pdo_connect()
sql_connect()
DBA stands for
Data Admin
Database Administrator
Data Atom
None
