1. What
is the use of Microsoft Access?
Microsoft Access is a database management system that provides graphical user interface (GUI) tools to create and manage its database. All the queries in Microsoft Access are converted into SQL. Microsoft Access uses SQL to build reports, create lists, combo boxes, and forms that are used to accept user input.
2. What is a database engine?
A database engine is a part of an RDBMS. It acts an intermediary between the RDBMS and the database and is used to reduce the load of input/output operations on the RDBMS.
3. Why
is DDL used?
DDL uses SQL statements that are utilized for data definition tasks such ass creating tables, setting constraints in the columns of a table, and creating objects in database. A DDL compiler is a part of an RDBMS that works implicitly. The DDL statements include:
4. What
are the functions of DML?
A DML sub-language use existing database objects for retrieval and manipulation because includes executable statements that transmit data to and from a database. DML contains clauses, such as WHERE and HAVING, which enable the retrieval of data provided the specified conditions are fulfilled. Using DML you can perform tasks such as
- Insert data – INSERT
- Modify data – UPDATE
- Delete data – DELETE
- Retrieve data – SELECT
5. What
is the use of TCL statements?
TCL provides commands to recover from transaction failures. To ensure data consistency, use the COMMIT and ROLLBACK commands that enable you to confirm or decline the transactions made, respectively.
6. Which
category of SQL deals with user permissions and privileges?
DCL commands are used to grant and revoke permissions and privileges to database objects.
7. Which
SQL statement do you use to select all the columns of a table?
To select all the columns of a table a SELECT statement is used. The syntax for this SQL statement is:
SELECT *
FROM table_name
8. What
is a selection criterion for a query using the SELECT statement?
The SELECT statement allows you to specify the criteria to retrieve records. This is enabled with the WHERE and HAVING clauses.
9. Which SQL statement do you use to display all the fields of the fields of the records of the employees who are aged over 43?
SELECT * FROM Employee
WHERE iEmployeeAge > 43
10. What is the use of aggregate functions?
Aggregate functions are used to perform arithmetic operations on the values of a column or a group of columns. The result is displayed as a single value, for example Sam wants to find the lowest monthly salary in the company. This can be done using the MIN function with SQL statements:
SELECT
‘Minimum employee_salary’ = MIN(mSalary)
FROM Employee
11. What are the DATE functions?
·
GETDATE – returns the current date and time
·
DATENAME – returns the datepart from the listed date as
a character value
·
DATEADD – adds the number specified by the number
parameter to the datepart of the date specified by the date parameter
·
DATEPART – returns the datepart from the specified date
as an integer
12. What are the three string functions?
· UPPER – returns the expression after converting it to uppercase
· SPACE – returns the expression after a specified number of spaces are inserted between the first and second words
· REVERSE – returns the reverse of the string specified in character_expression
13. Which SQL statement do you use to display the
records of the table in the ascending order of names?
SELECT
* from Employees order by lastname
14. Which SQL statement do you use to display all
the records with the name David?
SELECT
* from Employees
WHERE cEmployeeFName=’David’
15. Which SQL statement do you use to display the
records of people who are aged between 35 and 40?
SELECT * FROM Employee
WHERE iEmployeeAge >=35
AND iEmployeeAge=<40
16. Which SQL statement do you use to add the new
fields, “occupation” and “name of company” to a table?
INSERT INTO
<Employee>
<(cDesignation) AND (vCompanyName)>
