Give two examples of referential integrity constraints.
Answer Posted / monal
RELATIONSHIP BETWEEN CUSTOMERS AND ORDERS &
RELATIONSHIP BETWEEN ORDERS AND ORDERDETAILS
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What the different types of replication and why are they used? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is the diffrence between core dba and apps dba?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Where do you find the default index fill factor and how to change it? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is dbcc? : sql server DBA
What are the commands used in dcl? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
what do you understand by flashback feature of oracle?