SQL Quizzes, Questions & Answers

Recent Quizzes

Chapter 5: Creating And Managing Tables Using Proc SQL

Chapter 5: Creating and Managing Tables Using PROC SQL

Practice for the SAS advance certification exam

Questions: 10 | Attempts: 104 | Last updated: Dec 5, 2023

Sample Question
Which of the following PROC SQL steps creates a new table by copying only the column structure (but not the rows) of an existing table?

proc sql; create table work.newpayroll as select * from sasuser.payrollmaster;

proc sql; create table work.newpayroll like sasuser.payrollmaster;

proc sql; create table work.newpayroll copy sasuser.payrollmaster;

proc sql; create table work.newpayroll describe sasuser.payrollmaster;

Chapter 4: Combining Tables Vertically Using Proc SQL

Chapter 4: Combining Tables Vertically Using PROC SQL

Practice for the SAS advance certification exam

Questions: 10 | Attempts: 183 | Last updated: Mar 22, 2023

Sample Question
Which statement is false with respect to a set operation that uses the EXCEPT, UNION, or INTERSECT set operator without a keyword?

Column names in the result set are determined by the first table.

To be overlaid, columns must be of the same data type.

To be overlaid, columns must have the same name.

By default, only unique rows are displayed in the result set.

Chapter 3. Combining Tables Horizontally Using Proc SQL

Chapter 3. Combining Tables Horizontally Using PROC SQL

Practice for the SAS advance certification exam.

Questions: 10 | Attempts: 158 | Last updated: Aug 23, 2024

Sample Question
A Cartesian product is returned when

Join conditions are not specified in a PROC SQL join.

Join conditions are not specified in a PROC SQL set operation.

More than two tables are specified in a PROC SQL join.

The keyword ALL is used with the OUTER UNION operator.

Chapter 1: Performing Queries Using Proc SQL

Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system or for stream processing in a relational data stream management...

Questions: 10 | Attempts: 601 | Last updated: Mar 21, 2023

Sample Question
Which of the following clauses in the PROC SQL program below is written incorrectly? proc sql; select style sqfeet bedrooms from choice.houses where sqfeet ge 800;

SELECT

FROM

WHERE

Both a and c

Ms SQL Server Proficiency Exam

MS SQL Server Proficiency Exam

Welcome to our MS SQL Server Quiz! This quiz is designed to challenge your expertise and enhance your understanding of Microsoft SQL Server, one of the most popular relational database management systems. Whether you are a...

Questions: 15 | Attempts: 622 | Last updated: May 8, 2024

Sample Question
Select the correctly formed SQL Statement from the below choices.

INSERT ('1','Sam' INTO (ID,Name) USING People

INSERT INTO People ('1','Sam') VALUES (ID, Name)

INSERT INTO People (ID, Name) VALUES (@@IDENTITY,'Sam')

INSERT INTO People SET ID=1, Name='Sam'

SQL Training Jan13 - Quiz1

Test your basic database skills, RDBMS, DDL, DML, Normalization etc.

Questions: 21 | Attempts: 260 | Last updated: Sep 16, 2024

Sample Question
A Multidimensional Cube is a type of a relational database

True

False

The Ultimate Server Query Language Quiz

A server query language is designed so that users can retrieve specific information from a database. As a software developer, you should have some knowledge of the use of such languages. Do you believe you understand SQL...

Questions: 42 | Attempts: 12868 | Last updated: Mar 22, 2023

Sample Question
Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

SQL Table: Trivia Questions!

The trivia questions below are on the SQL table. Basically we know the definitaion and basic interpretation of SQL. However, are you sure you have what it takes to take up more than just the basics? In a bit, we are going to...

Questions: 7 | Attempts: 590 | Last updated: Mar 21, 2023

Sample Question
To make a PARAMETER mandatory, we use the OBLIGATORY option

True

False

SQL Quiz 2: Functions

SQL QUIZ 2: Functions

Functions(Char,Concat,Substr etc) Date Functions Numeric Functions(Sum,Avg etc) Usage of group by and Having with aggregate functions Use of IFNull and Coalease functions Case expression

Questions: 10 | Attempts: 1430 | Last updated: Mar 21, 2023

Sample Question
Which one of the following queries will select the Number of Unique Departments from the Department Table below Department Number Employee Number 11 248525 11 267712 12 112456 11 234567 13 661231

Select count(*) from Department_Table

Select count(distinct DepartmentNumber) from Department_Table having distinct DepartmentNumber

Select count(distinct DepartmentNumber) from Department_Table

Select distinct departmentNumber from Department_Table

SQL: Hardest Trivia Quiz On Relational Database!

SQL: Hardest Trivia Quiz on Relational Database!

Questions: 60 | Attempts: 337 | Last updated: Mar 22, 2023

Sample Question
In backtracking search, the most-constrained-variable and most-constraining variable strategies are used to

Perform forward checking

Decide what order should the values be tried for a variable

Detect inevitable failure early

Decide which variable should be assigned next

What You Know About SQL ?

what you know about sql ???

Questions: 10 | Attempts: 134 | Last updated: Apr 16, 2024

Sample Question
What does SQL stand for?

Strong Question Language

Structured Query Language

Structured Question Language

Modern Database Systems SQL Quiz

modern database systems sql quiz

This Quiz is all about testing the basics skills in SQL.It covers SQL Server architecture, tools, security and datatypes, Implementing data integrity, subqueries, joins and T-SQL Enhancements.

Questions: 30 | Attempts: 1825 | Last updated: Mar 22, 2023

Sample Question
The primary - foreign key relations are used to

Cross-reference database tables

To index the database.

Clean-up the database

SQL Complete Test 2008

sql complete test 2008

Final test for sql server 2008 .... all the best ....

Questions: 73 | Attempts: 287 | Last updated: Mar 17, 2023

Sample Question
How do XML instances work with respect to a computed column?

A computed columns can have XML instances as a source as well as a type

Computed columns can have XML instances only as a source

Computed columns can have a XML instancesonly as a type.

Computed columns cannot have XML instances

SQL Interview Questions And Answers

SQL interview questions and answers

SQL is modern database system, which is used in programming and designed for managing data. Take this quiz and learn more about it!

Questions: 27 | Attempts: 399 | Last updated: Sep 6, 2023

Sample Question
"Consider the following statement: Select title_id, price, type from titles where price > dbo.AverageBookPrice('comp_science') What kind of a User Defined Function is used in the above statement?"

A) Scalar function

B) In-line table valued function

C) Multi-statement table valued function

D) None of the listed options

SQL Data Base 2

Questions: 25 | Attempts: 203 | Last updated: Mar 19, 2023

Sample Question
SQL < select name ,sal from Emp where name like m%;

True

False

SQL Exam: Trivia Questions! Quiz

SQL Exam: trivia questions quiz! The structured query language is designed to help a programmer manipulate databases. It helps in retrieval and editing of data from the database with ease. This computer language is one of the...

Questions: 25 | Attempts: 616 | Last updated: Mar 20, 2023

Sample Question
SQL < select name ,sal from Emp where name like m%;

True

False

SQL Technology Quiz: Can You Solve?

SQL Technology quiz: can you solve?

SQL is the standard and acceptable language for storing, manipulating and retrieving data in databases. This technology helps the specialists in undertaking their work. How good are you with different SQL concepts? Find out...

Questions: 20 | Attempts: 142 | Last updated: Aug 7, 2024

Sample Question
You can add a row using SQL in a database with which of the following?

ADD

CREATE

INSERT

MAKE

SQL Quiz-2 By "The Cloud9"

SQL Quiz-2 by "The Cloud9"

Questions: 16 | Attempts: 468 | Last updated: Mar 20, 2023

Sample Question
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHARD2(25) LAST_NAME VARCHARD2(25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which UPDATE statement is valid?

UPDATE new_employees SET name = (Select last_name|| first_name FROM employees Where employee_id =180) WHERE employee_id =180;

UPDATE new_employees SET name = (SELECT last_name||first_name FROM employees) WHERE employee_id =180;

UPDATE new_employees SET name = (SELECT last_name|| first_name FROM employees WHERE employee_id =180) WHERE employee_id =(SELECT employee_id FROM new employees);

UPDATE new_employees SET name = (SELECT last name|| first_name FROM employees WHERE employee_id= (SELECT employee_id FROM new_employees)) WHERE employee_id =180;

SQL Quiz By "The Cloud 9"

SQL Quiz by "The Cloud 9"

Questions: 18 | Attempts: 275 | Last updated: Mar 21, 2023

Sample Question
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

1. DELETE ROW FirstName='Peter' FROM Persons

2. DELETE FirstName='Peter' FROM Persons

3. DELETE FROM Persons WHERE FirstName = 'Peter'

4. None

SQL Test: Trivia Quiz Questions!

Questions: 20 | Attempts: 999 | Last updated: Mar 20, 2023

Sample Question
A pointer is

A keyword used to create variables

A variable that stores address of an instruction

A variable that stores address of other variable

All of the above

Sybase Quiz :: 1

Quiz for SQL, T-SQL

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

Sample Question
Can Index be created on temp tables?

Yes

No

Oracle Mock Test 2 (SQL +arch)

Oracle Mock Test 2 (SQL +Arch)

Are you learning the Oracle software? Do you want to test your knowledge about Oracle? Try this interesting and well-researched Oracle mock test 2 (SQL + Arch). With this test, you'll get the chance to test your understanding...

Questions: 23 | Attempts: 6978 | Last updated: May 10, 2023

Sample Question
Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?

SELECT DISTINCT position, manager FROM employee;

SELECT position, manager DISTINCT FROM employee;

SELECT position, manager FROM employee;

SELECT position, DISTINCT manager FROM employee;

SQL And Relational Database Management

SQL and Relational Database Management

This quiz covers chapter 1 of The Practical SQL Handbook.

Questions: 39 | Attempts: 134 | Last updated: Mar 14, 2024

Sample Question
SQL is used for three kinds of operations:

Data Manipulation

Data definition

Data administration

Data projection

Data Selection

Data Convergence

SQL Course 1 70-431

End of course assessment

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.

Access Interrogation: MS Access Queries Quiz

MS Access has all that it takes to manage a whole database with its tools and features to face modern world data-related problems. Challenge yourself with scenarios that mimic real-world data challenges, from sorting and grouping...

Questions: 10 | Attempts: 1132 | Last updated: Jul 29, 2024

Sample Question
Give the correct expression operator - Numbers between 1 to 10.

Between 1 or 10

Between 1 to 10

Between 1 and 10

Between 1 - 10

« Previous 123 Next »