____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
Correct Answer :
D. NOT NULL , UNIQUE
NOT NULL and UNIQUE constraints form the core of the PRIMARY KEY constraint.
Related Questions
Global Temp Variable is used with which sign?
###
####
#
##
Which of the following statement is TRUE?
A DATABASE name can be renamed.
A TABLE name can be renamed.
Both A and B
None of the above
Which of the following clause cannot be optional in SQL SELECT Statement?
WHERE
GROUP BY
ORDER BY
None of the above
Which of the following statement is correct?
Comparison Operator has higher precedence than Conjuction Operator.
Identity Operator has higher precedence than Multiplication Operator.
Both A and B
None of the above
SQL has the advantage of?
SQL require a lot of programming.
SQL provides High-Speed Query Processing.
SQL follows the standard languages of ANSI and ISO.
SQL is easily portable.
With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange
Which statement is not true?
SQL is rational whereas No-SQL is non-rational.
SQL follows BASE Model whereas No-SQL follows ACID Model.
SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
No-SQL databases are preferable to store hierarchical data in comparison SQL databases.
Name of the control in SQL Script
Script
Owner
Opinion
All of the above
Which statement is TRUE about the HAVING Clause?
In order to group the rows, HAVING Clause is used.
In order to return the rows, HAVING Clause is used.
In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
None of the above
What will be the output of the below SQL statement?
25
26
24
20
What is the full form of BLOB?
Binary Long Objects
Binary Least Objects
Binary Large Objects
Binary Large Orientation
Which of the following is TRUE about Intrusion Detection System?
Intrusion Detection System is Network-based
Intrusion Detection System is Host-based
Both A) and B)
None of the above
Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?
Operators
Data Types
Numbers
Syntax
How many temp tables are there?
1
2
3
4
In order to update one table using another table and join condition, which statement is used.
SQL UPDATE INTO
SQL UPDATE JOIN
SQL JOIN
SQL JOIN UPDATE
What is the work of INSERT command?
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
Database objects such as tables, table views, and other objects can be deleted using this command.
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
It enables you to create new databases, tables, table views, and other objects using this command.
How can we prevent SQL Injection attack?
We should pre-define the input type, input field and length of the user data to validate the input for the user authentication.
Access privileges should be restricted for the users
Administrator accounts should not be used.
All of the above
What is the work of UPDATE command?
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Using this command, you can remove or erase recorded information from a database table.
Database data can be updated or changed using this command.
It enables you to create new databases, tables, table views, and other objects using this command.
Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
What is TRUE about NOT IN clause?
The result is purged of duplicates
Duplicate records are not removed
Performs column-by-column comparisons
None of the above
Which of the following is TRUE about SQL Auto Increment?
It increments the unique number automatically.
It decrements the unique number automatically.
It keeps the unique number constant
None of the above
A SELECT statement is intersected to use it as a join, but it only returns the records that are ________ between both statements.
Distinct
Common
Shared
Both B and C
Which of the following is/are TRUE about DDL command?
Our data is stored in a table that is described by the schema, thus DDL commands deal with the schema.
With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
Both A. and B.
None of the above
What is SQL CREATE Table used for?
To Update table
To Create table
To Delete table
None of the above
Using the SQL first() function, one can return the ____ value of the selected column.
First
Second
Third
Last
What is the work of DELETE command?
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Database data can be updated or changed using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
Using this command, you can remove or erase recorded information from a database table.
What does the DROP DATABASE Statement do?
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
A new database will be created through this SQL statement.
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.