Which of the following is a is a DDL command which changes or modifies the existing structure of the database, and it also changes the schema of database objects?
Anonymous Quiz
64%
ALTER
27%
UPDATE
5%
DELETE
4%
SELECT
👍14😁7
Which of the following is a DML command used to update data in an existing database table?
Anonymous Quiz
11%
INSERT
73%
UPDATE
5%
EXISTING
12%
ALTER
👍21👌4❤1👏1
Which of the following is a DCL command used to take back permissions from the user?
Anonymous Quiz
21%
GRANT
70%
REVOKE
5%
RENAME
4%
INSERT
👍15😁3
Which of the following anomaly occur when deleting a record from a database can result in the unintentional loss of data?
Anonymous Quiz
9%
Updation
64%
Deletion
23%
Interuption
4%
Insertion
👍6
Which of the following anomalies occur when modifying data in a database can result in inconsistencies or error?
Anonymous Quiz
11%
Insertion
34%
Update
50%
Modification
5%
Deletion
🔥10😁2❤1👍1🤔1
Which of the following anomaly occurs when there is a new row inserted in the table and it creates the inconsistency in the table?
Anonymous Quiz
59%
Insertion
7%
Deletion
15%
Creation
19%
Update
👍8❤4🔥1
Which of the following is not a window function in sql?
Anonymous Quiz
6%
RANK()
22%
DENSE_RANK
62%
RN()
10%
ROW_NUMBER()
👍6
Which of the following is a virtual table based on the result-set of an SQL statement?
Anonymous Quiz
60%
View
21%
Subset
10%
Set
9%
Dictionary
❤5👍2👏2
Which of the following function converts the value of a field to uppercase in SQL?
Anonymous Quiz
4%
LCASE()
84%
UCASE()
8%
CONVERTS()
3%
VALUE()
👍4❤2
Which of the following is not LOD(Level of detail) expression in tableau?
Anonymous Quiz
26%
FIXED
19%
INCLUDE
16%
EXCLUDE
39%
CONSTANT
👍15😁4❤2🥰2
Which of the following is a python library?
Anonymous Quiz
4%
Javascript
87%
Pandas
3%
C++
6%
Tableau
👍23❤5👏2
Data Analytics
Data Analyst Roadmap 👆👆 More quality content coming soon 😄❤️
What to cover next?
Anonymous Poll
46%
SQL
38%
Python
29%
Statistics
44%
Power BI
25%
Tableau
7%
Qlik
13%
R
17%
ML/AI
30%
Excel
👍89👏10🔥9😢4🥰2❤1👎1😁1
Which of the following SQL statement is used to fetch only those Company and Country columns from Customers table where County is 'USA'?
Anonymous Quiz
21%
SELECT Company FROM Customers WHERE Country = 'USA'
63%
SELECT Company, Country FROM Customers WHERE Country = 'USA'
8%
SELECT Country FROM Customers WHERE Country = 'USA'
8%
FETCH Company, Country FROM Customers WHERE Country = 'USA'
🔥28👍25❤7👏7😁7
Data Analytics
What to cover next?
Nice to see amazing response for SQL, Power BI, Statistics, Python & Excel :)
👍47❤8👏2
Which of the following is not a window function in SQL?
Anonymous Quiz
7%
RANK()
24%
ROW_NUMBER
59%
RANKIFY()
10%
DENSE_RANK()
😁27👍16