DISE - Database with PHP

Test

(1)

Database Concepts and Working with MySQL DBMS

Descarga la versión para jugar en papel

Duplicar

Crear reto

Imprimir PDF

Sobre Test

database

mysql

php

Edad recomendada: 12 años

1 veces realizada

Creada por

Sachitra Wanninayake

Sri Lanka

Top 10 resultados

1

Jayalakshmi Rajasekaran

12 de Agosto de 2020

03:02

tiempo

35

puntuacion

¿Quieres aparecer en el Top 10 de este juego?

Inicia sesión

para identificarte.

Crea tu propio juego gratis desde nuestro creador de juegos

Crear test

Compite contra tus amigos para ver quien consigue la mejor puntuación en esta actividad

Crear reto


DISE - Database with PHPVersión en línea Database Concepts and Working with MySQL DBMS por Sachitra Wanninayake 1 A relational database consists of a collection of a Tables b Fields c Records d Keys 2 A ________ in a table represents a relationship among a set of values. a Column b Key c Row d Entry 3 The term _______ is used to refer to a row. a Attribute b Tuple c Field d Instance 4 The term attribute refers to a ___________ of a table. a Record b Column c Tuple d Key 5 For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute. a Domain b Relation c Set d Schema 6 Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time. a Instance, Schema b Relation, Schema c Relation, Domain d Schema, Instance 7 Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ a Relations, Attribute b Attributes, Relation c Tuple, Relation d Tuple, Attributes 8 Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations. a Attributes of common b Tuple of common c Tuple of distinct d Attributes of distinct 9 A domain is atomic if elements of the domain are considered to be ____________ units. a Different b Indivisbile c Constant d Divisible 10 The tuples of the relations can be of ________ order. a Any b Same c Sorted d Constant 11 What type of statement is this? a DML b DDL c VIEW d Integrity constraint 12 To remove a relation from an SQL database, we use the ______ command. a Delete b Purge c Remove d Drop table 13 An ________ is a set of entities of the same type that share the same properties, or attributes. a Entity set b Attribute set c Relation set d Entity model 14 Entity is a _________ a Object of relation b Present working model c Thing in real world d Model of relation 15 The descriptive property possessed by each entity set is _________ a Entity b Attribute c Relation d Model 16 The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is a Single valued b Multi valued c Composite d Derived 17 In the __________ normal form, a composite attribute is converted to individual attributes. a First b Second c Third d Fourth 18 Which Of The Following Is Available In MySQL: a CREATE VIEW b CREATE SCHEMA c CREATE TRIGGER d CREATE DATABASE 19 MySQLi extension stands for a insert b improved c intelligent d None of the above 20 What is the valid IP address for localhost a 127.0.0.1 b 127.0.0.2 c 127.0.0.3 d 192.168.1.1 Feedback 1 Database 2 Database 3 Database 4 Database 5 Database 6 Database 7 Database 8 Database 9 Database 10 Database 11 Database 12 Database 13 Database 14 Database 15 Database 16 Database 17 Database 18 Database 19 Database 20 Database

DISE - Database with PHPVersión en línea

Database Concepts and Working with MySQL DBMS

por Sachitra Wanninayake

A relational database consists of a collection of

Tables

Fields

Records

Keys

A ________ in a table represents a relationship among a set of values.

Column

Key

Row

Entry

The term _______ is used to refer to a row.

Attribute

Tuple

Field

Instance

The term attribute refers to a ___________ of a table.

Record

Column

Tuple

Key

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

Domain

Relation

Set

Schema

Database ____ which is the logical design of the database, and the database _ which is a snapshot of the data in the database at a given instant in time.

Instance, Schema

Relation, Schema

Relation, Domain

Schema, Instance

Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __ and course is a _

Relations, Attribute

Attributes, Relation

Tuple, Relation

Tuple, Attributes

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

Attributes of common

Tuple of common

Tuple of distinct

Attributes of distinct

A domain is atomic if elements of the domain are considered to be ____________ units.

Different

Indivisbile

Constant

Divisible

The tuples of the relations can be of ________ order.

Any

Same

Sorted

Constant

What type of statement is this?

DML

DDL

VIEW

Integrity constraint

To remove a relation from an SQL database, we use the ______ command.

Delete

Purge

Remove

Drop table

An ________ is a set of entities of the same type that share the same properties, or attributes.

Entity set

Attribute set

Relation set

Entity model

Entity is a _________

Object of relation

Present working model

Thing in real world

Model of relation

The descriptive property possessed by each entity set is _________

Entity

Attribute

Relation

Model

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

Single valued

Multi valued

Composite

Derived

In the __________ normal form, a composite attribute is converted to individual attributes.

First

Second

Third

Fourth

Which Of The Following Is Available In MySQL:

CREATE VIEW

CREATE SCHEMA

CREATE TRIGGER

CREATE DATABASE

MySQLi extension stands for

insert

improved

intelligent

None of the above

What is the valid IP address for localhost

127.0.0.1

127.0.0.2

127.0.0.3

192.168.1.1

Feedback

Database