WorksheetsWildcard1
Total questions: 84
Worksheet time: 14mins
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
Which type of data can be stored in the database?
Image oriented data
Text, files containing data
Data in the form of audio or video
All of the above
Which of the following is not an example of DBMS?
MySQL
Microsoft Acess
IBM DB2
Which of the following is not a feature of DBMS?
Minimum Duplication and Redundancy of Data
High Level of Security
Single-user Access only
Support ACID Property
Which of the following is known as a set of entities of the same type that share same properties, or attributes?
Relation set
Tuples
Entity set
Entity Relation model
What does an RDBMS consist of?
Collection of Records
Collection of Keys
Collection of Tables
Collection of Fields
______________ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
_______ indicates the maximum number of entities that can be involved in a relationship.
Greater Entity Count
Minimum cardinality
Maximum cardinality
ERD
Which of the following is the view level database model
ER model
Relational Model
Table
File
Which of the following is not Unary operation?
Select
Project
Rename
Union
The operation which is not considered a basic operation of relational algebra is
Cross Product
Selection
Union
None of the above
Relational Algebra is a __________ query language that takes two relation as input and produces another relation as output of the query.
Relational
Structural
Procedural
Fundamental
A list of the attributes we wish to appear in the result is displayed in ___ operation.
Select
Project
Union
Rename
If there are 2 types of tuples, A & B, the ___ operation contains all the tuples that are either in A or B or both in A & B.
Project
Select
Union
Rename
In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Parent
Child
Instance
Subtype
.
In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Composite Relationship
Let E, and E’ be two entities in an ER diagram with simple single-valued attributes, R1 and R2 are two relationships between E and E’ where R1, is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model.
2
3
4
5
Consider the following relation schema pertaining to a student database:
Student (rollno, name, address)
Enroll (rollno, courseno, coursename)
where the primary keys are shown underlined. The number of tuples in the student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum number of tuples that can be present in (Student Enroll), where denotes natural join?
8 , 8
120 , 8
960 , 8
960 , 180
Properties that describes the characteristics of the entities are called ................
Entities
Identifiers
Attributes
Relationships
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema
CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?
DML
DDL
View
Integrity constraint
The SQL used by front-end application programs to request data from the DBMS is called _______
A. DML
B .DDL
C .VDL
D. SDL
The command used to delete a particular column in a relation is ____________
A.UPDATE TABLE
B.TRUNCATE COLUMN
C.ALTER , DROP
D.DELETE COLUMN
What is the full form of DDL ?
A.Dynamic Data Language
B.Detailed Data Language
C.Data Definition Language
D.Data Derivation Language
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. All of the above
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
The database definition or descriptive information is also stored by the DBMS in the form of a _______________
Data catalog
excel file
document file
pdf file
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
Which statement is used to extract data from a database?
Extract
Get
Open
Select
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
How do we select all rows for the "Designer" table?
SELECT * FROM Designer
SELECT [All] FROM Designer
SELECT Designer.*
SELECT FROM Designer
DDL means
(a)
DML
(a)
It is a DML command that is used to display record.
DISPLAY
STRUCTURE
WHERE
SELECT
Where does the CREATE Command belong?
DML
DDL
DCL
An SQL command used to create a table.
Insert
Create
Update
Add
What is the meaning of DCL?
Data Count Language
Database Control Language
Data Calculation Language
Data Control Language
What does SQL stand for?
Structured Query Language
Strong Question Language
Structured Question Language
Strong Query Language
Which SQL statement is used to extract data from a database?
OPEN
SELECT
EXTRACT
GET
Which SQL statement is used to delete data from a database?
DELETE
COLLAPSE
DROP
REMOVE
Which SQL statement is used to update data in a database?
MODIFY
SAVE AS
SAVE
UPDATE
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
SELECT FirstName FROM Persons
SELECT Persons.FirstName
SELECT Persons Where FirstName
SELECT Persons From FirstName
Which SQL statement is used to insert new data in a database?
ADD RECORD
INSERT INTO
ADD NEW
INSERT NEW
With SQL, how do you select all the columns from a table named "Persons"?
SELECT [all] FROM Persons
SELECT Persons
SELECT * FROM Persons
SELECT Persons From Persons
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
SELECT * FROM Persons WHERE FirstName<>'Peter'
SELECT * FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
True
False
Both A and B
None of these
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
SELECT FirstName='Peter', LastName='Jackson' FROM Persons
SELECT*FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'
With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT [all] FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
With SQL, how can you insert a new record into the "Persons" table?
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
INSERT INTO Persons VALUES
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
INSERT INTO Persons (LastName) VALUES ('Olsen')
INSERT ('Olsen') INTO Persons (LastName)
INSERT INTO Persons ('Olsen') INTO LastName
INSERT IN Persons ('Olsen') TO LastName
Which operator is used to select values within a range?
WITHIN
RANGE
ORDER BY
BETWEEN
Which SQL statement is used to create a database table called 'Customers'?
CREATE TABLE Customers
CREATE DATABASE TABLE Customers
CREATE DATABASE TAB Customers
CREATE DB Customers
which of the following is not a valid SQL commands?
Data Definition Language
Data Manipulation Language
Data Control Language
Data Verification Language
Which is not a DDL Command?
CREATE
ALTER
DROP
UPDATE
Which is not a DML Command?
SELECT
INSERT
ALTER
DELETE
Which of the following is not a valid SQL type?
DECIMAL
NUMERIC
FLOAT
CHARACTER
Which of the following are DCL commands?
COMMIT and ROLLBACK
UPDATE and TRUNCATE
GRANT and REVOKE
SELECT and UPDATE
The language used application programs to request data from the DBMS is referred to as __________
DDL
DML
Query Language
All of the mentioned
Match SQL language with SQL commands
1)DDL i)Revok, Grant
2)DML ii)rename a table
3)TCL iii)insert, update
4)DCL iv)rollback , commit
1-iii,2-i,3-ii,4-iv
1-iii,2-ii,3-iv,4-i
1-ii,2-iii,3-iv,4-i
1-i,2-iii,3-ii,4-iv
Which of the following is not a type of SQL statement?
Data Manipulation Language (DML)
Data Definition Language (DDL)
Data Control Language (DCL)
Data Communication Language (DCL)
In existing table, ALTER TABLE statement is used to
Add columns
Add constraints
Delete columns
Delete constrains
All the above
SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)
DELETE FROM table_name;
DELETE TABLE table_name;
DROP TABLE table_name;
None
Correct syntax query syntax to drop a column from a table is
DELETE COLUMN column_name;
DROP COLUMN column_name;
ALTER TABLE table_name DROP COLUMN column_name;
None is correct.
SQL has how many main commands for DDL:
1
2
3
4
Which command is used for removing a table and all its data from the database:
Create command
Drop table command
Alter table command
All of the mentioned
Which of the following language is used to specify database Schema ?
DDL
DML
DCL
None
DDL Stands for ___________.
Data Management Language
Data Manupulation Language
Data Development Language
Data Definition Language
SQL is
Structured Query Language
Simple Query Language
Structured Question Language
Structure Quality Language
DDL means
(a)
DML
(a)
To remove a record from a table which SQL statement would you use?
Remove
Cancel
Delete
Eradicate
In order to modify data in a database we would use which SQL statement?
Update
Amend
Alter
Modify
Which statement is used to extract data from a database?
Extract
Get
Open
Select
Which statement allows us to add a record to a table?
Add To
Update To
Add Into
Insert Into
Less than or equal to?
>=
=>
=<
<=
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
Which SQL statement would add a record to the database?
INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer
INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer
INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
Where does the CREATE Command belong?
DML
DDL
DCL
It is a DML command that is used to display record.
DISPLAY
STRUCTURE
WHERE
SELECT
Referential Integrity is
System of rules
System of data
Table constraints
is related to Primary key
______________ constraint prevents NULL values
UNIQUE
NOT NULL
NULL
FOREIGN KEY
A primary key can be NULL in the table? TRUE or FALSE
TRUE
FALSE
