WorksheetsRDD- Gunalakshmi
Total questions: 31
Worksheet time: 23mins
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'
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
which of the following is not a valid SQL commands?
Data Definition Language
Data Manipulation Language
Data Control Language
Data Verification Language
which of the following is not a valid SQL commands?
Data Definition Language
Data Manipulation Language
Data Control Language
Data Verification Language
ERD stands for _________.
enhance relation diagram
entity responsive diagram
entity relationship diagram
enable relationship diagram
An entity ____________.
Has cardinality (1:1, 1:N, or M:N)
Shows if it can be null or no null
Is a person, place or thing
Is described with a verb phrase
HOUSE/POSTCODE
The entity relationship set is represented in E-R diagram as
Double diamonds
Undivided rectangles
Dashed lines
Diamond
What is data model?
Simple representations of complex real-world data structures
Iterative and progressive process of creating a specific data model for a determined problem domain
Abstraction of a real-world object or event
The picture above is example of
Network Model
Hierarchical Model
Object Oriented Model
No SQL
What is the relationship shown by the above Entity Relationship Diagram(ERD)?
one-to-one
many-to-many
one-to-many
Which of the following is type of distributed DB?
Homogeneous only
Heterogeneous only
Homogeneous and Heterogeneous
None of these
What are the types fragmentation in distributed database?
Horizontal and Vertical
Range and List
Vertical and Tuple
None of these
Data replication is a
technique of breaking up the database into logical units, which may be assigned for storage at the various sites
process of deciding about locating (or placing) data to several sites
technique that permits storage of certain data in more than one site
None of these
Choose the command use in transaction
I - Start Transaction
II - Commit
III - Join
IV - Rollback
I , II , III
I , II , IV
I , III , IV
II , III , IV
SQL has how many main commands for DDL:
1
2
3
4
DDL Stands for ___________.
Data Management Language
Data Manupulation Language
Data Development Language
Data Definition Language
What is the result of the following query?
SELECT studname
FROM college
WHERE marks > SOME (SELECT marks
FROM student
WHERE SECTION = 'c');
The query gives all the studnames for which marks are greater than all the students in section c
The query gives all the studnames for which the marks are greater than at least on student in section c
The query gives all the studnames for which the marks are less than all the students in section c
The query is syntactically incorrect
In SQL, a ........... is a virtual table based on the result-set of an SQL statement
VIEW
INDEX
TRIGGER
What is database normalization?
The process of organizing data into tables and columns
The process of removing duplicate data from a database
The process of structuring a database to minimize redundancy and dependency
The process of indexing data for faster retrieval
Which of the following is not a normal form in database normalization?
First Normal Form (1NF)
Second Normal Form (2NF)
Primary Normal Form (PNF)
Third Normal Form (3NF)
Which normal form eliminates transitive dependencies?
First Normal Form (1NF)
Third Normal Form (3NF)
Second Normal Form (2NF)
Boyce-Codd Normal Form (BCNF)
