Practice Query Languages (8) - Database Management System (DBMS)

Practise this section

9 questions

Flashcard drill
3 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does DDL stand for?
Show hintHide hint
Think about how we define the structure of something.
Question 2.
Give an example of a DML command.
Show hintHide hint
It helps you find information.
3Question 3.
What does DDL primarily deal with?
- Manipulating data
- Defining database structure
- Controlling access
Show hintHide hint
Think about the commands used to create tables.
4Question 4.
True or False: DML includes the command GRANT.
- True
- False
Show hintHide hint
Remember the type of commands DML includes.
Question 5.
You are tasked with creating a new table called 'Students' with fields for Name, Age, and Major. Write the DDL command to create this table.
Show hintHide hint
Remember how to structure your CREATE statement.
Question 6.
If a user needs permission to view the 'Employees' table, what DCL command would you use to grant them this permission?
Show hintHide hint
Focus on the command that shares access.

5 more questions in this section. Enroll free to practise them all.