Close Menu

DWQA Questions

Refer to the following SQL statement and identify the type of query: SELECT * FROM Projects WHERE ProjectID IN (SELECT ProjectID FROM PeopleProjects);
Linux Questions asked 1 year ago • 
It is risky to use a DELETE statement without a WHERE clause because:
Linux Questions asked 1 year ago • 
Which of the following statements INCORRECTLY describes the WHERE clause?
Linux Questions asked 1 year ago • 
The following SQL command is run: UPDATE people SET LastName=”Albert”;What is the problem with this statement?
Linux Questions asked 1 year ago • 
The INSERT statement can add only one record at a time. True or False?
Linux Questions asked 1 year ago • 
Identify the correct Data Definition statement from the list below:
Linux Questions asked 1 year ago • 
In the case of a many-to-many relationship between two tables, a third table is not required to simplify the situation into two separate one-to-many relationships. True or False?
Linux Questions asked 1 year ago • 
Records represent a group of information about an object. Records are represented as _ in a database table.
Linux Questions asked 1 year ago • 
The database administrator decides to break one large employee table into two parts. The first table, employee_master, contains selected key information that does not change over time. The second table, employee_details, contains data that is considered optional. The relationship between employee_master and employee_details would most likely be a:
Linux Questions asked 1 year ago • 
One employee can work on multiple projects. Similarly, a project can have more than one employee assigned to it. This is an example of a:
Linux Questions asked 1 year ago • 
Which of the following is not an open source database program?
Linux Questions asked 1 year ago • 
SQL statements must be terminated with a:
Linux Questions asked 1 year ago • 
SQL statements must be capitalized for error-free execution. True or False?
Linux Questions asked 1 year ago • 
Data manipulation statements cannot be used for:
Linux Questions asked 1 year ago • 
The acronym SQL stands for:
Linux Questions asked 1 year ago • 
« Previous1…3839404142…115Next »
Ask Question