Practice More Questions From: Graded Assessment: Intro to databases
Q:
What is a row of information about one specific staff member in a college database table referred to as?
Q:
A sports club database includes a table called “Members” with two columns: A ‘member number’ column that contains the phone number of each memberAnd a ‘full name’ column that contains the full name of each member. Choose the right data type for each column. Select all correct answers.
Q:
In a football club the skill level of all new players must automatically be set at the default of level 1. Which SQL syntax is used to set this default level using the DEFAULT keyword?
Q:
Database constraints are used to limit the type of data value that can be stored in a table.
Q:
The output result of the following SQL statement is the data of all customers from Italy. SELECT * FROM customers WHERE Country = “Italy”;
Q:
The output result of the following SQL statement returns the records of all customers from India in Alphabetical order from A to Z. SELECT * FROM students WHERE country = “India” ORDER BY FirstName DESC;
Q:
What does the following SQL statement do? SELECT * FROM Players ORDER BY Country, PlayerName;
Q:
The following table of data conforms with the first normal form. Department ID Department Name Head of department Course ID Course Name D1 Computing Dr Karl C1 Database D1 Computing Dr Karl C2 Python D1 Computing Dr Karl C3 Web D1 Computing Dr Karl C4 Java D2 Math Dr Mosa C5 Math
Q:
Which of the following represents the correct diagram that links the course table with the department table?
Q:
Identify the relationship between the tables in the diagram.
Subscribe
0 Comments
