SQL Quizzes, Questions & Answers

Recent Quizzes

SQL is a language used in programming for managing data held in a relational database management system. T-SQL, on the other hand, is Microsoft's and Sybase's version. How well do you understand these two? Find out...

Questions: 10 | Attempts: 302 | Last updated: Mar 20, 2023

Sample Question
You can fetch only one row at a time.

True

False

Sybase Quiz :: 2

Sybase Quiz :: 2 tests knowledge on SQL commands, sorting results, logical operators, and stored procedures in Sybase. It evaluates understanding of SELECT, ORDER BY, AND operator, and execution of stored procedures, essential...

Questions: 10 | Attempts: 428 | Last updated: Mar 17, 2023

Sample Question
Which SQL command is used to extract data from tables?

EXTRACT

SELECT

FIND

None of above

Sybase Quiz :: 1

Sybase Quiz :: 1 assesses knowledge on Sybase-specific SQL operations, including temp table indexing, remote stored procedure execution, and string manipulation functions. It evaluates understanding of data types and procedure...

Questions: 5 | Attempts: 473 | Last updated: Mar 20, 2023

Sample Question
Can Index be created on temp tables?

Yes

No

T-SQL And General SQL: Unit 1 - Introduction To SQL Queries

T-SQL and General SQL: Unit 1 - Introduction To SQL Queries

This introductory quiz on T-SQL and SQL queries tests knowledge of data insertion, date formats, and query execution in SQL Server Management Studio. It assesses understanding of case sensitivity in queries and the use of SQL...

Questions: 26 | Attempts: 244 | Last updated: Mar 20, 2023

Sample Question
T-SQL: You have a table with a colum entitled 'job', whose values are all lower case. If you execute the following query: SELECT ename, job, deptno FROM dbo.emp WHERE job = 'CLERK' you will not get any results back buecase the match is case sensitve and so because all values of the 'job' colum are lowercase, uppercase 'CLERK' will not be found.

True

False

Oracle Mock 3

ORACLE MOCK 3

ORACLE MOCK 3 is designed to assess skills in SQL and Oracle database management, covering SQL*Plus features, query formulation, view modification, and constraints. This quiz is ideal for learners aiming to enhance their database...

Questions: 34 | Attempts: 545 | Last updated: Mar 22, 2023

Sample Question
Which /SQL*Plus feature can be used to replace values in the WHERE clause?

Substitution variables

Replacement variables

Prompt variables

Instead-of variables

This feature cannot be implemented through /SQL*Plus.

SQL Course 1 70-431

This quiz assesses advanced skills in managing and querying databases using SQL Server 2005. It covers topics such as linked servers, protocol configurations, and optimization techniques, essential for database administrators and...

Questions: 19 | Attempts: 150 | Last updated: Aug 23, 2024

Sample Question
Your application must access data that is located on two SQL Server 2005 computers. One ofthese servers is named SQL1 and the other is SQL2. You have permissions to create a storedprocedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 byusing the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. What should you do?

Join the two servers by using the four-part syntax of server.database.schema.table.

Reference SQL2 by using an alias.

Add SQL2 as a remote server to SQL1.

Add SQL2 as a linked server to SQL1.

Quiz Me SQL

Questions regarding sql server 2005. mainly from stored procedures, triggers and indexes.

Questions: 44 | Attempts: 883 | Last updated: Mar 22, 2023

Sample Question
Which of the following statemens are true?

Procedures and functions must return values

Procedures and functions may return value

Procedures may return values

Functions must return values

Access & SQL - Quiz 1

This quiz consists of 10 questions. You have 10 minutes to take the quiz.

Questions: 15 | Attempts: 201 | Last updated: Mar 21, 2023

Sample Question
Which of the following is NOT one of the three phases for Database Design phase?

A) Global Database Design

B) Conceptual Database Design

C) Logical Database Design

D) Physical Database Design

Oracle_test7

Oracle_Test7

This test is used to test your skills in joins , functions

Questions: 20 | Attempts: 681 | Last updated: Mar 21, 2023

Sample Question
You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?

SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);

SELECT last_name, department_name FROM employees JOIN departments(+);

SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d

SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);

Test Your Ddl And Dml Knowledge

Test Your DDL And DML Knowledge

Are you an avid coder? We have a special Oracle quiz for you! Test your DDL and DML Knowledge with this super informative, interesting quiz! We are here to challenge your knowledge! Let's see how well you perform in this...

Questions: 10 | Attempts: 4057 | Last updated: Mar 13, 2024

Sample Question
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table?

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

INSERT INTO employees VALUES ('1000','JOHN','NULL');

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

« Previous 1 2 3 456 Next »