SQL – تأهب

SQL

يحدد هذا الاختبار مستوى معرفتك بـ SQL

زودنا بعلوماتك

1. Which of the following commands is used to delete all rows and free up space from a table?

DELETE

ALTER

TRUNCATE

DROP

2. Database management system (DBMS) is _____.

Software used to store, access and manipulate the data stored in the database

Software used to store the actual data

Software application used to manipulate data

Software used to store, access and manipulate the actual data

3. Which of the following is a Data Definition Language (DDL)?

ALTER

INSERT

DELETE

SELECT

4. What does the following code snippet do?

ALTER TABLE STUDENT ADD(ADDRESS VARCHAR2(20));

Checks if a column called ADDRESS is present in the table student.

Adds a column called ADDRESS in the table student.

Invalid Syntax

None of the above

5. What does DML stand for?

Data Machination Language

all of the above

Data Manipulation Language

Data Modification Language

6. ?What does SQL stand for

Structured Query Language

Single Query Language

Single Question Language

Structured Question Language

7. What command is used to create a new table in SQL?

CREATE TABLE

None of the above

BUILD TABLE

GENERATE TABLE

8. What does the following statement in SQL do?

DROP TABLE student;

Creates a table called student.

Check if there is a table called student.

None of the above.

Deletes a table called student.

9. Which one of the following is used to extract data from a database?

EXTRACT

GET

SELECT

PULL

10. Which one of the following is used to count the number of rows in a SQL query?

SUM()

NUMBER()

COUNT()

TOTAL()

11. Which of the following is used to update data (row) in a database?

UPDATE

MODIFY

ALTER

INSERT

12. Which of the following commands are a part of Data Control Language?

None of the above

Grant

Revoke

Both A and B

13. The table columns in a database are also called:

Records

Neither A nor B

Columns

Attributes

14. With MySQL, how do you select all records from a database?

SELECT # database

SELECT ALL FROM database

SELECT # FROM database

SELECT * FROM database

Your score is

خليك متأهّب!

بخطوة واحدة فقط! من خلال تزويدك لنا ببريدك الالكتروني ستكون أول المتأهّبين بالتسجيل والإعلانات وكل ما يتعلق بمعرض تأهّب، حياك الله معنا

جميع الحقوق محفوظة ,2022© تأهب