EXAM STUDY GUIDE AND PRACTICE EXAM 2024/2025 |
ACCURATE REAL EXAM QUESTIONS WITH VERIFIED
ANSWERS | EXPERT VERIFIED FOR A GUARANTEED
PASS | LATEST UPDATE
,What is SQL? - ✔✔ANSW✔✔..SQL stands for Structured Query Language. SQL lets
you access and manipulate databases.
What can SQL do? - ✔✔ANSW✔✔..SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
Can SQL retrieve data from a database? - ✔✔ANSW✔✔..Yes, SQL can retrieve data
from a database
Can SQL execute queries against a database? - ✔✔ANSW✔✔..Yes, SQL can execute
queries against a database
Can SQL can insert records in a database? - ✔✔ANSW✔✔..Yes, SQL can insert
records in a database
Can SQL update records in a database? - ✔✔ANSW✔✔..Yes, SQL can update records
in a database
Can SQL delete records from a database? - ✔✔ANSW✔✔..Yes, SQL can delete
records from a database
Can SQL create new databases? - ✔✔ANSW✔✔..Yes, SQL can create new databases
Can SQL create new tables in a database? - ✔✔ANSW✔✔..Yes, SQL can create new
tables in a database
Can SQL create stored procedures in a database? - ✔✔ANSW✔✔..Yes, SQL can
create stored procedures in a database
Can SQL create views in a database? - ✔✔ANSW✔✔..Yes, SQL can create views in a
database
Can SQL set permissions on tables, procedures, and views? - ✔✔ANSW✔✔..Yes, SQL
can set permissions on tables, procedures, and views
, What is RDBMS? - ✔✔ANSW✔✔..RDBMS stands for Relational Database
Management System.
What is the Basis of SQL? - ✔✔ANSW✔✔..RDBMS is the basis for SQL, and for all
modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and
Microsoft Access.
Where is the data stored in RDBMS? - ✔✔ANSW✔✔..The data in RDBMS is stored in
database objects called tables.
What is a table? - ✔✔ANSW✔✔..A table is a collection of related data entries and it
consists of columns and rows.
Are SQL queries case sensitive? - ✔✔ANSW✔✔..SQL keywords are NOT case
sensitive
Is select is the same as SELECT in SQL? - ✔✔ANSW✔✔..Yes, select is the same as
SELECT since SQL is not case sensitive
What is the function of the Semicolon in SQL? - ✔✔ANSW✔✔..Semicolon is the
standard way to separate each SQL statement in database systems that allow more
than one SQL statement to be executed in the same call to the server.
Can you have more than one statement to be executed in the same call to the server? -
✔✔ANSW✔✔..Yes, but a semicolon is needed to separate each SQL Statement.
What are the four basic functions of persistent storage? - ✔✔ANSW✔✔..The four basic
functions of persistent storage can be defined by acronym CRUD
What is CRUD? - ✔✔ANSW✔✔..Create, Read/Retrieve (Select), Update and Delete are
the four basic functions of persistent storage.
What does the C in CRUD stand for? - ✔✔ANSW✔✔..Create, C in CRUD, stand for
Create and is on of the four basic functions of persistent storage.
What does the R in CRUD stand for? - ✔✔ANSW✔✔..Read/Retrieve (Select), R in
CRUD, stand for Read/Retrieve (Select) and is on of the four basic functions of
persistent storage.
What does the U in CRUD stand for? - ✔✔ANSW✔✔..Update, U in CRUD, stands for
Update and is on of the four basic functions of persistent storage.
What does the D in CRUD stand for? - ✔✔ANSW✔✔..Delete, D in CRUD, stands for
Delete and is on of the four basic functions of persistent storage.