Bissoy.com
Doctors Medicines MCQs Q&A

Which of the following is NOT a type of SQL constraint?

Which of the following is NOT a type of SQL constraint? Correct Answer ALTERNATE KEY

An ALTERNATE KEY is not a type of SQL constraint. The other options, PRIMARY KEY, FOREIGN KEY, and UNIQUE, are all types of constraints used in SQL:
PRIMARY KEY ensures that a column or set of columns uniquely identifies each row in a table.
FOREIGN KEY establishes a link between two tables, enforcing referential integrity between them.
UNIQUE constraint ensures that values in a column (or set of columns) are unique across the table, but it doesn't require that the column(s) be the primary means of identifying rows.
Option B, ALTERNATE KEY, is not a standard SQL constraint term.

Related Questions

Assuming Z and Y are the two control variables, the following are the constraints laid out for maximizing the profit: Maximize profit (P) = 8X – 5Y Subject to Constraint-1: 2X + Y ≤ 1000 Constraint-2: 3X + 4Y ≤ 2400 Constraint-3: X + Y ≤ 800 Constraint-4: X – Y ≤ 350 Constraint-5: X ≥ 0 Constraint-6: Y ≥ 0 Which of the above constraints is a redundant one and does not have any effect on the solution?
In SQL, the NOT NULL constraint can be written as a table level constraint.
In SQL, the DEFAULT constraint can also be applied as a table level constraint.
Consider the following statements in connection with deflection-type and null-type instruments: 1. Null-type instruments are more accurate than the deflection-type ones. 2. Null-type of instrument can be highly sensitive compared to a deflection-type instrument. 3. Under dynamic conditions, null-type instruments are less preferred to deflection-type instruments. 4. Response is faster in null-type instruments as compared to deflection-type instruments. Which of the above statements are correct?
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
Consider the following grammar and the semantic actions to support the inherited type declaration attributes. Let X1, X2, X3, X4, X5 and X6 be the placeholders for the non-terminals D, T, L or L1 in the following table: Production rule Semantic action D → T L X1.type = X2.type T → int T.type = int T → float T.type = float L → L1, id X3.type = X4.type addType(id.entry, X5.type) L → id addType(id.entry, X6.type)   Which one of the following are the appropriate choices for X1, X2, X3 and X4?
In the following SQL query, what does "person_id" stands for?
CREATE TABLE person(person_ id SMALLINT UNSIGNED,fname VARCHAR(20),lname VARCHAR(20),CONSTRAINT pk_person PRIMARY KEY (person_id));
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
Constraint checking can be disabled in existing _______________ and _____________ constraints so that any data you modify or add to the table is not checked against the constraint.
If the mass of the constraint is negligible and a mass is attached at the end of the rod having following values: Ic = 500 Kg-m2 and ω= 10 rad/s, then calculate the kinetic of the constraint system.