The SQL Quiz by 'The Cloud 9' assesses knowledge in SQL commands and concepts, focusing on operations like DELETE, understanding constraints, Oracle interfaces, and performance optimization. It's designed for learners to test and enhance their SQL skills effectively.
True
False
Bath correct
None
Rate this question:
1. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
2. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
3. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
4. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
Rate this question:
1. SELECT last_name, department_name FROM employees , departments(+);
2. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
3. SELECT last_name, department_name FROM employees(+) e JOIN departments d ON (e.department_id = d.department_id);
4. SELECT last_name, department_name FROM employees(+) , departments ON (e.department_id = d.department_id);
Rate this question:
1. RIS
2. CHA
3. ARRIS
4. ARR
Rate this question:
1. Indexes are only used in special cases
2. Indexes are used to make table storage more efficient
3. Indexes rarely make a difference in SQL performance
4. Indexes exist solely to improve query speed.
Rate this question:
SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);
SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat;
SELECT dept_id, job_cat, MAX(salary) FROM employees;
SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
Rate this question:
SELECT last_name, 12*salary* commission_pct FROM emp;
SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
Rate this question:
ALTER TABLE table_name ENABLE constraint_name;
ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;
ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;
ALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;
ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;
Rate this question:
A view can be created as read only.
A view can be created as a join on two or more tables.
A view must have aliases defined for the column names in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
Rate this question:
1. A DDL command and can be rolled back
2. A DML command and cannot be rolled back
3. A DDL command and cannot be rolled back.
4. A TCL command and can be rolled back
Rate this question:
ALTER TABLE students ADD PRIMARY KEY student_id;
ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
Rate this question:
You obtain the results retrieved from the public synonym HR created by the database administrator.
You obtain the results retrieved from the HR table that belongs to your schema.
You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
Rate this question:
1. Open Call Interface
2. Oracle Call Interface
3. Oracle Communication Interface
4. Oracle Connection Interface
Rate this question:
SUM(start_date)
AVG(start_date)
COUNT(start_date)
AVG(start_date, end_date)
MIN(start_date)
MAXIMUM(start_date)
GRANT select, insert, update ON student_grades TO manager;
GRANT select, insert, update ON student_grades TO ROLE manager;
GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
Rate this question:
Unique
Primary key
Not null
Foreign key
Check
Rate this question:
TIMESTAMP
INTERVAL MONTH TO DAY
INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH
TIMESTAMP WITH DATABASE TIMEZONE
Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
RDBMS And SQL Knowledge Test
Welcome to the RDBMS and SQL Knowledge Test. As you might already know, RDMS is the basis for various modern database systems such as SQL, MySQL, MS SQL Server, IBM DB2. etc. In...
Questions:
10 |
Attempts:
2765 |
Last updated:
Nov 12, 2023
|
The Ultimate SQL Syntax And Functionality Knowledge Test
Since its creation in 1974, SQL has become the most popular programming language for relational database management. With its fine set of functions and easy to learn syntax, it...
Questions:
40 |
Attempts:
429 |
Last updated:
Mar 21, 2023
|
SQL Basic! Ultimate Trivia Quiz
Dive into the basics of SQL with this Ultimate Trivia! Assess your understanding of key SQL functions like COUNT(*), MAX, and DELETE. Perfect for beginners, this quiz enhances...
Questions:
10 |
Attempts:
688 |
Last updated:
Mar 21, 2023
|
SQL Multiple Choice Questions With Answers
Are you looking for some SQL multiple-choice questions with answers to make your preparation level better for the upcoming exam? Try our quiz below and see if you know the basics...
Questions:
20 |
Attempts:
12487 |
Last updated:
Jun 17, 2024
|
Fill In The Blanks On SQL
This SQL quiz assesses key database management skills, focusing on table structure modifications, understanding of relational model constraints, and data manipulation. It's ideal...
Questions:
10 |
Attempts:
1191 |
Last updated:
Mar 21, 2023
|
Introduction To SQL True Or False Quiz
What is SQL? Have you ever used SQL programming language? Here, we have this "Introduction to SQL quiz" in the true or false format to check your knowledge regarding...
Questions:
12 |
Attempts:
2645 |
Last updated:
Aug 24, 2023
|
Wait!
Here's an interesting quiz for you.