Introduction to Linux II – Chapter 03 Exam Test Online 2019

The acronym SQL stands for:

Data manipulation statements cannot be used for:

SQL statements must be capitalized for error-free execution.True or False?

SQL statements must be terminated with a:

Which of the following is not an open source database program?

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:

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:

Records represent a group of information about an object. Records are represented as __________ in a database table.

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?

Identify the correct Data Definition statement from the list below:

The INSERT statement can add only one record at a time.True or False?

The following SQL command is run: UPDATE people SET LastName=”Albert”;What is the problem with this statement?

Which of the following statements INCORRECTLY describes the WHERE clause?

It is risky to use a DELETE statement without a WHERE clause because:

Refer to the following SQL statement and identify the type of query: SELECT * FROM Projects WHERE ProjectID IN (SELECT ProjectID FROM PeopleProjects);

Which of the following should be used in order to display SQL results in ascending order of age?

Which SQL statement is used to fetch data from a table in the database?

Which of the following is NOT a group value function in SQL?

What does the following SQL command output? SELECT * FROM Projects WHERE ProjectID LIKE “P*”;

Which of the following is TRUE about a primary key?

Which of the following will insert a record into a table named employee with empid and empname as columns?

Which of the following is not a valid SQL keyword or SQL clause?

Which of the following SQL clauses is used to delete data from a database table?

RDBMS stands for: