Questions

Select category
Refer to the following SQL statement and identify the type of query: SELECT * FROM Projects WHERE ProjectID IN (SELECT ProjectID FROM PeopleProjects);
OpenLinux Questions asked 2 years ago • 
31 views0 answers0 votes
It is risky to use a DELETE statement without a WHERE clause because:
OpenLinux Questions asked 2 years ago • 
28 views0 answers0 votes
Which of the following statements INCORRECTLY describes the WHERE clause?
OpenLinux Questions asked 2 years ago • 
26 views0 answers0 votes
The following SQL command is run: UPDATE people SET LastName=”Albert”;What is the problem with this statement?
OpenLinux Questions asked 2 years ago • 
28 views0 answers0 votes
The INSERT statement can add only one record at a time. True or False?
OpenLinux Questions asked 2 years ago • 
30 views0 answers0 votes
Identify the correct Data Definition statement from the list below:
OpenLinux Questions asked 2 years ago • 
29 views0 answers0 votes
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?
OpenLinux Questions asked 2 years ago • 
25 views0 answers0 votes
Records represent a group of information about an object. Records are represented as _ in a database table.
OpenLinux Questions asked 2 years ago • 
27 views0 answers0 votes
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:
OpenLinux Questions asked 2 years ago • 
25 views0 answers0 votes
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:
OpenLinux Questions asked 2 years ago • 
30 views0 answers0 votes
Which of the following is not an open source database program?
OpenLinux Questions asked 2 years ago • 
27 views0 answers0 votes
SQL statements must be terminated with a:
OpenLinux Questions asked 2 years ago • 
27 views0 answers0 votes
SQL statements must be capitalized for error-free execution. True or False?
OpenLinux Questions asked 2 years ago • 
29 views0 answers0 votes
Data manipulation statements cannot be used for:
OpenLinux Questions asked 2 years ago • 
34 views0 answers0 votes
The acronym SQL stands for:
OpenLinux Questions asked 2 years ago • 
35 views0 answers0 votes
« Previous1…3839404142…115Next »
Ask Question