
DBMS Quiz FyCyber 14/11/23

Quiz
•
Computers
•
University
•
Hard
Shweta Dhumal
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Who is responsible for authorizing access to the database, coordinating and monitoring its use
Database programmer
System Analyst
Specialised User
DBA
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Collection of information stored in a database at a particular moment is
view
schema
instance
none of the above
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A function that has no partial functional dependencies is in _______ form
3NF
2NF
4NF
BCNF
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which command is used to remove all rows from a table ?
Delete
Remove
Truncate
Both A and B
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The statement in SQL which allows to change the definition of a table is
Alter
Update
Create
Select
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following statements contains an error?
Select * from emp where empid = 10003;
Select empid from emp where empid=10006;
Select empid from emp;
Select empid where empid=1009 and lastname = 'GELLER';
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?
DML
DDL
View
Integrity Constraint
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
DBMS E-R Diagram Quiz 2

Quiz
•
University
18 questions
Job roles in IT technical support and management

Quiz
•
11th Grade - Professi...
20 questions
DBMS Quiz

Quiz
•
University
15 questions
DBMS Day 2

Quiz
•
University
10 questions
DWDM Quiz 1

Quiz
•
University
19 questions
DBMS - Fundamentals

Quiz
•
University
20 questions
JDBC

Quiz
•
University
20 questions
Introduction To Machine Learning

Quiz
•
University
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade